HI Guys,
Could you please help me how to create external table with only one filed(number data type) in oracle
I used the below code but it was not loading the data.
Could you please help me guys.
Thanks,
Sudhakar Boyalla
Could you please help me how to create external table with only one filed(number data type) in oracle
I used the below code but it was not loading the data.
Code:
CREATE TABLE SOLNGLOBAL_ORIG_DATA_656356 (Account_NUMBER NUMBER ) ORGANIZATION external ( DEFAULT DIRECTORY SWA_ED20307_OTHERPREP ACCESS PARAMETERS (RECORDS DELIMITED BY NEWLINE ) LOCATION ( 'swa_privacy_delete_request_20200402_S6.txt' ) ) REJECT LIMIT UNLIMITED
Thanks,
Sudhakar Boyalla