SophiaPretty

(5)

$14/per page/Negotiable

About SophiaPretty

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Accounting,Algebra See all
Accounting,Algebra,Applied Sciences,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Communications,Computer Science,Economics,Engineering,English,Environmental science,Essay writing Hide all
Teaching Since: Jul 2017
Last Sign in: 304 Weeks Ago, 6 Days Ago
Questions Answered: 15833
Tutorials Posted: 15827

Education

  • MBA,PHD, Juris Doctor
    Strayer,Devery,Harvard University
    Mar-1995 - Mar-2002

Experience

  • Manager Planning
    WalMart
    Mar-2001 - Feb-2009

Category > Computer Science Posted 02 Dec 2017 My Price 10.00

Download the demo.sql file from Doc Sharing.

Download the demo.sql file from Doc Sharing. Run demo.sql in the MySQL. This will create some tables and insert data into them. Write SQL statements to solve the following requests.

 

Write a SQL statement that uses the CAST function that converts a number datatype to a varchar datatype.

 

Write a SQL statement that converts a date datatype to a char datatype.

 

Write a SQL statement that converts a number value to a character.DROP TABLE IF EXISTS EMP;
DROP TABLE IF EXISTS DEPT;
DROP TABLE IF EXISTS BONUS;
DROP TABLE IF EXISTS SALGRADE;
DROP TABLE IF EXISTS DUMMY;
DROP TABLE IF EXISTS STUDENT;
DROP TABLE IF EXISTS INSTRUCTOR;
DROP TABLE IF EXISTS COURSE;
DROP TABLE IF EXISTS ENROLLMENT;
DROP TABLE IF EXISTS SECTION;
DROP TABLE IF EXISTS ZIPCODE;

CREATE TABLE EMP
       (EMPNO INTEGER NOT NULL,
        ENAME VARCHAR(10),
        JOB VARCHAR(9),
        MGR INTEGER ,
        HIREDATE DATE,
        SAL INTEGER ,
        COMM INTEGER ,
        DEPTNO INTEGER );

INSERT INTO EMP VALUES         (7369, 'SMITH',  'CLERK', 7902,'1980-12-17',  800, NULL, 20);
INSERT INTO EMP VALUES        (7499, 'ALLEN',  'SALESMAN',  7698,'1981-02-20', 1600,  300, 30);
INSERT INTO EMP VALUES        (7521, 'WARD',   'SALESMAN',  7698,'1981-02-22', 1250,  500, 30);
INSERT INTO EMP VALUES        (7566, 'JONES',  'MANAGER',   7839,'1981-04-02',  2975, NULL, 20);
INSERT INTO EMP VALUES        (7654, 'MARTIN', 'SALESMAN',  7698,'1981-05-01', 1250, 1400, 30);
INSERT INTO EMP VALUES        (7698, 'BLAKE',  'MANAGER',   7839,'1981-06-09',  2850, NULL, 30);
INSERT INTO EMP VALUES        (7782, 'CLARK',  'MANAGER',   7839,'1981-06-09',  2450, NULL, 10);
INSERT INTO EMP VALUES        (7788, 'SCOTT',  'ANALYST',   7566,'1982-12-09', 3000, NULL, 20);
INSERT INTO EMP VALUES        (7839, 'KING',   'PRESIDENT', NULL,'1981-11-17', 5000, NULL, 10);
INSERT INTO EMP VALUES        (7844, 'TURNER', 'SALESMAN',  7698,'1981-09-08',  1500,    0, 30);
INSERT INTO EMP VALUES        (7876, 'ADAMS',  'CLERK',     7788,'1983-01-12', 1100, NULL, 20);
INSERT INTO EMP VALUES        (7900, 'JAMES',  'CLERK',     7698,'1981-12-03',   950, NULL, 30);
INSERT INTO EMP VALUES        (7902, 'FORD',   'ANALYST',   7566,'1981-12-03',  3000, NULL, 20);
INSERT INTO EMP VALUES        (7934, 'MILLER', 'CLERK',     7782,'1982-01-23', 1300, NULL, 10);

CREATE TABLE DEPT
       (DEPTNO INTEGER,
        DNAME VARCHAR(14),
        LOC VARCHAR(13) );

INSERT INTO DEPT VALUES (10, 'ACCOUNTING', 'NEW YORK');
INSERT INTO DEPT VALUES (20, 'RESEARCH',   'DALLAS');
INSERT INTO DEPT VALUES (30, 'SALES',      'CHICAGO');
INSERT INTO DEPT VALUES (40, 'OPERATIONS', 'BOSTON');


CREATE TABLE STUDENT
 (STUDENT_ID INT COMMENT 'The unique ID for a student.'
 ,SALUTATION VARCHAR(5) COMMENT 'The student''s title (Ms., Mr., Dr., etc.).'
 ,FIRST_NAME VARCHAR(25) COMMENT 'This student''s first name.'
 ,LAST_NAME VARCHAR(25) COMMENT 'This student''s last name.'
 ,STREET_ADDRESS VARCHAR(50) COMMENT 'The student''s street address.'
 ,ZIP VARCHAR(5) COMMENT 'The postal zip code for this student.'
 ,PHONE VARCHAR(15) COMMENT 'The phone number for this student including area code.'
 ,EMPLOYER VARCHAR(50) COMMENT 'The name of the company where this student is employed.'
 ,REGISTRATION_DATE DATETIME COMMENT 'The date this student registered in the program.'
 ,CREATED_BY VARCHAR(30) COMMENT 'Audit column - indicates user who inserted data.'
 ,CREATED_DATE DATETIME COMMENT 'Audit column - indicates date of insert.'
 ,MODIFIED_BY VARCHAR(30) COMMENT 'Audit column - indicates who made last update.'
 ,MODIFIED_DATE DATETIME COMMENT 'Audit column - date of last update.'
 );

INSERT INTO STUDENT VALUES (102,'Mr.','Fred','Crocitto','101-09 120th St.','11419','718-555-5555','Albert Hildegard Co.','2003-01-22','BROSENZWEIG',STR_TO_DATE('2003-01-22 00:00:00','%d-MON-YYYY HH24:MI:SS'),'BROSENZW',STR_TO_DATE('2003-01-22 00:00:00','%d-MON-YYYY HH24:MI:SS'));
INSERT INTO STUDENT VALUES (103,'Ms.','J.','Landry','7435 Boulevard East #45','02124','201-555-5555','Albert Hildegard Co.','2003-01-22','BROSENZWEIG',STR_TO_DATE('2003-01-22 00:00:00','%d-MON-YYYY HH24:MI:SS'),'BROSENZW',STR_TO_DATE('2003-01-22 00:00:00','%d-MON-YYYY HH24:MI:SS'));   
INSERT INTO STUDENT VALUES (104,'Ms.','Laetia','Enison','144-61 87th Ave','11435','718-555-5555','Albert Hildegard Co.','2003-01-22','BROSENZWEIG',STR_TO_DATE('2003-01-22 00:00:00','%d-MON-YYYY HH24:MI:SS'),'BROSENZW',STR_TO_DATE('2003-01-22 00:00:00','%d-MON-YYYY HH24:MI:SS'));  
INSERT INTO STUDENT VALUES (105,'Mr.','angel','moskowitz','320 John St.','07024','201-555-5555','Alex. & Alexander','2003-01-22','BROSENZWEIG',STR_TO_DATE('2003-01-22 00:00:00','%d-MON-YYYY HH24:MI:SS'),'BROSENZW',STR_TO_DATE('2003-01-22 00:00:00','%d-MON-YYYY HH24:MI:SS'));
INSERT INTO STUDENT VALUES (106,'Ms.','Judith','Olvsade','29 Elmwood Ave.','07042','201-555-5555','Competrol Real Estate','2003-01-22','BROSENZWEIG',STR_TO_DATE('2003-01-22 00:00:00','%d-MON-YYYY HH24:MI:SS'),'BROSENZW',STR_TO_DATE('2003-01-22 00:00:00','%d-MON-YYYY HH24:MI:SS'));   
INSERT INTO STUDENT VALUES (214,'Ms.','Yvonne','Williams','80-20 4th Ave.  #A3','10004','718-555-5555','Iarriott Hotels','05-FEB-03','BROSENZWEIG',STR_TO_DATE('05-FEB-2003 00:00:00','%d-MON-YYYY HH24:MI:SS'),'BROSENZW',STR_TO_DATE('08-FEB-2003 00:00:00','%d-MON-YYYY HH24:MI:SS'));
insert INTO STUDENT VALUES (232,'Ms.','Janet','Jung','118-18 Union Tpke #3K','10015','718-555-5555','Plannning, Health S.','08-FEB-03','BROSENZWEIG',STR_TO_DATE('08-FEB-2003 00:00:00','%d-MON-YYYY HH24:MI:SS'),'BROSENZW',STR_TO_DATE('11-FEB-2003 00:00:00','%d-MON-YYYY HH24:MI:SS'));    


CREATE TABLE INSTRUCTOR
 (INSTRUCTOR_ID INT COMMENT 'The unique ID for an instructor.'
 ,SALUTATION VARCHAR(5) COMMENT 'This instructor''s title (Mr., Ms., Dr., Rev., etc.)'
 ,FIRST_NAME VARCHAR(25) COMMENT 'This instructor''s first name.'
 ,LAST_NAME VARCHAR(25) COMMENT 'This instructor''s last name'
 ,STREET_ADDRESS VARCHAR(50) COMMENT 'This Instructor''s street address.'
 ,ZIP VARCHAR(5) COMMENT 'The postal zip code for this instructor.'
 ,PHONE VARCHAR(15) COMMENT 'The phone number for this instructor including area code.'
 ,CREATED_BY VARCHAR(30) COMMENT 'Audit column - indicates user who inserted data.'
 ,CREATED_DATE DATETIME COMMENT 'Audit column - indicates date of insert.'
 ,MODIFIED_BY VARCHAR(30) COMMENT 'Audit column - indicates who made last update.'
 ,MODIFIED_DATE DATETIME COMMENT 'Audit column - date of last update.'
 );

INSERT INTO INSTRUCTOR VALUES (101,'Mr','Fernand','Hanks','100 East 87th','10015','2125551212','ESILVEST',STR_TO_DATE('02-JAN-2003 00:00:00','%d-MON-YYYY HH24:MI:SS'),'ESILVEST',STR_TO_DATE('02-JAN-2003 00:00:00','%d-MON-YYYY HH24:MI:SS'));    
INSERT INTO INSTRUCTOR VALUES (102,'Mr','Tom','Wojick','518 West 120th','10025','2125551212','ESILVEST',STR_TO_DATE('02-JAN-2003 00:00:00','%d-MON-YYYY HH24:MI:SS'),'ESILVEST',STR_TO_DATE('02-JAN-2003 00:00:00','%d-MON-YYYY HH24:MI:SS'));
INSERT INTO INSTRUCTOR VALUES (103,'Ms','Nina','Schorin','210 West 101st','10025','2125551212','ESILVEST',STR_TO_DATE('02-JAN-2003 00:00:00','%d-MON-YYYY HH24:MI:SS'),'ESILVEST',STR_TO_DATE('02-JAN-2003 00:00:00','%d-MON-YYYY HH24:MI:SS'));    
INSERT INTO INSTRUCTOR VALUES (104,'Mr','Gary','Pertez','34 Sixth Ave','10035','2125551212','ESILVEST',STR_TO_DATE('02-JAN-2003 00:00:00','%d-MON-YYYY HH24:MI:SS'),'ESILVEST',STR_TO_DATE('02-JAN-2003 00:00:00','%d-MON-YYYY HH24:MI:SS'));  
INSERT INTO INSTRUCTOR VALUES (105,'Ms','Anita','Morris','34 Maiden Lane','10015','2125551212','ESILVEST',STR_TO_DATE('02-JAN-2003 00:00:00','%d-MON-YYYY HH24:MI:SS'),'ESILVEST',STR_TO_DATE('02-JAN-2003 00:00:00','%d-MON-YYYY HH24:MI:SS'));    
INSERT INTO INSTRUCTOR VALUES (106,'Rev','Todd','Smythe','210 West 101st','10025','2125551212','ESILVEST',STR_TO_DATE('02-JAN-2003 00:00:00','%d-MON-YYYY HH24:MI:SS'),'ESILVEST',STR_TO_DATE('02-JAN-2003 00:00:00','%d-MON-YYYY HH24:MI:SS'));    
INSERT INTO INSTRUCTOR VALUES (107,'Dr','Marilyn','Frantzen','254 Bleeker','10005','2125551212','ESILVEST',STR_TO_DATE('02-JAN-2003 00:00:00','%d-MON-YYYY HH24:MI:SS'),'ESILVEST',STR_TO_DATE('02-JAN-2003 00:00:00','%d-MON-YYYY HH24:MI:SS'));   
INSERT INTO INSTRUCTOR VALUES (108,'Mr','Charles','Lowry','518 West 120th','10025','2125551212','ESILVEST',STR_TO_DATE('02-JAN-2003 00:00:00','%d-MON-YYYY HH24:MI:SS'),'ESILVEST',STR_TO_DATE('02-JAN-2003 00:00:00','%d-MON-YYYY HH24:MI:SS'));   
INSERT INTO INSTRUCTOR VALUES (109,'Hon','Rick','Chow','56 10th Avenue','10015','2125551212','ESILVEST',STR_TO_DATE('02-JAN-2003 00:00:00','%d-MON-YYYY HH24:MI:SS'),'ESILVEST',STR_TO_DATE('02-JAN-2003 00:00:00','%d-MON-YYYY HH24:MI:SS'));
INSERT INTO INSTRUCTOR VALUES (110,'Ms','Irene','Willig','415 West 101st',NULL,'(213)456-1212','ARISCHER',STR_TO_DATE('11-MAR-2003 00:00:00','%d-MON-YYYY HH24:MI:SS'),'ARISCHER',STR_TO_DATE('11-MAR-2003 00:00:00','%d-MON-YYYY HH24:MI:SS'));  

CREATE TABLE COURSE
 (COURSE_NO INT COMMENT 'The unique ID for a course.'
 ,DESCRIPTION VARCHAR(50) COMMENT 'The full name for this course.'
 ,COST DECIMAL(9,2) COMMENT 'The dollar amount charged for enrollment in this course.'
 ,PREREQUISITE INT COMMENT 'The ID number of the course which must be taken as a prerequisite to this course.'
 ,CREATED_BY VARCHAR(30) COMMENT 'Audit column - indicates user who inserted data.'
 ,CREATED_DATE DATETIME COMMENT 'Audit column - indicates date of insert.'
 ,MODIFIED_BY VARCHAR(30) COMMENT 'Audit column - indicates who made last update.'
 ,MODIFIED_DATE DATETIME COMMENT 'Audit column - date of last update.'
 );

INSERT INTO COURSE VALUES (10,'DP Overview',1195,NULL,'DSCHERER',('29-MAR-2003'),'ARISCHER',STR_TO_DATE('05-APR-2003 20:14:33','%d-MON-YYYY HH24:MI:SS'));   
INSERT INTO COURSE VALUES (20,'Intro to Computers',1195,NULL,'DSCHERER',STR_TO_DATE('29-MAR-2003 20:14:33','%d-MON-YYYY HH24:MI:SS'),'ARISCHER',STR_TO_DATE('05-APR-2003 20:14:33','%d-MON-YYYY HH24:MI:SS'));
INSERT INTO COURSE VALUES (25,'Intro to Programming',1195,140,'DSCHERER',STR_TO_DATE('29-MAR-2003 20:14:33','%d-MON-YYYY HH24:MI:SS'),'ARISCHER',STR_TO_DATE('05-APR-2003 20:14:33','%d-MON-YYYY HH24:MI:SS'));
INSERT INTO COURSE VALUES (80,'Structured Programming Techniques',1595,204,'DSCHERER',STR_TO_DATE('29-MAR-2003 20:14:33','%d-MON-YYYY HH24:MI:SS'),'ARISCHER',STR_TO_DATE('05-APR-2003 20:14:33','%d-MON-YYYY HH24:MI:SS'));   
INSERT INTO COURSE VALUES (100,'Hands-On Windows',1195,20,'DSCHERER',STR_TO_DATE('29-MAR-2003 20:14:33','%d-MON-YYYY HH24:MI:SS'),'ARISCHER',STR_TO_DATE('05-APR-2003 20:14:33','%d-MON-YYYY HH24:MI:SS'));    


CREATE TABLE ENROLLMENT
 (STUDENT_ID INT COMMENT 'The unique ID for a student.'
 ,SECTION_ID INT COMMENT 'The unique ID for a section.'
 ,ENROLL_DATE DATETIME COMMENT 'The date this student registered for this section.'
 ,FINAL_GRADE SMALLINT COMMENT 'The final grade given to this student for all work in this section (class).'
 ,CREATED_BY VARCHAR(30) COMMENT 'Audit column - indicates user who inserted data.'
 ,CREATED_DATE DATETIME COMMENT 'Audit column - indicates date of insert.'
 ,MODIFIED_BY VARCHAR(30) COMMENT 'Audit column - indicates who made last update.'
 ,MODIFIED_DATE DATETIME COMMENT 'Audit column - date of last update.'
 );

INSERT INTO ENROLLMENT VALUES (214,86,STR_TO_DATE('30-JAN-2003 10:18:00','%d-MON-YYYY HH24:MI:SS'),NULL,'JAYCAF',STR_TO_DATE('03-NOV-2003 00:00:00','%d-MON-YYYY HH24:MI:SS'),'CBRENNAN',STR_TO_DATE('12-DEC-2003 00:00:00','%d-MON-YYYY HH24:MI:SS'));
INSERT INTO ENROLLMENT VALUES (214,155,STR_TO_DATE('30-JAN-2003 10:18:00','%d-MON-YYYY HH24:MI:SS'),NULL,'JAYCAF',STR_TO_DATE('03-NOV-2003 00:00:00','%d-MON-YYYY HH24:MI:SS'),'CBRENNAN',STR_TO_DATE('12-DEC-2003 00:00:00','%d-MON-YYYY HH24:MI:SS'));
INSERT INTO ENROLLMENT VALUES (106,99,STR_TO_DATE('30-JAN-2003 10:18:00','%d-MON-YYYY HH24:MI:SS'),NULL,'JAYCAF',STR_TO_DATE('03-NOV-2003 00:00:00','%d-MON-YYYY HH24:MI:SS'),'CBRENNAN',STR_TO_DATE('12-DEC-2003 00:00:00','%d-MON-YYYY HH24:MI:SS'));
INSERT INTO ENROLLMENT VALUES (232,99,STR_TO_DATE('21-FEB-2003 10:22:00','%d-MON-YYYY HH24:MI:SS'),NULL,'DSCHERER',STR_TO_DATE('14-DEC-2003 00:00:00','%d-MON-YYYY HH24:MI:SS'),'BROSENZW',STR_TO_DATE('05-JAN-2004 00:00:00','%d-MON-YYYY HH24:MI:SS'));
INSERT INTO ENROLLMENT VALUES (232,101,STR_TO_DATE('21-FEB-2003 10:22:00','%d-MON-YYYY HH24:MI:SS'),NULL,'DSCHERER',STR_TO_DATE('14-DEC-2003 00:00:00','%d-MON-YYYY HH24:MI:SS'),'BROSENZW',STR_TO_DATE('05-JAN-2004 00:00:00','%d-MON-YYYY HH24:MI:SS'));    

CREATE TABLE SECTION
 (SECTION_ID INT COMMENT 'The unique ID for a section.'
 ,COURSE_NO INT COMMENT 'The course number for which this is a section.'
 ,SECTION_NO SMALLINT COMMENT 'The individual section number within this course.'
 ,START_DATE_TIME DATETIME COMMENT 'The date and time on which this section meets.'
 ,LOCATION VARCHAR(50) COMMENT 'The meeting room for the section.'
 ,INSTRUCTOR_ID INT COMMENT 'The ID number of the instructor who teaches this section.'
 ,CAPACITY SMALLINT COMMENT 'The maximum number of students allowed in this section.'
 ,CREATED_BY VARCHAR(30) COMMENT 'Audit column - indicates user who inserted data.'
 ,CREATED_DATE DATETIME COMMENT 'Audit column - indicates date of insert.'
 ,MODIFIED_BY VARCHAR(30) COMMENT 'Audit column - indicates who made last update.'
 ,MODIFIED_DATE DATETIME COMMENT 'Audit column - date of last update.'
 );

INSERT INTO SECTION VALUES (79,350,3,STR_TO_DATE('14-APR-2003 09:30:00','%d-MON-YYYY HH24:MI:SS'),'L509',107,25,'CBRENNAN',STR_TO_DATE('02-JAN-2003 00:00:00','%d-MON-YYYY HH24:MI:SS'),'CBRENNAN',STR_TO_DATE('02-JAN-2003 00:00:00','%d-MON-YYYY HH24:MI:SS'));
INSERT INTO SECTION VALUES (80,10,2,STR_TO_DATE('24-APR-2003 09:30:00','%d-MON-YYYY HH24:MI:SS'),'L214',102,15,'CBRENNAN',STR_TO_DATE('02-JAN-2003 00:00:00','%d-MON-YYYY HH24:MI:SS'),'CBRENNAN',STR_TO_DATE('02-JAN-2003 00:00:00','%d-MON-YYYY HH24:MI:SS'));  
INSERT INTO SECTION VALUES (81,20,2,STR_TO_DATE('24-JUL-2003 09:30:00','%d-MON-YYYY HH24:MI:SS'),'L210',103,15,'CBRENNAN',STR_TO_DATE('02-JAN-2003 00:00:00','%d-MON-YYYY HH24:MI:SS'),'CBRENNAN',STR_TO_DATE('02-JAN-2003 00:00:00','%d-MON-YYYY HH24:MI:SS'));  
INSERT INTO SECTION VALUES (82,20,4,STR_TO_DATE('03-MAY-2003 09:30:00','%d-MON-YYYY HH24:MI:SS'),'L214',104,15,'CBRENNAN',STR_TO_DATE('02-JAN-2003 00:00:00','%d-MON-YYYY HH24:MI:SS'),'CBRENNAN',STR_TO_DATE('02-JAN-2003 00:00:00','%d-MON-YYYY HH24:MI:SS'));  
INSERT INTO SECTION VALUES (83,20,7,STR_TO_DATE('11-JUN-2003 09:30:00','%d-MON-YYYY HH24:MI:SS'),'L509',105,25,'CBRENNAN',STR_TO_DATE('02-JAN-2003 00:00:00','%d-MON-YYYY HH24:MI:SS'),'CBRENNAN',STR_TO_DATE('02-JAN-2003 00:00:00','%d-MON-YYYY HH24:MI:SS'));  

PROMPT Creating Table 'ZIPCODE'
CREATE TABLE ZIPCODE
 (ZIP VARCHAR(5) COMMENT 'The zip code number, unique for a city and state.'
 ,CITY VARCHAR(25) COMMENT 'The city name for this zip code.'
 ,STATE VARCHAR(2) COMMENT 'The postal abbreviation for the US state.'
 );


INSERT INTO ZIPCODE VALUES ('10004','New York','NY');
INSERT INTO ZIPCODE VALUES ('10015','New York','NY');
INSERT INTO ZIPCODE VALUES ('10017','New York','NY');
INSERT INTO ZIPCODE VALUES ('10019','New York','NY');
INSERT INTO ZIPCODE VALUES ('10025','New York','NY');
INSERT INTO ZIPCODE VALUES ('00914','Santurce','PR');
INSERT INTO ZIPCODE VALUES ('01247','North Adams','MA');  
INSERT INTO ZIPCODE VALUES ('02124','Worchester','MA');   
INSERT INTO ZIPCODE VALUES ('02155','Tufts Univ. Bedford','MA');    
INSERT INTO ZIPCODE VALUES ('07646','New Milford','NJ');  
INSERT INTO ZIPCODE VALUES ('07648','Norwood','NJ');
INSERT INTO ZIPCODE VALUES ('43224','Columbus','OH');
INSERT INTO ZIPCODE VALUES ('48104','Ann Arbor','MI');    


CREATE TABLE BONUS
        (ENAME VARCHAR(10),
         JOB   VARCHAR(9),
         SAL   INTEGER ,
         COMM  INTEGER );

CREATE TABLE SALGRADE
        (GRADE INTEGER,
         LOSAL INTEGER ,
         HISAL INTEGER);

INSERT INTO SALGRADE VALUES (1,  700, 1200);
INSERT INTO SALGRADE VALUES (2, 1201, 1400);
INSERT INTO SALGRADE VALUES (3, 1401, 2000);
INSERT INTO SALGRADE VALUES (4, 2001, 3000);
INSERT INTO SALGRADE VALUES (5, 3001, 9999);

CREATE TABLE DUMMY
        (DUMMY INTEGER );

INSERT INTO DUMMY VALUES (0);

COMMIT;



--
-- NAME
--   demoaddrows.sql
--
-- DESCRIPTION
--   This script adds rows to the DEPT and EMP tables in order to demonstrate outer joins.
--
--  USAGE
--    From omnymbus click on execute SQL
--        and browse to demoaddrows.sql

DELETE FROM EMP WHERE EMPNO = 9999;
DELETE FROM DEPT WHERE DEPTNO = 60;
INSERT INTO EMP VALUES
        (9999, 'KIRK',  'CAPTAIN',     NULL, '2002-04-14',  6000, NULL, 50);

INSERT INTO DEPT VALUES (60, 'STARFLEET', 'SAN FRANCISCO');

COMMIT;

PROMPT Demonstration add rows is complete.

Answers

(5)
Status NEW Posted 02 Dec 2017 01:12 PM My Price 10.00

-----------  ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly

Not Rated(0)