Top "Oracle" questions

Creating a new database and new connection in Oracle SQL Developer

I've installed SQL Developer on my system. No connections are being shown in my system yet. How do I create …

sql oracle database-connection oracle-sqldeveloper

How to convert Rows to Columns in Oracle?

I have a table in this form (this is just the partial view, the table contains more than 100 columns). LOAN …

sql oracle pivot

Explicitly set column value to null SQL Developer

I am new to Oracle DB and I am using Oracle SQL Developer (Ver 3.0.02) to query the DB. I wanted …

oracle null oracle11g oracle-sqldeveloper plsqldeveloper

How can I drop a "not null" constraint in Oracle when I don't know the name of the constraint?

I have a database which has a NOT NULL constraint on a field, and I want to remove this constraint. …

oracle plsql constraints

SQLRecoverableException: I/O Exception: Connection reset

Yesterday evening I left the office with a running Java program written by me. It should insert a lot of …

java oracle ioexception connection-reset

ORA-01008: not all variables bound. They are bound

I have come across an Oracle problem for which I have so far been unable to find the cause. The …

c# oracle data-binding oracle9i ora-01008

Oracle pl-sql escape character (for a " ' ")

When I am trying to execute INSERT statement in oracle, I got SQL Error: ORA-00917: missing comma error because there …

oracle escaping oracle11g

How can I get all sequences in an Oracle database?

Is there any command that I can run so that I can get all the sequences? I am using Oracle 11…

sql database oracle sequence toad

Oracle SqlPlus - saving output in a file but don't show on screen

Using SqlPlus for Oracle, how do I save the output of a query in a file but not show it …

oracle sqlplus

How to get the employees with their managers

This is what I want the output to look like: Employee Emp# Manager Mgr# BLAKE 7698 KING 7839 CLARK 7782 KING 7839 JONES 7566 KING 7839 …

sql oracle sqlplus