Oracle Scripts
-
How can I empty the trash in Oracle Database
Question : How can I empty the trash in Database To remove the entire contents of your recycle bin, issue…
Devamını Oku » -
How Can I See Error In Oracle Database
Q : How Can I See Error In Oracle Database SELECT ORIGINATING_TIMESTAMP AS "DATE", MESSAGE_TEXT AS "TEXT", MESSAGE_LEVEL AS "LEVEL",…
Devamını Oku » -
How Can I See Active Session In Oracle Database
Q : How Can I See Active Session In Oracle Database SELECT NVL(s.username, '(oracle)') AS username ,s.osuser ,s.sid ,s.serial# ,p.spid…
Devamını Oku » -
How Can I See Hidden Parameters In Oracle Database
Q : How Can I See Hidden Parameters In Oracle Database SELECT a.ksppinm AS parameter ,a.ksppdesc AS description ,b.ksppstvl AS…
Devamını Oku » -
How Can I See Invalid Object In Oracle Database
Q : How Can I See Oracle Invalid Object SELECT OWNER ,object_type ,object_name ,STATUS FROM dba_objects WHERE STATUS = 'INVALID'…
Devamını Oku »