Introduction to Oracle9i: SQL (10)
Producing readable output with iSQL *Plus
##CONTINUE##
- iSQL*Plus commands can be abbreviated. Like DESCRIBE as DESC. iSQL*Plus is the ORACLE proprietary interface for executing SQL statement.
- SQL statements manipulate data and table definitions in the database.
- If you set Environment Variables in LOGIN.SQL file, every time you login, this file runs automatically.
- Ttitle, connect, define, undefined, prompt are iSQL plus commands.
- START dela
It runs the DELA.SQL script file. - SQL*Plus DEL command deletes the current line from the buffer. And DEL 4 5 command deletes lines 4 & 5 of the buffer.
- Using REM, /**/, - -.
No comments:
Post a Comment