How to Import data from Excel to Oracle with SQL Developer TAMIL | Oracle to Oracle table import

Published: 17 September 2021
on channel: NIC IT ACADEMY
8,070
like

#oracle#sqlinterviewquestions#sqlinterviewquestionsandanswers

Oracle SQL in Tamil - Day 1 -    • Day 1 - SQL in TAMIL | Oracle SQL tut...  

Oracle SQL in Tamil - Day 2 -    • Day 2 - SQL in TAMIL | Oracle SQL tut...  

Oracle SQL in Tamil - Day 3 -    • Day 3 - SQL in TAMIL | Oracle SQL tut...  

Oracle SQL in Tamil - Day 4 -    • Day 4 - SQL in TAMIL | Oracle SQL tut...  

Oracle SQL in Tamil - Day 5 -    • Day 5 - SQL in TAMIL | Oracle SQL tut...  

Oracle SQL in Tamil - Day 6 -    • Day 6 - SQL in TAMIL | Oracle SQL Joi...  

Oracle SQL in Tamil - Day 7 -    • Day 7 - SQL in TAMIL | Oracle SQL Sub...  


For Training contact:
+91 7010080468

********************************************************************************
Join this channel to get access to perks:
   / @nicitacademy  

********************************************************************************

In this video, we’ll learn How to import/export data to/from Oracle table NiC IT Academy
==============================================

1) Import from excel
2) Manual Import
3) Export from Oracle table to csv file



How to Import data from Excel to Oracle with SQL Developer
==========================================================

Step 1: The Empty Oracle Table and your Excel File.
Step 2: Mouse-right click – Import Data.
Step 3: Select your input (XLSX) file and verify the data.
Step 4: Create a script or import automatically.
Step 5: Select the Excel Columns to be Imported.
Step 6: Validate the data type of each column
Step 7: Verify your settings and Finish!


create table employee
(
emp_id number(8),
emp_name varchar2(50),
dob date,
salary number(10),
skillset varchar2(50),
city varchar2(50),
country varchar2(50)
);


Data File used in this video - download:
=================================

https://docs.google.com/spreadsheets/...


==============================================================
*********************************************************************
Informatica PowerCenter Whatsapp Group for Updates/Doubts/Interview questions/Discussion

https://chat.whatsapp.com/BXBWr07BSLq...
**********************************************************************

Informatica training in TAMIL - Playlist

   • Informatica Training - தமிழில்  

Informatica training in ENGLISH - Playlist
   • Informatica Training Series - ENGLISH  

Informatica Interview Preparation - TAMIL
   • Informatica Interview Series - TAMIL  

Informatica Interview Preparation - ENGLISH
   • Informatica Interview Series - ENGLISH  

*******************************************************************************

oracle joins in tamil
oracle tutorial in tamil
oracle self join
oracle tamil
oracle joins
sql in tamil
oracle equi join
oracle cross join
sql joins tutorial
oracle natural join
sql joins with examples
oracle non equi join
oracle outer join
oracle full outer join
oracle left outer join
sql joins explained
sql joins
complete sql tutorial
oracle right outer join
sql for beginners tamil
oracle tutorial for beginners
sql programs tamil


Watch video How to Import data from Excel to Oracle with SQL Developer TAMIL | Oracle to Oracle table import online, duration hours minute second in high quality that is uploaded to the channel NIC IT ACADEMY 17 September 2021. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 8,070 times and liked it like visitors.