Top "Oracle9i" questions

SQLPLUS command line with Windows batch file

I want to create a batch file which will open the SQLPLUS [CLI] and will execute some stored sql file …

batch-file sqlplus oracle9i

How do I do a manual uninstall of Oracle?

Sometimes my Oracle database on Windows gets hosed. How do I do a manual uninstall of Oracle?

database oracle oracle10g uninstallation oracle9i

ORA-00257:archiver error

When I try connecting to my database, I get the following error. ORA-00257:archiver error. Connect internal only until freed. …

oracle oracle9i ora-00257

Oracle SQL Developer: How to transpose rows to columns using PIVOT function

I'm attempting to create a query to transpose rows into columns using the PIVOT function. This is the contact table …

sql oracle pivot oracle9i

How to avoid DIVIDE BY ZERO error in an SQL query

SELECT YEAR, period, round((1- sum(rej_qty) / sum(recd_qty))*100, 0) FROM TAB_A WHERE sid = '200' AND sdid …

sql oracle9i divide-by-zero

Remove all characters after a specific character in PL/SQL

How do I get a substring from this example value: john.abc_1234 I want it to return john.abc.So …

sql oracle plsql oracle9i substr

How to manually initialize a collection of RECORDs in PL/SQL?

guys. Here's a simple sample two-dimensional array in PL/SQL, which is working perfectly. declare type a is table of …

arrays oracle plsql multidimensional-array oracle9i

Example for procedures with INOUT parameters in Oracle, PL/SQL

How can I use IN OUT parameter in a procedure. I want to give a parameter as both input and …

plsql oracle9i

Oracle - Update string to replace only the last character

I have the following string in an Oracle 9i database: A,B,C, I need to replace all instances of …

replace sql-update oracle9i substr

Hibernate > CLOB > Oracle :(

I am trying to write to an Oracle clob field a value over 4000 characters. This seams to be a common …

java oracle hibernate oracle9i clob