Example SQL

The following is purely for my own reference.

Get all tables

SELECT * FROM ALL_TABLES WHERE OWNER = ‘BASE’;

SELECT CONCAT(TABLENAME,’SEQ’) FROM ALL_TABLES WHERE OWNER = ‘BASE’;

SELECT ‘CREATE SEQUENCE ‘||CONCAT(TABLENAME,’SEQ’)||’ START WITH 4 INCREMENT BY 1 MINVALUE 1 MAXVALUE 99999999999999999999 CACHE 20 NOCYCLE NOORDER ’ FROM ALL_TABLES WHERE OWNER = ‘BASE’

INSERT INTO BASE.ADDRESS (ID,ADDRESS,PERSONID, POSTCODE,ADDRESSTYPEID,COUNTRY_ID) VALUES (‘2’,‘Roadside Croft, Netherley, , Stonehaven, , UK, AB39 3QL’,‘2’,”,‘42’,‘10’);

Replacing Commas with newlines

UPDATE BASE.ADDRESS SET ADDRESS = TRANSLATE(ADDRESS, ’,’, chr(10));

Andrew McDonough is a consultant CTO and software developer, currently based between Berlin and London.

Follow Andrew on Twitter or Connect on LinkedIn