LEFTJOIN

View All Public Scripts Login to Run Script

Statement 3

create table tab1 
( 
usr number, 
name varchar2(10) 
)

Table created.

Statement 4

create table tab2 
( 
usr number, 
name varchar2(10), 
salary number 
)

Table created.

Statement 5

insert into tab1 
values (1111, 'Jerry')

1 row(s) inserted.

Statement 6

insert into tab1 
values (2222, 'John')

1 row(s) inserted.

Statement 7

insert into tab1 
values (3333, 'Scott')

1 row(s) inserted.

Statement 8

insert into tab2 
values (1111, 'Jerry', 5001)

1 row(s) inserted.

Statement 9

insert into tab2 
values (3333, 'Jerry', NULL)

1 row(s) inserted.

Statement 12

create table tab1 
( 
usr number, 
name varchar2(10) 
)

Table created.

Statement 13

create table tab2 
( 
usr number, 
name varchar2(10), 
salary number 
)

Table created.

Statement 14

insert into tab1 
values (1111, 'Jerry')

1 row(s) inserted.

Statement 15

insert into tab1 
values (2222, 'John')

1 row(s) inserted.

Statement 16

insert into tab1 
values (3333, 'Scott')

1 row(s) inserted.

Statement 17

insert into tab2 
values (1111, 'Jerry', 5001)

1 row(s) inserted.

Statement 18

insert into tab2 
values (3333, 'Jerry', NULL)

1 row(s) inserted.

Statement 22

create table tab1 
( 
usr number, 
name varchar2(10) 
)

Table created.

Statement 23

create table tab2 
( 
usr number, 
name varchar2(10), 
salary number 
)

Table created.

Statement 24

insert into tab1 
values (1111, 'Jerry')

1 row(s) inserted.

Statement 25

insert into tab1 
values (2222, 'John')

1 row(s) inserted.

Statement 26

insert into tab1 
values (3333, 'Scott')

1 row(s) inserted.

Statement 27

insert into tab2 
values (1111, 'Jerry', 5001)

1 row(s) inserted.

Statement 28

insert into tab2 
values (3333, 'Jerry', NULL)

1 row(s) inserted.

Additional Information