Hi,
Try this .......
select a.pid,a.fname,a .lname,nvl(b.ta sk,'null') from persons a,(select pid,task from tasks where task#=2) b
where a.pid=b.pid(+);
Regards
Kumarswamy...
User Profile
Collapse
-
select query is taking some time to return values
Hi,
I have a problem, i have used one condition in where clause .....
but it is taking some time to return values.......
so my procedure is taking lot of time.......
for the same table if i query with another column in where clause within fraction of second i getting values.......
This query is taking some time......
[code=oracle]
SELECT entrykey,unique key FROM frt_app.ENTRIES _WES WHERE uniquekey=94220 77251... -
ORA-00603: ORACLE server session terminated by fatal error
hi,
While updateing a column in a table,using rowid as references i am getting
error like "ORA-00603: ORACLE server session terminated by fatal".
Please can anyone tell me reason for this.
Thanks
Kumar -
No activity results to display
Show More
Leave a comment: