Sql*Plus User’s Guide and Reference


Running Operating System Commands


Download 5.34 Mb.
Pdf ko'rish
bet6/103
Sana04.08.2023
Hajmi5.34 Mb.
#1665146
1   2   3   4   5   6   7   8   9   ...   103
Bog'liq
E18404-12

Running Operating System Commands
.............................................................................................. 4-8
Pausing the Display
................................................................................................................................. 4-9
Saving Changes to the Database Automatically
................................................................................ 4-9
Interpreting Error Messages
................................................................................................................ 4-10
5
 Using Scripts in SQL*Plus
Editing Scripts
........................................................................................................................................... 5-1
Writing Scripts with a System Editor.............................................................................................. 5-1
Editing Scripts in SQL*Plus Command-Line
..................................................................................... 5-2


v
Listing the Buffer Contents............................................................................................................... 5-3
Editing the Current Line ................................................................................................................... 5-4
Appending Text to a Line ................................................................................................................ 5-5
Adding a New Line............................................................................................................................ 5-6
Deleting Lines .................................................................................................................................... 5-7
Placing Comments in Scripts
................................................................................................................. 5-7
Using the REMARK Command ....................................................................................................... 5-7
Using /*...*/ ........................................................................................................................................ 5-7
Using -- ................................................................................................................................................ 5-8
Notes on Placing Comments ............................................................................................................ 5-8
Running Scripts
..................................................................................................................................... 5-10
Running a Script as You Start SQL*Plus...................................................................................... 5-10
Nesting Scripts
....................................................................................................................................... 5-11

Download 5.34 Mb.

Do'stlaringiz bilan baham:
1   2   3   4   5   6   7   8   9   ...   103




Ma'lumotlar bazasi mualliflik huquqi bilan himoyalangan ©fayllar.org 2024
ma'muriyatiga murojaat qiling