Search This Blog

Thursday, September 8, 2022

Create Oracle Database Table and Load Data from Excel in Couple of Seconds



You can create a table and load data from excel with the appropriate column data type within 5 seconds.

Oracle Apex will read the whole excel and then create a table with the appropriate data type by respective data. Finally, it loads all data into the table from excel. 


at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search String Inside Oracle Database Objects SQL

SELECT owner, name, type, line, text  FROM dba_source WHERE instr(UPPER(text), UPPER('string')) > 0;