Top "Oracle" questions

Get list of all tables in Oracle?

How do I query an Oracle database to display the names of all tables in it?

sql oracle

How do I limit the number of rows returned by an Oracle query after ordering?

Is there a way to make an Oracle query behave like it contains a MySQL limit clause? In MySQL, I …

sql oracle pagination sql-limit

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 …

oracle oracle11g sqlplus ora-12514 tnsping

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 …

oracle ora-00054

Oracle SQL: Update a table with data from another table

Table 1: id name desc ----------------------- 1 a abc 2 b def 3 c adf Table 2: id name desc ----------------------- 1 x 123 2 y 345 In oracle …

sql oracle sql-update

How to create id with AUTO_INCREMENT on Oracle?

It appears that there is no concept of AUTO_INCREMENT in Oracle, up until and including version 11g. How can …

sql oracle auto-increment

Oracle SELECT TOP 10 records

I have an big problem with an SQL Statement in Oracle. I want to select the TOP 10 Records ordered by …

sql oracle top-n

SQL error "ORA-01722: invalid number"

A very easy one for someone, The following insert is giving me the ORA-01722: invalid number why? INSERT INTO CUSTOMER …

sql oracle plsql casting type-conversion

Calculate difference between 2 date / times in Oracle SQL

I have a table as follows: Filename - varchar Creation Date - Date format dd/mm/yyyy hh24:mi:ss …

oracle date-arithmetic

How do I list all the columns in a table?

For the various popular database systems, how do you list all the columns in a table?

sql mysql sql-server database oracle