Greetings,<BR><BR>I've used "WHERE 1=1" for a long time in dynamic where clauses in which every condition is optional, and lately I heard it suggested that this can cause full table scans by itself.
The Oracle SQL*Plus product has introduced some new features that have long been missing from this utility program, and some to support the new features. Here's a rundown of the new features in Oracle ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback