oracle_database.md

oracle database

• GOTO SQL Notes

export schema user tables etc example

exp user/password@url.endpoint.com:port/service FULL=Y FILE=C:\dump_

drop all tables ready-to-use list

select 'drop table '||table_name||' cascade constraints;' from user_tables;

delete all rows in schema

select 'truncate table ' || table_name || ';' from user_tables

connection url

with sid

jdbc:oracle:driver_type:[username/password]@//host_name:port_number:SID