USER_TABLES Lists each table that belongs to your Oracle user.USER_TAB_COMMENTS Shows comments on the tables and views.USER_TAB_COLUMNS Tells you the names, data types, default values, etc. of [...]

CREATE OR REPLACE PROCEDURE BLK_CLCT_DELISL_LIMIT PLS_INTEGER := 20000; CURSOR C1ISSELECT row_idFROM s_invoice_itemWHERE person_id IN(SELECT b.row_idFROM disalloc A, S_CONTACT BWHERE [...]

SELECT hca.account_number, ( SELECT hp.party_name FROM apps.hz_parties hp WHERE hp.party_id = hca.party_id ) customer_name, jnb.creation_date notes_creation_date, jnb.note_type note_type, [...]

SELECT DISTINCT –gcck.concatenated_segments, gcck.segment1 company, gcck.segment2 location, gcck.segment3 product, gcck.segment4 function, gcck.segment5 account, gcck.segment6 intercompany, [...]

SELECT hou.name operating_unit, xep.name legal_entity, ala.lockbox_number “NUMBER”, absa.name batch_source, cebb.bank_name, –cebb.bank_number, –cebb.bank_branch_name, [...]

Syntax: SQRT(number); Query: select SQRT(25) from dual; Output: 5

Syntax: POWER(<base number>, <exponent number>) Query: select POWER(3,3) from dual; Output: This function return base number raised to the exponent’s power. 27

Syntax: to_char(-123456,’99G99G99G999PR’) Query: select to_char(-123456,’99G99G99G999PR’) from dual; Output: <1,23,456>

/*Upload the customer data that needs to be updated in a temp table*/ CREATE TABLE scratch.RITM0669580 (account_number VARCHAR2(30), tax_payer_id VARCHAR2(20), tax_reg_num VARCHAR2(50), status [...]

DECLARE x_return_status VARCHAR2 (200) := NULL; x_msg_count NUMBER := 0; x_msg_data VARCHAR2 (200) := NULL; t_output VARCHAR2 (200) := NULL; t_msg_dummy VARCHAR2 (200) := NULL; l_payee_upd_status [...]