Try this..
grant select on sutdent2 to satish;
revoke select on student2 from satish;
Type: Posts; User: nathsambu; Keyword(s):
Try this..
grant select on sutdent2 to satish;
revoke select on student2 from satish;
Its very simple
after login in sql,
sql>spool d:sambu\txt and then press enter.
Now spool is on and before you logoff you need to spool off.
spool off;
All date you can see in the D drive with...
Alter table dept
add (ename varchar2(10));
For insert the value in ename colomn,
Insert into dept (ename)
value('Deepa');
Try this. I think you will getting u r answer.
Insert a new colomn in middle of the table is not possbile.
Yes , You can use..
I think this is not possible in Oracle.
Thanx a lot.