IT Nursery
I’m using Oracle for development. The password for a bootstrap account that I always use to rebuild my database has expired. How do I turn off password expiration for...
I have installed Oracle 11g Express Edition Release 2 in my windows 7 64 bit OS and tried to execute JDBC program, then I got the following error: java.sql.SQLException:...
What are the maximum length of a table name and column name in Oracle? 12 Answers 12
By default, Oracle SQL developer displays date values as 15-NOV-11. I would like to see the time part (hour/minute/second) by default. Is there a way to configure this within...
Why am I getting this database error when I update a table? ERROR at line 1: ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired 15 Answers...
I’ve heard people referring to this table and was not sure what it was about. 14 Answers 14
I’m using Oracle SQL Developer 3.0. Trying to figure out how to export a query result to a text file (preferably CSV). Right clicking on the query results window...
In Oracle SQL Developer, one can list the data in a table using the Data tab when viewing a table. there where can add, delete, edit or just viewing...
We have an application running locally where we’re experiencing the following error: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor I’ve tested the connection using...
What is the difference between varchar and varchar2? 6 Answers 6