Top "Oracle10g" questions

Oracle is an RDBMS product.

Remove Duplicates from LEFT OUTER JOIN

My question is quite similar to Restricting a LEFT JOIN, with a variation. Assuming I have a table SHOP and …

sql oracle oracle10g left-join outer-join
How do I find out when a stored procedure was last modified or compiled in Oracle?

I'm preferably looking for a SQL query to accomplish this, but other options might be useful too.

sql oracle stored-procedures plsql oracle10g
How to see refcursor result/output in Oracle SQL Developer?

Possible Duplicate: Best way/tool to get the results from an oracle package procedure Oracle SQL Developer: Show REFCURSOR Results …

oracle plsql oracle10g oracle-sqldeveloper ref-cursor
Why are Oracle table/column/index names limited to 30 characters?

I can understand that many years ago there would be this kind of limitation, but nowadays surely this limit could …

oracle oracle10g size
How can I keep Oracle SQL Developer from closing the DB connection?

Is there any way to keep Oracle SQL Developer from closing my DB connections, or to increase the timeout? Sometimes …

oracle oracle10g oracle-sqldeveloper
How can I insert multiple row into oracle database using one insert statement?

Possible Duplicate: Best way to do multi-row insert in Oracle? I have this insert statement INSERT INTO mytable VALUES ('val1…

sql oracle10g sql-insert
How can I determine if a string is numeric in SQL?

In a SQL query on Oracle 10g, I need to determine whether a string is numeric or not. How can …

sql oracle10g numeric
printing variables in pl/sql

I have the following code: DECLARE v_hire_date DATE:='30-Oct-2000'; v_six_years BOOLEAN; BEGIN IF MONTHS_…

plsql oracle10g
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
Selecting the second row of a table using rownum

I have tried the below query: select empno from ( select empno from emp order by sal desc ) where rownum = 2 This …

sql oracle oracle10g rownum