Top "Oracle11g" questions

USE DATABASE command on SQL PLUS ORACLE 11gr1

After successfully installing ORACLE 11gR1 on Windows7 32bit platform, I can go inside the SQL PLUS and I can also …

oracle oracle11g

Difference between oracle DATE and TIMESTAMP

What are the difference between Oracle DATE and TIMESTAMP type? Both have date and time component? Also what is corresponding …

oracle jdbc oracle11g

Get the number of days between two dates in Oracle, inclusive of the dates

I want to get total number of days between two provided dates. I've tried the below query but didn't get …

oracle oracle11g date-arithmetic

How to add a sequence column to an existing table with records

I had created a new table named USERLOG with two fields from a previous VIEW. The table already consist of …

sql oracle11g

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 rightmost 10 places of a string in oracle

I am trying to fetch an id from an oracle table. It's something like TN0001234567890345. What I want is to …

sql oracle sorting oracle11g

Get started link does not work in oracle 11g server

I have started using Oracle database server on Windows 7 64 bit OS and I have encountered the following error. "Error- Windows …

windows oracle oracle11g oracle-apex

Joining tables in Oracle (multiple outer joins)

I am trying to convert an Informix query to Oracle: The Informix query looks like this: SELECT r.aa, n.…

sql join oracle11g informix

Any online website to execute pl sql programs

I want to execute programs of PL/SQL on-line. Can any one suggest me website to do it?

sql plsql oracle11g saas