oracle Archives - IT Nursery

oracle, Programming

IT Nursery

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 ...

June 3, 2022
0 Comments

oracle, Programming

IT Nursery

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 ...

June 2, 2022
0 Comments

oracle, Programming

IT Nursery

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

May 29, 2022
0 Comments

oracle, Programming

IT Nursery

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 ...

May 27, 2022
0 Comments

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 ...

May 25, 2022
0 Comments

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

May 22, 2022
0 Comments

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 ...

May 21, 2022
0 Comments

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 ...

May 21, 2022
0 Comments

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 ...

May 18, 2022
0 Comments

What is the difference between varchar and varchar2 in Oracle?

What is the difference between varchar and varchar2? 6 Answers 6

May 17, 2022
0 Comments