OraFAQ Forum: SQL & PL/SQL » Loading techniques

Home » SQL & PL/SQL » SQL & PL/SQL » Loading techniques

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Loading techniques [message #660581]

Tue, 21 February 2017 09:46

Vijayarajan51
Messages: 3
Registered: February 2017

Junior Member

What are different types of data loading techniques apart from External table & SQL LOADER?

Report message to a moderator

Re: Loading techniques [message #660582 is a reply to message #660581]

Tue, 21 February 2017 09:49

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

INSERT (with APPEND mode) and any program you can write yourself using your favorite programming language.

Note that external table does not load anything, it allows to load using INSERT.

Report message to a moderator

Re: Loading techniques [message #660583 is a reply to message #660581]

Tue, 21 February 2017 09:50

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Vijayarajan51 wrote on Tue, 21 February 2017 07:46

What are different types of data loading techniques apart from External table & SQL LOADER?

INSERT

Report message to a moderator

Re: Loading techniques [message #660589 is a reply to message #660583]

Tue, 21 February 2017 10:10

Vijayarajan51
Messages: 3
Registered: February 2017

Junior Member

Thanks friends

Report message to a moderator

Previous Topic:	unique result
Next Topic:	Flashback techniues

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 14 03:54:37 CDT 2026