Hello All,
I have to do some analysis on production Oracle DB 11.2.0.4.0 tables for a defect. I have a pipe delimited text file it has about 15 columns with mixed data type and i don't have create table privilege in my user schema obviously since it is Production DB, i am looking for something similar to below query where it holds the values in a pseudo table and then i could use this to query against the other tables in database.
SELECT * FROM TABLE(SYS.dbms_debug_vc2coll('620000','720033','720040','720060','720105','720131','720143','720164','720168','720181','720186','720188','720194','720331','720335','720336','720376','720735','720899','720922'))
Question: Is there a way i can hold entire file and its columns in a pseudo table with individual columns similar to above and query each column in that table to join with other tables and do some analysis?
Thank you,
Ariean.