select 'drop trigger ' || trigger_name || ';' stmt from user_triggers;
select 'DROP SEQUENCE ' || sequence_name || ';' stmt from user_sequences;
select 'DROP TABLE ' || table_name || ';' stmt from user_tables;
select 'DROP VIEW ' || view_name || ';' stmt from user_views;

select 'DROP TABLE ' || table_name || 'CASCADE CONSTRAINTS ' || ';' stmt from user_tables;

select * from all_tables;

select table_name from user_tables

select * from tab

SELECT column_name FROM user_tab_cols WHERE table_name=UPPER('TheTableName')

SELECT * from table_name

select * from table_name where START_TIME > TO_DATE('11-JUL-19', 'DD-MON-YY');

CREATE_DTM >TO_DATE('2019-04-30 03:00:00', 'YYYY-MM-DD HH24:MI:SS')
CREATE_DTM >TO_DATE('2019-07-25', 'YYYY-MM-DD')

UPDATE table t1
   SET (column_name) = (SELECT t2.column_name
                         FROM table_name_two t2
                        WHERE t1.primary_key_column_id = t2.primary_key_column_id
                         )
 WHERE EXISTS (
    SELECT 1
      FROM table_name_two t2
     WHERE t1.primary_key_column_id = t2.primary_key_column_id
      )

select * from session_privs;

SELECT * from table_name
where instr(comments, chr(10)) > 0;

SELECT * from table_name
where comments like '%,%';

SELECT REPLACE(stringColumnName, 'thestring', '')
FROM table_name

ALTER User INSERUSERNAME IDENTIFIED BY INSERTNEWUSERPASSWORD;

GRANT SELECT,INSERT,DELETE,UPDATE,CREATE SESSION ON TABLENAME TO USERNAME;
GRANT SELECT ON TABLENAME TO USERNAME;

clear screen -- clears the output screen
SET pagesize 300 -- every 300 rows, print the column headers
SET sqlformat csv -- spit the results out in a comma separated values format
cd c:\users\first.last -- change the current working directory
spool table.csv -- capture everything that happens next to this file
SELECT * FROM table; -- get me the employees
spool off -- stop writing to that file
!TYPE table.csv -- run this OS command (windows CAT of a file basically)

CREATE USER [SCHEMA NAME]
  IDENTIFIED BY "[PASSWORD]" 
  DEFAULT TABLESPACE  [TABLESPACE] 
  QUOTA 500M ON [TABLESPACE] ;

GRANT CREATE SESSION TO [SCHEMA NAME] ;

GRANT CREATE TABLE TO [SCHEMA NAME] ;
GRANT CREATE SEQUENCE TO [SCHEMA NAME] ;
GRANT CREATE TRIGGER TO [SCHEMA NAME] ;
GRANT CREATE SYNONYM TO [SCHEMA NAME] ;
GRANT CREATE VIEW TO [SCHEMA NAME] ;
GRANT CREATE MATERIALIZED VIEW TO [SCHEMA NAME] ;
GRANT ALTER SESSION TO [SCHEMA NAME] ;
GRANT CREATE DATABASE LINK TO [SCHEMA NAME];
GRANT CREATE PROCEDURE TO [SCHEMA NAME];
GRANT CREATE TYPE TO [SCHEMA NAME];

DECLARE
  objName VARCHAR(255);
  sqlGrant VARCHAR(255) := 'grant all on ';
BEGIN
  FOR i in (select object_name from user_objects where object_type = 'TABLE' OR object_type = 'VIEWS' 
            OR object_type = 'TRIGGERS' OR object_type = 'SEQUENCES' OR object_type = 'PROCEDURES' 
			OR object_type = 'FUNCTIONS' OR object_type = 'TRIGGERS')
  LOOP
    objName := i.object_name;
    execute immediate sqlGrant || objName || ' to username';
  END LOOP;
END;

begin
  apex_util.set_app_build_status(APP#, 'STATUS_HERE');
end;

begin
  apex_util.set_app_build_status(102, 'RUN_AND_BUILD');
end;

select *
from apex_application_page_items
where application_id = 'app_id'

select *
from apex_application_items
where application_id = 'app_id'