Asanka's - IFS Blog

Following query can be used to get all the active sessions. SELECT SID, SERIAL#, STATUS    FROM V$SESSION    WHERE US…

Usage of BOOLEAN("TRUE", "FALSE") is more useful when considering the performance than FndBoolean…

tns:   C:\app\product\12.1.0\dbhome_1\NETWORK\ADMIN hosts: C:\Windows\System32\drivers\etc\hosts

• Stop Oracle service Using cmd 'net STOP service_name'  • Uninstall all Oracle components using the Oracle Un…

To create the table CREATE TABLE backup_co_reservation_tab AS   SELECT *  FROM customer_order_reservation_tab WHERE ord…

Problem:  If we don't have configurations such as Custom Fields, Custom Views etc. versioned control in git reposit…

We cannot use export option in the client to version control it as xml file, it's only possible to import in differ…

Need to register statement like below (Highlighted in orange) DECLARE    table_name_    VARCHAR2(30) := 'EXTERNAL_C…