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'