Top "Oracle" questions

I just installed Oracle, and it was missing the Scott schema. So i am trying to generate it myself. I …

An update SQL query was executed on the server, which caused many problems later. How can I get the list …

What is the string concatenation operator in Oracle SQL? Are there any "interesting" features I should be careful of? (This …

I need to look up rows within a particular time frame. select * from TableA where startdate >= '12-01-2012 21:24:00…

Am I correct in understanding that CREATE OR REPLACE basically means "if the object exists, drop it, then create it …

In the Oracle PL/SQL, how to escape single quote in a string ? I tried this way, it doesn't work. …

I cannot seem to get Maven to bundle the ojdbc6.jar file into my project's war file. I have it …

Why does this simple query return 'ORA-00936: missing expression' (the database is Oracle as you can tell): SELECT * FROM transactions …

I am trying to write in a file stored in c:\ drive named vin1.txt and getting this error .Please …

What is the difference between varchar and varchar2?