Easy Learning Oracle SQL: SQL for Beginner's Guide by hu yang

Author:hu, yang [hu, yang]
Language: eng
Format: epub
Published: 2019-04-14T16:00:00+00:00

Insert data int dept

INSERT INTO dept ( id , name ) VALUES ( 1 , 'IT' );

INSERT INTO dept ( id , name ) VALUES ( 2 , 'Finance' );

Insert data into emp

INSERT INTO emp ( id , name , salary , dept_id ) VALUES ( 1 , 'David' , 6000 , 1 );

INSERT INTO emp ( id , name , salary , dept_id ) VALUES ( 2 , 'Grace' , 5000 , 1 );

INSERT INTO emp ( id , name , salary , dept_id ) VALUES ( 3 , 'James' , 6000 , 2 );

INSERT INTO emp ( id , name , salary , dept_id ) VALUES ( 4 , 'Luka' , 8000 , 2 );

Display all emp information, and they are in the name of the dept

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.