D2K - How to see the select statement when we issue execute_query

GeekInterview.com

I am new, Sign me up!

GeekInterview.com > Interview Questions > Oracle > D2K

Go To First | Previous Question | Next Question

D2K | Question 3 of 71

Print

How to see the select statement when we issue execute_query

Total Answers and Comments: 7

Last Update: April 03, 2009

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

September 01, 2005 18:39:49

#1

Subhash

RE: How to see the select statement when we issue execute_query

Using :system.last_query

Is this answer useful? Yes | No

September 26, 2005 06:34:39

#2

venkat

RE: How to see the select statement when we issue exec...

How to see the select statement when we issue execute_query

Is this answer useful? Yes | No

October 27, 2005 06:56:05

#3

Sumanth

RE: How to see the select statement when we issue exec...

Override key exeqry with :system.last_query

Is this answer useful? Yes | No

September 14, 2006 08:19:31

#4

Venkata Ramana

RE: How to see the select statement when we issue exec...

Using Get_Block_Property('Block Name' LAST_QUERY); Built-in function we can see the query which is executed last in the form module.

Is this answer useful? Yes | No

July 01, 2007 04:04:13

#5

Member Since: July 2007 Contribution: 1

RE: How to see the select statement when we issue exec...

Using :system.last_query

Is this answer useful? Yes | No

January 12, 2009 11:55:50

#6

Member Since: January 2009 Contribution: 6

RE: How to see the select statement when we issue execute_query

BY USING :SYSTEM.LAST_QUERY;
EXAMPLE
WHEN-NEW-FORM-INSTANCE
BEGIN
execute_query;
MESSAGE(:SYSTEM LAST_RECORD);
END;
RUN THE FORM...

Is this answer useful? Yes | No

April 03, 2009 13:13:45

#7

Member Since: January 2009 Contribution: 6

RE: How to see the select statement when we issue execute_query

Using :system.last_query

Is this answer useful? Yes | No

Sponsored Links

Sponsored Links

Featured Free Offers

Request Your Copy

Request Your Copy

Request Your Copy

About Us - Privacy Policy - Terms and Conditions - Contact - Ask Question - Propose Category - Site Updates

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved