Home » SQL & PL/SQL » SQL & PL/SQL » native dynamic sql or DBMS_SQL package
native dynamic sql or DBMS_SQL package [message #41138] Fri, 29 November 2002 02:39 Go to next message
Chandan
Messages: 9
Registered: May 2002
Junior Member
Which one is best for dynamic SQL? Why? Please answer so I can take decision to use it in program.

Report message to a moderator

Re: native dynamic sql or DBMS_SQL package [message #41145 is a reply to message #41138] Sat, 30 November 2002 00:04 Go to previous messageGo to next message
Anirudh Sharma
Messages: 8
Registered: July 2002
Junior Member
Both can be usefull under diff circumstances, depends on your requirement.

Report message to a moderator

Re: native dynamic sql or DBMS_SQL package [message #41153 is a reply to message #41138] Mon, 02 December 2002 11:14 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
In general, NDS is the better choice. DBMS_SQL is needed when the number of columns or datatypes is not known prior to runtime.

Report message to a moderator

Previous Topic: To find max sal salary paid to employes in all dept.
Next Topic: foreign key constraint referencing rowid
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue May 14 21:24:01 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.