Hi,
This is krishna,you can try this one .i think it would be correct
[code=oracle]Select E.empno,E.ename ,M.empno,M.enam e from emp E,emp M where E.mgr=M.empno;[/code]...
krishhhna
Last Activity: Feb 29 '08, 06:37 AM
Joined: Aug 25 '07
Location: bangalore
-
-
Why we used ROWNUM in group by clause
If we want to retrive 5,6,7 rows from a table,then we used rownum in a query in group by clause,but my doubt is rownum has individual values for each rows then how did you group rows based on rownum? -
Which one is used to better performance
Hi,
I have a doubt on procedure and function's,that is nI have one procedure that returns one value and function which also returns only one value. which one is better to use ,either procedure or function?? -
-
retrive morethan one value
how we can retrive more than one value by using function? could you please give me the example -
bitmap index
what is the bitmap index ? how it can be used? what is the difference between bitmap index and other indexes? -
-
here is the query to select third highest salary.
select level,max(sal) from employee where level=3 connect by prior sal > sal group by level;...Leave a comment:
-
Is DML statements are cursors?
is dml statements are cursors or not ? if yes how it is ? -
difference between binary_integer and pls_integer
i have a doubt in pl/sql table,that is what is the difference between binary_integer and pls_integer.
1..type <typename> is table of emp.empno%type index by binary_integer,
2..type <typename> is table of emp.empno%type index by binary_integer
what is the difference in above two types -
copy data into amother column
hi,
this is krishna..
how to copy one column data into another column ,both the columns are in same table..
plzzzz give me a replyyyyyLeave a comment:
-
how to copy column
hi this is krishhhna,
plzz tell me how to copy one column data into another column ,the both columns are in the same table..what is the query
No activity results to display
Leave a comment: