SELECT 'INSERT INTO CF_LOV_RELATION (RELATION_TYPE, LOV_ID, PARENT_LOV_ID, IS_DEFAULT, CDATE, UDATE) VALUES (' 
|| CF_LOV_RELATION.RELATION_TYPE || ',' || CF_LOV_RELATION.LOV_ID ||','|| CF_LOV_RELATION.PARENT_LOV_ID || ','
|| nvl(CF_LOV_RELATION.IS_DEFAULT,'NULL') || ','|| CF_LOV_RELATION.CDATE ||','|| nvl(to_char(CF_LOV_RELATION.UDATE,'dd/mm/yyyy'),'NULL') ||')' 
AS InsertStatement FROM CF_LOV_RELATION where rownum < 3;

SELECT 'INSERT INTO CF_LOV_RELATION (RELATION_TYPE, LOV_ID, PARENT_LOV_ID, IS_DEFAULT, CDATE, UDATE) VALUES (' || CF_LOV_RELATION.RELATION_TYPE || ',' || CF_LOV_RELATION.LOV_ID ||','|| CF_LOV_RELATION.PARENT_LOV_ID || ',' || nvl(CF_LOV_RELATION.IS_DEFAULT,'NULL') || ','|| 'TO_DATE('||'''' ||CF_LOV_RELATION.CDATE || '''' ||', ''MM.DD.YYYY HH24:MI:SS'')' ||','|| 'SYSDATE'||')' AS InsertStatement FROM CF_LOV_RELATION where relation_type = 'PARENT_CHILD_BAYITIPI' and rownum < 3; SELECT 'INSERT INTO CF_LOV_RELATION (RELATION_TYPE, LOV_ID, PARENT_LOV_ID, IS_DEFAULT, CDATE, UDATE) VALUES (' || CF_LOV_RELATION.RELATION_TYPE || ',' || CF_LOV_RELATION.LOV_ID ||','|| CF_LOV_RELATION.PARENT_LOV_ID || ',' || nvl(CF_LOV_RELATION.IS_DEFAULT,'NULL') || ','|| CF_LOV_RELATION.CDATE ||','|| nvl(to_char(CF_LOV_RELATION.UDATE,'dd/mm/yyyy'),'NULL') ||')' AS InsertStatement FROM CF_LOV_RELATION where rownum < 3;

SELECT table_name, column_name
  FROM user_tab_cols
 WHERE column_name LIKE '%COMPANY%';

SELECT * FROM CURRENCY_EXCHANGE WHERE VALID_FROM = TO_DATE('20.12.2011','dd.mm.yyyy');

UPDATE korek_credit_control_hub  SET processed_time = TO_DATE('03.11.2015 13:00:00', 'MM.DD.YYYY HH24:MI:SS') where  trans_id = 25333 ;

expdp \"SYS@XE AS SYSDBA\" schemas=SCHEMATOBEDUMPED directory=DUMPDIR dumpfile=testdump.dmp logfile=testdump.log network_link=REMOTELINK

SELECT owner,
       db_link,
       username,
       host
FROM   dba_db_links
ORDER BY owner, db_link

CREATE USER demo IDENTIFIED BY demo; -- create user with password
GRANT CONNECT,RESOURCE,DBA TO demo; -- grant DBA,Connect and Resource permission to this user(not sure this is necessary if you give admin option)
GRANT CREATE SESSION TO demo WITH ADMIN OPTION; --Give admin option to user
GRANT UNLIMITED TABLESPACE TO demo; -- give unlimited tablespace grant

SELECT SID, SERIAL#, MACHINE, USERNAME FROM V$SESSION WHERE USERNAME='TOBREMOVEDUSER' ;

alter system kill session 'SID,SERIAL';

DROP USER TOBREMOVEDUSER CASCADE;