Home » SQL & PL/SQL » SQL & PL/SQL » query execution life cycle
query execution life cycle [message #288303] Mon, 17 December 2007 00:22 Go to next message
rajat_chaudhary
Messages: 141
Registered: November 2006
Location: india
Senior Member

hi

can anyone tell me what exactly is the query execution cycle in oracle 9i ?

e.g. when i execute a query lets say

select * from <table_name> .


Quote:

What are those areas from where the query filtered and give results (including lock concepts)?


Re: query execution life cycle [message #288311 is a reply to message #288303] Mon, 17 December 2007 01:01 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Database Concepts
Chapter 24 SQL, PL/SQL, and Java
Section Overview of SQL
Subsection SQL Processing
Paragraph SQL Statement Execution

I don't understand your quote. By the way, quote from what?

Regards
Michel
Re: query execution life cycle [message #288457 is a reply to message #288303] Mon, 17 December 2007 10:57 Go to previous messageGo to next message
gnicky
Messages: 1
Registered: December 2007
Location: hyderabad
Junior Member

select *from <table_name>;
if u type any tablename in place of <table_name> and that table has to be created in orcale server then it reterives data from server.
example :select *from emp;
Re: query execution life cycle [message #288472 is a reply to message #288457] Mon, 17 December 2007 12:42 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Huh?
@gricky, are you asking a question or is this an answer to the original question?
Whichever it is, I am unable to see what you mean.
Re: query execution life cycle [message #288805 is a reply to message #288303] Tue, 18 December 2007 14:54 Go to previous messageGo to next message
Kevin Meade
Messages: 2101
Registered: December 1999
Location: Connecticut USA
Senior Member
Quote:

Database Concepts
Chapter 24 SQL, PL/SQL, and Java
Section Overview of SQL
Subsection SQL Processing
Paragraph SQL Statement Execution


You have to like a guy who knows his manuals.
Re: query execution life cycle [message #294006 is a reply to message #288805] Wed, 16 January 2008 00:21 Go to previous messageGo to next message
rajat_chaudhary
Messages: 141
Registered: November 2006
Location: india
Senior Member

thanks GAVIN thanks a lot

for such a useful reply....
Re: query execution life cycle [message #294008 is a reply to message #294006] Wed, 16 January 2008 00:42 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Who is GAVIN?

Regards
Michel
Re: query execution life cycle [message #294070 is a reply to message #288303] Wed, 16 January 2008 05:59 Go to previous messageGo to next message
rajavu1
Messages: 1574
Registered: May 2005
Location: Bangalore , India
Senior Member

I don't think 'GAVIN' is Indian Pronouciation for 'Kevin' Meade Smile

Thumbs Up
Rajuvan
Re: query execution life cycle [message #294079 is a reply to message #288303] Wed, 16 January 2008 06:23 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
But Pronounciation is for pronunciation,,
Re: query execution life cycle [message #294081 is a reply to message #288303] Wed, 16 January 2008 06:32 Go to previous messageGo to next message
rajavu1
Messages: 1574
Registered: May 2005
Location: Bangalore , India
Senior Member

Oops , i didn't 'spell-check' while posting .
Good catch Smile

Thumbs Up
Rajuvan.

[Updated on: Wed, 16 January 2008 06:34]

Report message to a moderator

Re: query execution life cycle [message #294161 is a reply to message #288303] Wed, 16 January 2008 11:20 Go to previous message
Kevin Meade
Messages: 2101
Registered: December 1999
Location: Connecticut USA
Senior Member
truth be told, I am an identical twin. My dad could not tell us apart for the first 15 years of our lives. One day I got fed up with it and said "Dad, I'm Kevin, not Kenny, Kevin".

Now my dad was a good o'l boy from way back. Virginia, West Virginia territories. He had a southern drawl that was quite evident so Kevin was difficult for him to pronouce I guess and came out as "Kaaavin". I figured it was the best I was going to get so I smiled and accepted it as a story with high re-tell-ability.

I suppose Gavin from my Indian buddies, works for me too.

Kevin
Previous Topic: Joining tables???
Next Topic: SYSDATE Minus Minutes
Goto Forum:
  


Current Time: Sat Dec 03 01:12:43 CST 2016

Total time taken to generate the page: 0.16141 seconds