Search:

Hi, in emp table you don't mentioned the empname column. Only mentioned empid. If you using self join then its possible. But as per u r questeen it is not possible.... Regards, sambu.....

1. Instr finds the neumeric of a named character.
For ex: select instr('sambu','m') from dual.
You will getting the answer is 3.


SQL> select instr('sambu','m') from dual;

INSTR('SAMBU','M')...

Hi All ! I am created a tablespace as well as a temporary tablespace. Also I am created a default temporary tablespace. My questeen is "Temporary tablespace can be deleted or not."

And one more...

Try this..
grant select on sutdent2 to satish;
revoke select on student2 from satish;

Its very simple..try this..

select to_char('date1' , 'date2') from tablename;

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.