Top "Oracle" questions

What is the Oracle equivalent of SQL Server's IsNull() function?

In SQL Server we can type IsNull() to determine if a field is null. Is there an equivalent function in …

sql-server oracle tsql plsql

How to find out when an Oracle table was updated the last time

Can I find out when the last INSERT, UPDATE or DELETE statement was performed on a table in an Oracle …

oracle oracle-call-interface

Using bind variables with dynamic SELECT INTO clause in PL/SQL

I have a question regarding where bind variables can be used in a dynamic SQL statement in PL/SQL. For …

sql oracle plsql oracle11g execute-immediate

ORA-00972 identifier is too long alias column name

i have a query like : SELECT column as averyveryveryverylongalias (more than 30 characters) FROM Table_name it returns the error ORA-00972 …

sql oracle alias

ORA-12170: TNS:Connect timeout occurred

I was trying to connect to the database here in my laptop using Oracle Toad but I kept on having …

oracle toad ora-12170

How do I get column datatype in Oracle with PL-SQL with low privileges?

I have "read only" access to a few tables in an Oracle database. I need to get schema information on …

oracle plsql ddl privileges

Where does Oracle SQL Developer store connections?

I have an application that I can't get connected to my Oracle Database 11g Express Edition. I created a test …

oracle oracle11g

Oracle insert from select into table with more columns

I want to insert to a table from a select statement, however, there are 3 columns returned from the select statement …

sql oracle

How to find which version of Oracle is installed on a Linux server (In terminal)

I am in terminal in Redhat 5.5 and I need to find out which version of Oracle is installed. I am …

linux oracle rhel

How to move table from one tablespace to another in oracle 11g

I run oracle 11g and need to move table (tbl1) from one tablespace (tblspc1) to another (tblspc2). What is the …

oracle oracle11g move