RE: PL/SQL- use of ALL /ANY
Posted by ~Ray @ 2007-11-09 17:32:20
About oracle-sql-lThe ITtoolbox Oracle-SQL-L group is for the discussion of issues and concerns related to Oracle SQL and PL/SQL. Sample topics of discussion consider writing and tuning queries triggers conversions and basic SQL and PL/SQL questions.
do by this text box. It is used to sight spammers. If you register anything into this text box no examine results will be displayed.
do by this text box. It is used to sight spammers. If you enter anything into this text box no examine results ordain be displayed.
It is generally more efficient to use an outer join and a filter where joinvalue is null than to use a correlated sub query:From TS. TD where TS key = TD key(+) and TD key is null
It is generally more efficient to use an outer join and a.. reply from on 9/10/2007 10:26:00 AM -- current message
The information entered on this summon is required only to route your message to the appropriate people. It will not be used to displace unsolicited telecommunicate and ordain not be sold to a 3rd party. Please to read our detailed privacy policy.
It is generally more efficient to use an outer join and a separate where joinvalue is null than to use a correlated sub query:From TS. TD where TS key = TD key(+) and TD key is null
You must be logged in to use the Blog-to-ITtoolbox Journal feature. gratify or for an ITtoolbox be. You ordain be returned to this page after logging in.
Copyright © 1998-2007 Information Technology Toolbox. Inc. All product names are trademarks of their respective companies. Information Technology Toolbox. Inc is not affiliated with or endorsed by any company listed at this place.[ADVERTHERE]Related article:
http://oracle.ittoolbox.com/groups/technical-functional/oracle-sql-l/1605247&rss=1
0 Comments:
No comments have been posted yet!
|
