Search results for query: *

I have the following query: SELECT /*+ STAR_TRANSFORMATION */ f_exp_det.adjust_flag, f_exp_det.deal_id, f_exp_det.approved_approach_id, f_exp_det.asset_class_id, d_asset_class.exposure_type, d_asset_class.exposure_type_desc...

I am trying to load some data into the following table: CREATE TABLE IMP_ECUST (Source VARCHAR2(1), Sales_Level_2 VARCHAR2(255), Sales_Level_3 VARCHAR2(255), Sales_Level_4 VARCHAR2(255), Sales_Level_5 VARCHAR2(255), Sales_Level_6 VARCHAR2(255), CSC_Global_ID INTEGER, CSC_Global_Name...

I have two tables GCR_CONTACTS and GCR_EADDRESSES , which are linked on contact_id. I need to select the first 500000 contact_id's of those contacts where there are duplicates on first name & email address (they can be different case, and have extra spaces). I have written this query: select...

I am currently extracting data into a file using the following script: set linesize 1180 set pagesize 0 set head off set term off set wrap off column CONTACT_ID format 9999999999 column FIRST_NAME format a78 column LAST_NAME format a78 column JOB_TITLE format a78 column ADDRESS_LINE_1 format...

Does anyone know a quick way of assigning default values to a PL/SQL table? The values will always be the same across all the columns (as in the example below). I have created the following code to help illustrate my question: CREATE TABLE test (field1 VARCHAR(10), field2 VARCHAR(10), field3...