Тёмный

How to import data into a database using PL SQL 

Biz Tech Talk
Подписаться 24
Просмотров 4,5 тыс.
50% 1

A short video on how you can import Excel data into an Oracle database using AllAround Automations PLSQL Developer
Thanks to AllAround: www.allroundautomations.com
Check out my site for Associated Blog: scottstansfield...
Follow me on Twitter: biztechscott

Опубликовано:

 

15 сен 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 7   
@shubhamkorde9587
@shubhamkorde9587 2 месяца назад
How to add constraints while using this method
@mmnanuruddha
@mmnanuruddha 7 лет назад
really good one. Helped me.
@shahzad271
@shahzad271 8 лет назад
sorry i cant read, which software you are using.?
@vovik0134
@vovik0134 8 лет назад
+shahzad asgher pl/sql developer
@yogeshwaranc9164
@yogeshwaranc9164 7 лет назад
nice video
@harrybuckley7292
@harrybuckley7292 8 лет назад
a bit naff. On a technical note , you do not waste space when using VARCHAR columns ( that is the whole point ). Ideally you should have pre-defined the table. Also, try loading say 1000,0000 rows this way or more. What about blobs/clobs and images ????
@Scottstansfieldbtt
@Scottstansfieldbtt 8 лет назад
+Harry Buckley Thanks Harry, feedback is always needed to improve. I had thought the main difference was NULL value padding and that the DB may allocate blocks that then weren't used - not necessarily wasting space but not the most efficient use of disk. But something I can do some more reading on :) When it comes to importing 10,000,000 rows, with enough RAM it would handle it, but CLOBS, BLOBS etc I guess wouldn't generally be in excel/csv as a source anyway? I will be doing a video on using Excel to help write repetitive statements such as case whens and mass inserts so may be more interesting. My videos are generally pitched at the aspiring MI/BI analyst audiences Again, thanks for watching! If there is a type of content you would prefer to see, just let me know!
Далее
How To Perform A Text Import With PL/SQL Developer
7:58
7 Database Design Mistakes to Avoid (With Solutions)
11:29
Pure Comedy #ti13
00:38
Просмотров 213 тыс.
Database Indexing for Dumb Developers
15:59
Просмотров 57 тыс.
Learn Database Normalization - 1NF, 2NF, 3NF, 4NF, 5NF
28:34
PLSQL Developer
9:01
Просмотров 20 тыс.
Microservices with Databases can be challenging...
20:52
SQL How-to NVL, NVL2 KEEP DENSE RANK
19:59
Просмотров 166