Database Utilities (MOSC)

MOSC Banner

user sqlload load data to mutiple tables

edited Jun 7, 2012 9:16PM in Database Utilities (MOSC) 11 comments
user sqlload load data to mutiple tables

now we are tring to load data from txt file to two diffierent to tables in the database.the key part to diffierciate different date is by recongenizing whether CLOUMN A is null or not.

when A IS NULL to TABLE1

when B IS NOT NULL TO TABLE2

But problem is we can not use clause like 'WHEN A IS NULL' in control file.Are there any other ideas?eagering for your help,thank you !

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