Sample Header Ad - 728x90

Is this a new common pattern in Oracle Where exists ( Select NULL FROM...)?

8 votes
2 answers
1154 views
Years ago, it was common to write where exists (Select * from some_table where some_condition) Last year I noticed that many t-sql scripts switched to using the number 1 instead of the star where exists (Select 1 from some_table where some_condition) just on SO I saw this Oracle example WHERE EXISTS (SELECT NULL FROM ... Is this a common pattern with Oracle? And which are the performance arguments to use something like this.
Asked by bernd_k (12389 rep)
Jan 5, 2011, 04:11 PM
Last activity: Jan 7, 2011, 07:13 PM