Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.
DECLARE v_PRT varchar(30) := 'ALL_INTERNAL_MAIN_TEST_PRT'; BEGIN FOR t IN (Select column_nm, src_nm from v_PRT) LOOP DBMS_OUTPUT.PUT_LINE(t.column_nm||t.src_nm); END LOOP; END; /
|Create Index on a Materialized View||5||32|
|I tried to perform dml in a table for auditing who perform dml where a after dml trigger also exists in the same table as per rule i tried to handel with autonomous_transaction but still cant perform.||7||32|
|Access join syntax when converting to T-SQL query||4||33|
|Requesting help with creating an SQL query with 2 tables||6||24|