How do I turn off Oracle password expiration?
I’m using Oracle for development. The password for a bootstrap account that I always use to rebuild my database has expired. How do … Read more
oracle
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
I have installed Oracle 11g Express Edition Release 2 in my windows 7 64 bit OS and tried to execute JDBC program, then … Read more
What is the maximum length of a table name in Oracle?
What are the maximum length of a table name and column name in Oracle? 12 Answers 12
How can I set a custom date time format in Oracle SQL Developer?
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 … Read more
ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
Why am I getting this database error when I update a table? ERROR at line 1: ORA-00054: resource busy and acquire with NOWAIT … Read more
What is the dual table in Oracle?
I’ve heard people referring to this table and was not sure what it was about. 14 Answers 14
How to export query result to csv in Oracle SQL Developer?
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 … Read more
Oracle SQL Developer multiple table views
In Oracle SQL Developer, one can list the data in a table using the Data tab when viewing a table. there where can … Read more
ORA-12514 TNS:listener does not currently know of service requested in connect descriptor
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 … Read more
What is the difference between varchar and varchar2 in Oracle?
What is the difference between varchar and varchar2? 6 Answers 6