Home » SQL & PL/SQL » SQL & PL/SQL » Need Help!!! (merged 4)
Need Help!!! (merged 4) [message #364444] Mon, 08 December 2008 10:41 Go to next message
saic
Messages: 27
Registered: December 2008
Junior Member
Hi One to all

Iam studying MCA in india

I have some doubts for following question

may be the seniors will give some solutions

1) SELECT A.ID , B.NAME FROM A, B

which table A,200 rows
table B 300 rows

which table data fire fisrt in the select sts

2)select * from emp;
delete from emp;
select count(*) from emp;

which sts will take to much time ? why please give some different answers

3)And last question is why we are useing ref cursor ? can we use normal cursor? if not why?

please provide me the answer for above quesion...

dont send any link to refer...

thanks in advance!!!
Re: Need Help!! [message #364450 is a reply to message #364444] Mon, 08 December 2008 10:47 Go to previous messageGo to next message
S.Rajaram
Messages: 1027
Registered: October 2006
Location: United Kingdom
Senior Member
Quote:

dont send any link to refer...


I am impressed after reading this line. I don't think after reading this line it would encourage atleast me to offer any help as it shows your dedication and your patience to understand about the RDBMS.

So I wish you all the best and hopefully somebody in this forum will be kind enough to assist you with the answers. By the way could you please enlighten me what these words are if you have time. Please don't send any link to refer
Quote:

which sts will take to much time
which table data fire fisrt in the select sts


Regards

Raj
Re: Need Help!!! (merged 4) [message #364451 is a reply to message #364444] Mon, 08 December 2008 10:54 Go to previous messageGo to next message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
STOP repeating the same message but read OraFAQ Forum Guide and post accordingly.

Regards
Michel

[Edit: deleted 3 posts]

[Updated on: Mon, 08 December 2008 10:56]

Report message to a moderator

Re: Need Help!! [message #364454 is a reply to message #364450] Mon, 08 December 2008 10:57 Go to previous messageGo to next message
saic
Messages: 27
Registered: December 2008
Junior Member
Hi RajaRam

Thanks For giving this Infoamtion, please tell your from ORAFAQ author or some else?
Re: Need Help!! [message #364458 is a reply to message #364454] Mon, 08 December 2008 11:54 Go to previous messageGo to next message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
please tell your from ORAFAQ author or some else?

What does this mean?

1) it does not matter
2) it depends
3) because we need it, yes

Regards
Michel
Re: Need Help!! [message #364475 is a reply to message #364458] Mon, 08 December 2008 15:20 Go to previous message
Littlefoot
Messages: 20896
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Michel Cadot wrote on Mon, 08 December 2008 18:54
Quote:
please tell your from ORAFAQ author or some else?

What does this mean?

My built-in translator says that @saic asked S. Rajaram whether he owns this place. However, it is still in beta.
Previous Topic: Save pdf file content to BLOB field in Oracle
Next Topic: Sql
Goto Forum:
  


Current Time: Tue Dec 06 08:09:31 CST 2016

Total time taken to generate the page: 0.06767 seconds