SQL * plus Buffer

• SQL * Plus ORACLE has developed it’s environment tool.
• We can use directly SQL & PL/SQL statements in this environment tool.
• 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.
• SQL statement 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(;).
• To run the previous or current SQL statement in the Buffer type ‘/’ at SQL prompt.
• To open the SQL Editor type end at SQL prompt.
• It provides………….
o SQL commands
o PL/SQL block
o It has own commands to set environment as requirement
o To generate report
o To save SQL commands as file(.sql)
o To save PL/SQL commands as file(.sql)
o To save output as file(.lst)

Thanks for reading. If you like this post please follow us for more updates about technology related updates.