SCRIPT GENERALES

-- Para ver todas las tablas y vistas en un esquema:
SQL> SELECT * FROM tab;


--Para listar el ultimo script realizado

SQL> L

--Para listar la ultima linea  de un script realizado

SQL>LIST LAST

--CLEAR BUFFER

SQL>CL BUFF

--List the SQL buffer:

SQL> L

SELECT employee_id, first_name, last_name

* FROM employees

SQL>

--Save the buffer to a file named myfile; the default extension will be .sql:

SQL> SAVE myfile

Created file MYFILE.sql

SQL>

--Save the file using the REPLACE keyword:

SQL> SAVE myfile REPLACE

Wrote file MYFILE.sql

SQL>