How to import excel file in Oracle SQL live

0 votes
Unable to import data from CSV to Live SQL.
Feb 18 in Others by Edureka
• 13,640 points
195 views

1 answer to this question.

0 votes
Hello, there are a few steps

You'll have an oracle table, and an excel file (you can more too).

with the help of a mouse, right-click and you'll find an option to import data

you can select the import file and verify the data in the file too

after this, you can create your script and import it automatically after this please select the columns that need to be imported

now you have to map the excel columns to table columns

verify your setting and click on go and then click on finish

this shud be done, with these steps u can export the files
answered Feb 18 by gaurav
• 13,460 points

Related Questions In Others

0 votes
1 answer
0 votes
1 answer

How to unistall a file in Linux?

You can uninstall a file using the ...READ MORE

answered Mar 8, 2019 in Others by Nabarupa
773 views
0 votes
0 answers

How to create a batch file in windows?

What is a batch file and How ...READ MORE

Jul 4, 2019 in Others by sindhu
253 views
0 votes
0 answers

how to import jar in Mac

Jul 7, 2019 in Others by anonymous
312 views
0 votes
2 answers

Unable to use jenkins to run oracle script on remote DB

add ORACLE_HOME  in jenkins global variable. READ MORE

answered Mar 27, 2019 in DevOps & Agile by hal
4,153 views
+2 votes
2 answers

How to connect to Oracle using Service Name instead of SID?

HII.. I hope this information may help you- Thin-style ...READ MORE

answered Sep 29, 2020 in Java by SRI
8,004 views
0 votes
1 answer

How can i copy tables from one database to other on AWS?

You can use AWS Data pipeline to ...READ MORE

answered Jul 5, 2018 in AWS by Priyaj
• 58,080 points
1,661 views
–1 vote
1 answer

What is the difference between oracle JDK and open JDK

Both OpenJDK and Oracle JDK are created ...READ MORE

answered Jul 10, 2018 in Java by Akrati
• 3,190 points
684 views
0 votes
1 answer

How to import data from a HTML table on a website to excel?

Hello  To import any HTML file in excel there ...READ MORE

answered Feb 10 in Others by gaurav
• 13,460 points
48 views
0 votes
1 answer

How to open .xlsx files in MS Excel from VS Code?

Hello, to open xlxs files, or files ...READ MORE

answered Feb 17 in Others by gaurav
• 13,460 points
25 views
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP