| Timing [message #153763] |
Wed, 04 January 2006 00:15  |
Frank
Messages: 7901
Registered: March 2000
|
Senior Member |
|
|
Test the timing and include some formatting.
SQL> create table tst (id number, name varchar2(10));
Table created.
SQL> insert into tst (id, name) values (1, 'John');
1 row created.
SQL> insert into tst (id, name) values (2, null);
1 row created.
SQL> select * from tst where not name is null;
ID NAME
---------- ----------
1 John
SQL> select * from tst where name is null;
ID NAME
---------- ----------
2
test test
|
|
|
|
| Re: Timing [message #153764 is a reply to message #153763] |
Wed, 04 January 2006 00:16  |
Frank
Messages: 7901
Registered: March 2000
|
Senior Member |
|
|
And this is my reply.
SQL> create table tst (id number, name varchar2(10));
Table created.
SQL> insert into tst (id, name) values (1, 'John');
1 row created.
SQL> insert into tst (id, name) values (2, null);
1 row created.
SQL> select * from tst where not name is null;
ID NAME
---------- ----------
1 John
SQL> select * from tst where name is null;
ID NAME
---------- ----------
2 |
|
|
|
| Re: Timing [message #153765 is a reply to message #153764] |
Wed, 04 January 2006 00:17 |
Frank
Messages: 7901
Registered: March 2000
|
Senior Member |
|
|
and another SQL> create table tst (id number, name varchar2(10));
Table created.
SQL> insert into tst (id, name) values (1, 'John');
1 row created.
SQL> insert into tst (id, name) values (2, null);
1 row created.
SQL> select * from tst where not name is null;
ID NAME
---------- ----------
1 John
SQL> select * from tst where name is null;
ID NAME
---------- ----------
2 |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
