Asanka's - IFS Blog

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

SELECT company,        pay_term_id,        description,        day_to,        MAX(CASE WHEN rn = 1 THEN disc_days_cnt E…

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…