Then you need to try this (http://www.toadsoft.com/lic_agree.html).

TOAD does not come in that price range.

How much you are ready to invest for the tool ?

if you are ready to pay use TOAD or PLSQL DEVELOPER, the best possible tools in market.

Try the following sample code.

SELECT code,substr(code,instr(code,'-',1)+1,2) from table_name;

you nee to create a table with check constraint and default values.

try this

create TABLE table1
(ID INT,
status varchar2(10) DEFAULT 'Available',
CONSTRAINT con_chk1 CHECK (status IN...

the syntax that you are using is not Oracle syntax.

then you need to populate records from the source to a staging (intermediate) table before actually inserting them to your main table.

so with each load you need to truncate your table and load...

The simplest method will be create a view based on the table with last five days record. That will be always refreshed every time you run any query on the view.

please find the connectionstring at

http://www.connectionstrings.com/?carrier=oracle

i also can't find anything like that on sql developer 1.2.1

If you are familar with oracle procedures then you just need to take care of the syntax and just implement the logic in PLSQL.

using the cache increases the performance but that can create problem in some circumstances also.

There are other better GUI tools like TOAD and PLSQL DEVELOPER but you need to purchase those.

You can use the inbuild tool SQL*PLUS. if you want GUI then can download and use SQL DEVELOPER for free from oracle site.

You need to parse sysdate+1+2/24+20/(24*60) to proper format before processing in database.

Are you able to connect to the database from windows PC ?

Please findout the details here (http://www.connectionstrings.com/?carrier=oracle)

To connect TOAD to oracle you simply need to pass the username ,password and the database name. IF connecting to any other server ,you need to midify the entries in the TNSNAMES.ORA file.

First of all Create is a DDL.
So commit is not required for that.
Check to ensure that you created the table in that schema.

You can start with anything simple. But you should have functional knowledge of the same.
can go for as simple as library managemnet or somthing similar.

Dear shweta
My company pays me for each line of code i write. How do you expect someone writing all the code for you that to in a free forum like this. You need to develop your own project by...

That is because both the variables P_ID and P_NAME are IN type variables. So you cant asign value to a In type variable in a select into statment.

can u kindly mention what is the datbase u want to use.

I does for DML opeartions. And status changes for DDL.

Please post your question clearly , what exactly is your requirment.

try using the predefined package dbms_lob to get some info regarding that.