Good question...

come to know that values in NOT IN works as AND not OR

i resposed to worng option 🙁

very good question...

unfortunately I checked wrong answer 🙁

Thanks for the easy question 😛

sorry I pasted wrong query-

this is the query below in which I am getting error-

alter view chk_sales

as

select * from SalesDates,

add constraint chk_unique unique values (id>2)

can anyone tell me how to add a constraint to a already created view?

I write as-

alter view chk_sales

as

select * from SalesDates,

add chk_unique constraint unique (id>2)

this is giving me error...

thanks Stewart for the explanation...

Learned something new today

can anyone explain why it returns all the rows as I am not cleared with the explanation ?

Hi Hugo,

according to another QOD i.e view 5

there was condition that if a add a new column to the table (previously there were 5 columns) and didnt refresh the view...

OMG I confused that may ne

NOT BETWEEN '2012/1/2' AND '2012/1/5'

includes the dates used in not between clause also and i put 4 as answer...

🙁 🙁 🙁

Well, learn something new...

Hi,

I am new in field of DBA...

I just want to know that can we assign value to a variable through SELECT statement also as done in the

question

Select

+1

eeasy one

Easy question..

+1 :-P:-P

just flip the coin and give the answer and it was right :hehe:;-)

:hehe::hehe:

Hey Hugo,

Thanks a lot for the explanation...

Specially for the code which makes fun :-P.. learn new things from that 🙂