Answer / sumit

Any number of Null values can be inserted in such a column.

Answer / amit

Any no. of times you can insert null values in a coulmn
whihc is unique constraint because a Null value is
undefined,unassigned,and unapplicable value so thats why we
cannot compaire with any other null value or other value.

Answer / ajay badola

Any number of null values can be inserted.

Answer / john bershan

any number of null value can be inserted into table for a
column which is declared as unique.coz null vale s either
not equal to any value or not equal to another null;

Answer / veerapandian muthupandi

Only one null

Answer / sheea pruthi

12

Answer / bhargav

single NULL

Answer / manish kumar

Single null Value
B'cse Unique Constraint contain unique value and single
null is also a unique value.

what is Complex index. how to create it?

2 Answers  

Can one improve the performance of sql*loader? : aql loader

0 Answers  

Can variables be used in sql statements?

0 Answers  

What is pls integer?

0 Answers  

what is difference between "Primary key" and "Unique key"?

4 Answers   PreVator,

Can we use commit or rollback in trigger? If yes, then how. Please explain with a suitable example?

5 Answers   HSBC,

How many types of indexes are there in sql?

0 Answers  

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_date trans_amt debit_credit_indicator 001 JAN 1599 cr no.of trans 2 i want trans_id and trans_date like 'JAN' or 'FEB' etc, trans_amt i want all credit amount - debit amount per each trans_id. and debit_credit_indicator and no.of transactions in a month.

1 Answers   Oracle,

explain access control lists. : Sql dba

0 Answers  

Can I join the same table twice?

0 Answers  

what is the command used to fetch first 5 characters of the string? : Sql dba

0 Answers  

what is row? : Sql dba

0 Answers