those are useful sql statements that are commonly used..
COMMIT;
SELECT * FROM TAB;
DESC TABLENAME;
SET LINESIZE 1000
SET PAGESIZE 1000
/
SELECT * FROM TABLENAME ORDER BY COLUMNNAME ASC;
CREATE VIEW VIEWNAME ( VIEWCOLUMN) AS
SELECT TABLECOLUMN FROM TABLE
WHERE TABLECOLUMN LIKE "%S" /*/*/ "_A%" /*/*/ IS NULL /*/*/ IS NOT NULL /*/*/ = 'STRING'
GROUP BY TABLECOLUMN;