Search:

as our friend said the date format is must be in like '21-aug-2007' but it depends on the dbmsystem to verify which format is supported type the command




sysdate



my friend sriram is...

desc <table_name>

my friends is it work?

desc <table_name>

eg:-alter table emp add email_add varchar2(15);
this will insert the column email_add to your table.

eg:-insert into mca values(&sid,'&sname',&dob);

at compile time