PL/SQL (MOSC)

MOSC Banner

creating table from data, writing out data from SQLplus

edited Sep 29, 2015 10:00AM in PL/SQL (MOSC) 9 commentsAnswered

How can I write out a data selection into a file or some SQL which I can import into another database.

Scenario: database A:

create view x as select SACH_NR from IDENT_DATEN where KLASS_ART = 'W' and KLASS_TYP = 'K';


write out this selection in some form to a file or something.


database B:


create table X (SACH_NR VARCHAR(50));


now load the data from above selection/file into this table.


Thanks.


Christoph


Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center