we can werite the condition in trailing null cols like trailing nullcols

INBOUND INTERFACE: Suppose I have 100 Records of employees
in flat file.When moving the records from flat file to
STAGING table using >CTl file, I want to restrict the
records whose salary is less than 500.what are the
validations(or conditions) you write to achieve this.

Question Posted / ramesh babu v

6 Answers
11526 Views
Tech Mahindra, I also Faced
E-Mail Answers

Answer Posted / ramesh babu v

we can werite the condition in trailing null cols
like
trailing nullcols(sal number(10)check(sal<500));

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are file in oracle.

2240

Can u give the Documentation of Custom.pll in oracle apps

3483

Plz anybody send me Technical specification for AP Interface

2564

Explain what are the tables of auto invoice?

1142

How can a process be deployed in soa?

1275

testing tools?

2259

Explain oracle apps architecture.

1258

What do you understand by a set of books?

1116

In oracle application how do you debug or trace errors?

1121

What is the concept of soa governance?

1256

tell me the scenarios of the independent in reports

2512

CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP

2634

tell me the scenarios of the independent in reports

2626

Do you know what is applysys in oracle application database schema, what is apps?

1179

Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?

2618