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
• 9,700 points
125 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 Edureka
• 8,820 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
752 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
242 views
0 votes
0 answers

how to import jar in Mac

Jul 7, 2019 in Others by anonymous
302 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,105 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
7,861 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,060 points
1,526 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,170 points
666 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 Edureka
• 8,820 points
31 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 Edureka
• 8,820 points
19 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