How to load JSON file or CSV file into oracle database using ColdFusion ? Please tell me ASAP

That depends.  You can very easily insert the JSON or CSV data as a string into a varchar or text datatype on the database, no problem.

However, if you need the JSON or CSV to be in an array (like a query object) so that it can be inserted into the database, then how the data was "flattened" would matter.

I avoid CSV, if at all possible.  Never liked it.

However, if you are using CF to create the JSON (or if you manually piece it together in JavaScript and it follows the CF format), then you should be able to use DeserializeJSON() to put it back into a query object and append the data into a database relatively easily.

HTH,

^_^

PS:  I just noticed that you addressed your post to "ColdFusion Team".  Just to make sure, the people at Adobe don't officially monitor these forums - these forums are primarily a user-to-user interaction.  Although sometimes Adobe staff do check in here to see what's going on.