Top "Oracle" questions

NLS_NUMERIC_CHARACTERS setting for decimal

I have one db setup in a test machine and second in production machine. When I run: select to_number(…

oracle oracle11g oracle-sqldeveloper

Using IS NULL or IS NOT NULL on join conditions - Theory question

Theory question here: Why does specifying table.field IS NULL or table.field IS NOT NULL not work on a …

mysql oracle theory left-join

How to create a dump with Oracle PL/SQL Developer?

I need to take dump of a user (including tables, procedures ,etc.) as FILENAME.dmp. If I create a new …

oracle plsqldeveloper

JDBC ResultSet: I need a getDateTime, but there is only getDate and getTimeStamp

I would like to get the DATETIME column from an Oracle DB Table with JDBC. Here is my code: int …

java sql oracle resultset getdate

Toad for Oracle..How to execute multiple statements?

I have some 800-1200 INSERT statements generated from an excel sheet. I want to run these in TOAD - Oracle …

oracle toad

oracle plsql: how to parse XML and insert into table

How to load a nested xml file into database table ? <?xml version="1.0" ?> <person> <row> &…

xml oracle plsql insert xml-parsing

How do I resolve this "ORA-01109: database not open" error?

I'm trying to create my own database using SQLPlus. So first I log into it as admin: sqlplus sys/sys_…

oracle sqlplus database-administration

How to change Oracle default data pump directory to import dumpfile?

I'm using impdp to import a backup. But I want change default directory dumpfile. $ impdp system/password@$ORACLE_SID schemas=…

database oracle impdp

Why does Oracle not find oci.dll?

I use TOAD 10.2.1.3 under Windows7 and get the following error: Cannot find OCI DLL: C:\Oracle\Product\11.2.0\oci.dll that …

database oracle toad

How does Subquery in select statement work in oracle

I have looked all over for an explanation, to how does the subquery in a select statement work and still …

sql oracle select group-by subquery