Top "Oracle" questions

TO_DATE returning different dates for different format masks?

I am having query on the below sql. Please help me. select to_date(sysdate, 'DD MONTH YYYY') , to_date(…

sql oracle to-date

Where can I find a complete list of predefined Oracle pl/SQL Exceptions?

Where can I find a full list of all predefined Oracle pl/SQL Exceptions? In this link i found this …

sql oracle ora-00001

Oracle use LIKE '%' on DATE

My table myTab has the column startDate, which has the datatype "DATE". The data in this column are stored like …

sql oracle date-comparison

Oracle - drop multiple table in a single query

I have fifty tables in a database, in that I need only six tables. How can I delete remaining tables …

oracle ddl

Does Oracle support full text search?

Is there an Oracle equivalent to MS SQL's full text search service? If so, has anyone implemented it and had …

oracle full-text-search oracle-text

How can I see queries that are executed against Oracle?

I need to see the queries that are being sent to Oracle to execute them. Can someone give me specific …

oracle trace logging

Java - find the first cause of an exception

I need to check if an exception is caused by some database problem. I receive an Exception and check if …

java oracle exception-handling ora-00001

View the DBMS jobs log oracle

I have a scheduled a job in DBMS jobs (not DBMS scheduler). I can see the job has failed in …

oracle dbms-job

How can I deploy a .NET application that uses ODAC without installing the whole component to the user?

I have written a C# application that connects to an Oracle 10g database. Using Oracle Data Access Component 11.2 "ODAC", it …

c# .net oracle deployment odac

bulk insert from Java into Oracle

I need to insert many small rows rapidly into Oracle. (5 fields). With MySQL, I break the inserts into groups of 100, …

java sql oracle performance bulk-operations