Thursday, September 27, 2012

Test MI, NJ


-- Gets all table name and column name of MI which are not in NJ

SELECT mi.tablename,mi.ColumnName, mi.tablename || mi.ColumnName
FROM MI
where mi.tablename || mi.ColumnName NOT IN
(
SELECT  nj.tablename || nj.columnname
FROM  NJ)
;

-- -- Gets all table name and column name of NJ  which are not in MI

SELECT nj.tablename,nj.ColumnName, nj.tablename || nj.ColumnName
FROM NJ
where nj.tablename || nj.ColumnName NOT IN
(
SELECT  mi.tablename || mi.columnname
FROM  mi)
;
 


-- || is used for concatenation

Tuesday, September 25, 2012

test

 'abc_id' = Column name
'_id' =  string to be removed

select substr('abc_id', 0, length('abc_id') -  instr('abc_id', '_id') + 1 )  from table_name;