Top "Oracle" questions

Oracle Database is a Multi-Model Database Management System created by Oracle Corporation.

How to see refcursor result/output in Oracle SQL Developer?

Possible Duplicate: Best way/tool to get the results from an oracle package procedure Oracle SQL Developer: Show REFCURSOR Results …

oracle plsql oracle10g oracle-sqldeveloper ref-cursor
Oracle, adding leading zeros to string (not number)

I am using Oracle (work space is TOAD) and I need to make my strings that if they are shorted …

string oracle zero
How to check if a database link is valid in Oracle?

I have a main database with only setup data at the headquarter and several databases at different branches.I created …

oracle architecture dblink
Why are Oracle table/column/index names limited to 30 characters?

I can understand that many years ago there would be this kind of limitation, but nowadays surely this limit could …

oracle oracle10g size
In Oracle SQL, can I query a partition of a table instead of an entire table to make it run faster?

I would like to query a table with a million records for customers named 'FooBar' that have records dated on 7…

sql oracle select syntax partitioning
ORACLE Casting DATE to TIMESTAMP WITH TIME ZONE WITH OFFSET

I need to cast a DATE value in a query to a TIMESTAMP WITH TIME ZONE, but currently I'm getting …

sql oracle timestamp-with-timezone
What does the colon sign ":" do in a SQL query?

What does : stand for in a query? INSERT INTO MyTable (ID) VALUES (:myId) How does it fetch the desired value? …

sql oracle plsql bind-variables
ORA-12154: TNS:could not resolve the connect identifier specified

I am trying to connect to oracle 11g installed on Linux EL 5 and and getting the following error SQL> …

oracle oracle11g listener tnsnames ora-12514
ORACLE 11G UTL_FILE + UTL_FILE_DIR - Invalid Directory

Hi I am running Oracle 11 and I am trying to write to a directory on the server box using UTL_…

oracle oracle11g utl-file
How to get list of all the procedure inside a package oracle

Can I get the name of all the function inside a package. Suppose I have a package PKG_OWA and …

oracle plsql data-dictionary