| dbms_sql package [message #37818] |
Thu, 28 February 2002 19:06  |
krishna
Messages: 141
Registered: October 1998
|
Senior Member |
|
|
|
Am i right in understanding that dbms_sql package is an earlier version of dynamic sql and that it is native dynamic sql that is preferred these days to dbms_sql package?
|
|
|
|
| Re: dbms_sql package [message #37822 is a reply to message #37818] |
Thu, 28 February 2002 20:04  |
Todd Barry
Messages: 4819
Registered: August 2001
|
Senior Member |
|
|
You can do most all dynamic SQL with NDS and it is certainly cleaner to code and easier to read. There are a few things that DBMS_SQL can do that NDS cannot, but NDS should handle 99.9% of your dynamic SQL needs.
And before you can ask "What does DBMS_SQL do that NDS cannot?", I will refer you to Tom Kyte's book 'Expert One-on-One Oracle' which has a very thorough chapter dedicated to dynamic SQL.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
