Top "Oracle" questions

Oracle Database is a Multi-Model Database Management System created by Oracle Corporation.

Oracle - Why does the leading zero of a number disappear when converting it TO_CHAR

In Oracle, when converting a number with a leading zero to a character, why does the leading number disappear? Is …

sql oracle oracle10g
SQL: how to use UNION and order by a specific select?

I have two selects: SELECT id FROM a -- returns 1,4,2,3 UNION SELECT id FROM b -- returns 2,1 I'm receiving correct …

sql oracle select union
sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory

Please suggest a solution for solving this issue?? While giving the command: sqlplus /nolog the error that occurred: sqlplus: error …

linux oracle installation sqlplus oracleclient
Get the difference between two dates both In Months and days in sql

I need to get the difference between two dates say if the difference is 84 days, I should probably have output …

sql oracle date-arithmetic
ORA-12154: TNS:could not resolve the connect identifier specified (PLSQL Developer)

I need to use PLSQL Developer to access oracle databases. I get the following error when I try to connect …

oracle plsql sqlplus plsqldeveloper tnsnames
What can cause intermittent ORA-12519 (TNS: no appropriate handler found) errors

We are running our Junit 4 test suite against Weblogic 9 in front of an Oracle 10 database (using Hudson as a continuous …

oracle junit oracle10g ora-12519
Hibernate Criteria for Dates

In oracle I have dates in format 17-April-2011 19:20:23.707000000 I would like to retrieve all orders for 17-04-2011. SimpleDateFormat formatter = …

java oracle hibernate jakarta-ee criteria
ORACLE IIF Statement

I get an error while writing the IIF statement, table and the statement given below. Statement: SELECT IIF(EMP_ID=1,…

oracle conditional-operator iif
Bulk Insert to Oracle using .NET

What is the fastest way to do Bulk insert to Oracle using .NET? I need to transfer about 160K records …

.net sql oracle bulkinsert