Home » SQL & PL/SQL » SQL & PL/SQL » Query Execution
Query Execution [message #2985] Wed, 28 August 2002 06:01 Go to next message
Jeff
Messages: 63
Registered: July 1999
Member
hello:

When you write a query on a Created View. What query does the DBMS actually execute?

For example:

CREATE VIEW Paperback
as Select ISBN, Title, Price
From Book

Query:

Select ISBN, Title, Price
From Paperback;

What query does the DBMS acutally execute?

Thanks

Jeff

Report message to a moderator

Re: Query Execution [message #2986 is a reply to message #2985] Wed, 28 August 2002 07:26 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
when you select a view, the defining query (of the view) is executed

Report message to a moderator

Re: Query Execution [message #2989 is a reply to message #2985] Wed, 28 August 2002 09:26 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
 
select ISBN, Title, Price
  from (select ISBN, Title, Price
          from book);

Report message to a moderator

Previous Topic: Re: Executing sqlldr from stored procedure
Next Topic: How to take "Enter" out
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 09:35:47 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.