лабораторная работа 6

  • Published on
    28-Jun-2015

  • View
    33

  • Download
    0

Embed Size (px)

Transcript

  • 1. 6 SQL*Plus: Copyright Avdeyev V.A. 2008

2. 6 : SQL*Plus : SQL*Plus 6Copyright Avdeyev V.A. 2008 3. SQL*Plus SQL*Plus , Oracle, , SQL 6Copyright Avdeyev V.A. 2008 4. (1/2) EDIT ( , . . , ED) SQL*Plus , not exist" , "ORA-00942: table or view does edit ENTER. SQL-. 1, 1 SQL*Plus. , (/) ENTER. 6Copyright Avdeyev V.A. 2008 5. (2/2) 6Copyright Avdeyev V.A. 2008 6. (1/2) SQL*Plus . . , SQL*Plus. , , , snnum (*). SQL-, . ENTER, CHANGE. (/) ENTER. 6Copyright Avdeyev V.A. 2008 7. (2/2) 6Copyright Avdeyev V.A. 2008 8. . , . , Edit SQL*Plus. , Windows. Edit | Paste, SQL*Plus. ENTER . SQL*Plus SHIFT, , , DELETE. . ., SQL*Plus SQL>. 6Copyright Avdeyev V.A. 2008 9. SQL*Plus 6Copyright Avdeyev V.A. 2008 10. (spooling) . SQL*Plus, . 6Copyright Avdeyev V.A. 2008 11. (1/2) (script file) . . 6EDIT c:test.sqlCopyright Avdeyev V.A. 2008 12. (2/2) , test.sql . 6@:testCopyright Avdeyev V.A. 2008