Home » SQL & PL/SQL » SQL & PL/SQL » need back Ground Info
need back Ground Info [message #358908] Wed, 12 November 2008 23:15 Go to next message
kpit
Messages: 1
Registered: November 2008
Junior Member
Hi One To All

Iam new to this Forum as well as Oracle allso

please clarify below questions.

1) if i have two tables like tableA,tableB
if i write a query like...

select * from A,B

in the above query which table fired first, which is next

i need background process

2) could you please give small information abt

session varibles where we can use this varibles.

please dont privede any link for refference.

thanks
KPit


Re: need back Ground Info [message #358933 is a reply to message #358908] Thu, 13 November 2008 00:48 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1) It depends on Oracle version, statistics gathered or not and these statistics.

Database Concepts
PL/SQL User's Guide and Reference
Application Developer's Guide - Fundamentals
Database Performance Tuning Guide.

Regards
Michel
Re: need back Ground Info [message #358952 is a reply to message #358933] Thu, 13 November 2008 01:03 Go to previous messageGo to next message
pablolee
Messages: 2836
Registered: May 2007
Location: Scotland
Senior Member
Micel, the OP specifically stated that you are not to provide any links for reference. Please edit your message and copy and paste the content of those links into your thread Wink
Re: need back Ground Info [message #358959 is a reply to message #358952] Thu, 13 November 2008 01:16 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Ooops! Sorry I read it "please [dont] privede any link for refference", sometimes I miss some words.

Regards
Michel
Re: need back Ground Info [message #358965 is a reply to message #358908] Thu, 13 November 2008 01:26 Go to previous message
flyboy
Messages: 1832
Registered: November 2006
Senior Member
Also I am curious, what kpit means with "back Ground Info". My closest guess is that he expects some implementation detail(s) from Oracle engineer(s) - as he does not want any links, he surely studied all of them including documentation. But, in this case, this forum is not a good place for such a question.
Previous Topic: PL/SQL procedure Error
Next Topic: alphanumeric
Goto Forum:
  


Current Time: Sat Dec 10 03:00:39 CST 2016

Total time taken to generate the page: 0.10029 seconds