How to retrieve session information: select S.LOGON_TIME ,sid, serial#, username, command, lockwait, status, osuser, sql_text, machinefrom v$session s, v$sqlarea q where s.sql_hash_value = q.hash_valueand s.sql_address = q.addressand osuser = 'zzz'and…
How to create a pivot query: with t as ( select 1 GRP_NR, 'A' val from dual union allselect 1 ,'B' val from dual union allselect 2 ,'A' val from…
How to create user and give the necessary grants:
create user 'ms'@'111.222.11.22' identified by 'swkb123';
grant select, delete, insert, update on myschema.* to 'ms'@'111.222.11.22'
grant all privileges on myschema.* to 'ms'@'111.222.11.22';
(more…)