About Oracle Buffer

About Oracle Buffer :-

• All Commands of SQL are typed at the SQL prompt.
• Only one SQL statement is managed in the SQL buffer.
• The current SQL statement replaces the previous SQL statement in the buffer.
• The SQL statements can be divided into different lines within the SQL buffer.
• Only one line i.e, the current line can be active at a time in the SQL buffer.
• At SQL prompt, editing is possible only in the current SQL buffer line.
• Every statement of SQL should be terminated using semi colon ";".
• One sql statement can contain only one semi colon.
• To run the previous or current SQL statement in the bufer type "/" at SQL prompt.
• To open the SQL editor type "ED" at SQL prompt.