handson2.txt - Microsoft Windows[Version 10.0.17134.48(c 2018 Microsoft Corporation All rights reserved C\\Users\\kevin.williams>sqlplus

handson2.txt - Microsoft Windows[Version 10.0.17134.48(c...

This preview shows page 1 - 4 out of 20 pages.

Microsoft Windows [Version 10.0.17134.48](c) 2018 Microsoft Corporation. All rights reserved.C:\Users\kevin.williams>sqlplus [email protected](DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=34.215.168.149)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ISDS402)))SQL*Plus: Release 12.2.0.1.0 Production on Wed Sep 12 10:41:32 2018Copyright (c) 1982, 2016, Oracle. All rights reserved.Enter password:Last Successful login time: Wed Sep 12 2018 10:32:24 -07:00Connected to:Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit ProductionWith the Partitioning, OLAP, Advanced Analytics and Real Application Testing optionsSQL> !dirSP2-0042: unknown command "!dir" - rest of line ignored.SQL> !lsSP2-0042: unknown command "!ls" - rest of line ignored.SQL> host dirVolume in drive C has no label.Volume Serial Number is 8080-7D6EDirectory of C:\Users\kevin.williams09/12/2018 10:43 AM <DIR> .09/12/2018 10:43 AM <DIR> ..05/17/2018 03:52 PM <DIR> .QtWebEngineProcess05/17/2018 03:52 PM <DIR> .Tableau09/07/2018 03:28 PM <DIR> 3D Objects09/07/2018 03:28 PM <DIR> Contacts09/12/2018 10:43 AM 147 create_initial_table.sql09/07/2018 03:28 PM <DIR> Desktop09/07/2018 03:28 PM <DIR> Documents09/07/2018 03:28 PM <DIR> Downloads09/07/2018 03:28 PM <DIR> Favorites09/07/2018 03:28 PM <DIR> Links09/07/2018 03:28 PM <DIR> Music05/16/2018 03:20 PM <DIR> OneDrive09/07/2018 03:30 PM <DIR> Oracle09/07/2018 03:28 PM <DIR> Pictures09/07/2018 03:28 PM <DIR> Saved Games09/07/2018 03:28 PM <DIR> Searches09/07/2018 03:28 PM <DIR> Videos1 File(s) 147 bytes18 Dir(s) 84,033,724,416 bytes freeSQL> @create_initial_table.sqlCREATE TABLE test_table*ERROR at line 1:ORA-01031: insufficient privilegesINSERT INTO test_table*ERROR at line 1:ORA-00942: table or view does not exist
Background image
Commit complete.SQL> @create_initial_table.sqlCREATE TABLE test_table*ERROR at line 1:ORA-01031: insufficient privilegesINSERT INTO test_table*ERROR at line 1:ORA-00942: table or view does not existCommit complete.SQL> l1* COMMITSQL> @create_initial_tableCREATE TABLE test_table*ERROR at line 1:ORA-01031: insufficient privilegesINSERT INTO test_table*ERROR at line 1:ORA-00942: table or view does not existCommit complete.SQL> create table tst as select * from dual;create table tst as select * from dual*ERROR at line 1:ORA-01031: insufficient privilegesSQL> @create_initial_tableCREATE TABLE test_table*ERROR at line 1:ORA-01031: insufficient privilegesINSERT INTO test_table*ERROR at line 1:ORA-00942: table or view does not existCommit complete.SQL> select * from sample.employees;EMPLOYEE_ID FIRST_NAME LAST_NAME----------- -------------------- -------------------------EMAIL PHONE_NUMBER HIRE_DATE JOB_ID SALARY
Background image
------------------------- -------------------- --------- ---------- ----------COMMISSION_PCT MANAGER_ID DEPARTMENT_ID-------------- ---------- -------------100 Steven KingSKING 515.123.4567 17-JUN-87 AD_PRES 2400090101 Neena KochharNKOCHHAR 515.123.4568 21-SEP-89 AD_VP 17000100 90EMPLOYEE_ID FIRST_NAME LAST_NAME----------- -------------------- -------------------------EMAIL PHONE_NUMBER HIRE_DATE JOB_ID SALARY------------------------- -------------------- --------- ---------- ----------COMMISSION_PCT MANAGER_ID DEPARTMENT_ID-------------- ---------- -------------102 Lex De HaanLDEHAAN 515.123.4569 13-JAN-93 AD_VP 17000100 90103 Alexander HunoldAHUNOLD 590.423.4567 03-JAN-90 IT_PROG 9000EMPLOYEE_ID FIRST_NAME LAST_NAME----------- -------------------- -------------------------EMAIL PHONE_NUMBER HIRE_DATE JOB_ID SALARY------------------------- -------------------- --------- ---------- ----------COMMISSION_PCT MANAGER_ID DEPARTMENT_ID-------------- ---------- -------------102 60104 Bruce ErnstBERNST 590.423.4568 21-MAY-91 IT_PROG 6000103 60105 David AustinEMPLOYEE_ID FIRST_NAME LAST_NAME----------- -------------------- -------------------------EMAIL PHONE_NUMBER HIRE_DATE JOB_ID SALARY------------------------- -------------------- --------- ---------- ----------COMMISSION_PCT MANAGER_ID DEPARTMENT_ID-------------- ---------- -------------DAUSTIN 590.423.4569 25-JUN-97 IT_PROG 4800103 60106 Valli PataballaVPATABAL 590.423.4560 05-FEB-98 IT_PROG 4800103 60
Background image
Image of page 4

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture