Tuesday, February 27, 2007

Introduction to Oracle9i: SQL (10)

Producing readable output with iSQL *Plus

  • 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, /**/, - -.

Read more!

No comments: