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.....
Type: Posts; User: nathsambu; Keyword(s):
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.