Write the order of precedence for validation of a column in a table ?

Write the order of precedence for validation of a column in
a table ?

Question Posted / guest

2 Answers
8676 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Write the order of precedence for validation of a column in a table ?..

Answer / nishi

done using Database triggers.

done using Integarity Constraints.

Is This Answer Correct ?

0 Yes

0 No

Write the order of precedence for validation of a column in a table ?..

Answer / tulsi

done using Database triggers.
done using Integarity Constraints.

Is This Answer Correct ?

0 Yes

4 No

Post New Answer

More SQL PLSQL Interview Questions

i have a customer table. trans_id trans_date trans_amt debit_credit_indicator 001 01-JAN-13 1099 cr 001 12-JAN-13 500 db 002 24-FEB-13 400 db 002 23-MAR-13 345 cr 001 18-APR-13 800 cr 002 15-MAR-13 600 db 001 12-FEB-13 200 cr i want like this output. trans_id trans_amt debit_credit_indicator i want get highest credit amount and lowest credit amount and highest debit amount and lowest debit amount for each trans_id. pls give me answer. i want urgent

3 Answers

how to create table with in the procedure or function?

2 Answers Genpact, HCL,

Interchange the value of a column Gender in a table where values are Male and Female. So, where the value is Male, it should changed to Female and Female to Male.

4 Answers Cap Gemini, IBM,

The in operator may be used if you know the exact value you want to return for at least one of the columns.

0 Answers

how can you see all indexes defined for a table? : Sql dba

0 Answers

What is foreign key and example?

0 Answers

What is difference between left and right outer join?

0 Answers

What are the components of a PL/SQL block ?

3 Answers

Is subquery faster than join?