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.
|
|
|