Name
csv_table_def — Guess table definition from CSV file.
Synopsis
csv_table_def
(
|
in
file_name
varchar
); |
Description
This function will return table definition appropriate for CSV file specified by file_name.
Parameters
file_name
The name of the CSV file.
Examples
Example 24.131. Simple Use
SQL>select csv_table_def('tmp/MyContacts.csv');
callret
VARCHAR
_______________________________________________________________________________
CREATE TABLE "tmp_MyContacts_csv" (
"First_Name_Last_Name_Middle_Name_Name_Nickname_E_mail_Address_Home_Street_Home_City_Home_Postal_Code_Home_State_Home_Country_Region_Home_Phon
e_Home_Fax_Mobile_Phone_Personal_Web_Page_Business_Street_Business_City_Business_Postal_Code_Business_State_Business_Country_Region_Business_Web_Page_
Business_Phone_Business_Fax_Pager_Company_Job_Title_Department_Office_Location_Notes" VARCHAR)
1 Rows. -- 10 msec.