Home » Other » Test » Timing
Timing [message #153763] Wed, 04 January 2006 00:15 Go to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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
Re: Timing [message #153930 is a reply to message #153765] Thu, 05 January 2006 00:11 Go to previous message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Another timing test...

Edit: This one posted in less than 2 seconds.
Previous Topic: Uploading Master-Detail data from XML file to Oracle tables
Next Topic: Time and time again...
Goto Forum:
  


Current Time: Fri Mar 29 08:51:06 CDT 2024