OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » dynamic Query

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

dynamic Query [message #190760]

Fri, 01 September 2006 02:47

sv.venkat
Messages: 12
Registered: July 2006
Location: HYDERABAD

Junior Member

Dear Friends,
What is Dynamic Query and Temporary tables?
Pl.let me know.
Thanks in advance.
Venkat.

Report message to a moderator

Re: dynamic Query [message #190762 is a reply to message #190760]

Fri, 01 September 2006 02:50

kimant
Messages: 201
Registered: August 2006
Location: Denmark

Senior Member

Hi

This You can find in the documentation, and it is *free*!
- Even for download.

otn.oracle.com > documentation.

Br
Kim

Report message to a moderator

Re: dynamic Query [message #190971 is a reply to message #190760]

Sun, 03 September 2006 11:41

be2sp1
Messages: 52
Registered: September 2005
Location: India

Member

Dynamic query is a query that is formed at run-time of the execution of the DB object say a procedure. A very simple
example would be.......

declare
v_table varchar2(20):='EMP_copy';
begin
EXECUTE IMMEDIATE 'CREATE TABLE ' || v_table || ' as selct * from emp';
end;

On firing this block a table will be created with the same structure as of emp along with its data.

About temporary tables kindly do some search on internet you will find a lot of documentation available.

Report message to a moderator