Search:

Suresh got the answer correct. But My question has two parts, one part is to answer this question and the second part is to derive a generalized solution for N number of pirates :)

DESC[RIBE] is neither a DDL command nor DML command.

Please note, DDL - commands are those change the database objects Ex: create table, alter table
DML- are those manupulates data Ex: Update ,...

The answer is 24.

First man hide 8 and gave monkey 1

remaining are 15

second man hide 5 and gave monkey a one

remaining are 9

perhaps you did not pay much attention to my solution ;)...just kidding

He can do it in 20 trips...

Here is my solution,
1. Group 100 switches in to group of 10 each.
2. On all the switch in one group, make a trip and note down the bulbs belong to the group
3....

Generally in data warehousing, surrogate keys are preferred over complex primary key. Surrogate keys are just unique identification key with out any intelligence.

ROWNUM gets generated only at the time of row population. Hence you can never have a conditionlike any(3,4,5)

I think SAL should be ordered in desc order

Just to add Suji's answer, UNION ALL has better performance as it does not have to return DISTINCT set of records.

this is just an incomplete question which can not be answered

through out his life time?? ha ha ha
An interesting question to be fair with you. But some one has to answer this qn :(

It is quite simple.

Let us say earlier each side of the swimming pool is 10m long and oak trees are on each corner.

Now they just need to expand the swimming pool in such a way that each edge...

Actually they are not facing towards the sea instead they are facing towards the ship.

It is very simple Sowji,

find LCM of 2,3,4...8 and 9 then subtract 1 from that number. that is it:)


Thanks,
James

Here is one answer : ((5+5)/5 )^5 +5

((5+5)/5 )^5 +5 = ((10)/5 )^5 +5
= 2^5 +5
= 32 + 5
= 37

Cheers,
James

Right approach from Suresh. Hats off man

It is simple,

I will take one fruit from the box MIXED. If i get apple then the box with the name ORANGE must be mixed and the box 'APPLE' must have oranges.

i can apply the same logic if i get...

No need for a correlated query. The following query does the same,

update emp_check a SET gender = decode (gender,'M','F','F','M',gender);

If you need only sum of overtime hours then the following query works for u

Select employeeid,sum(overtimehours )
from attendance
group by employeeid

If u want bothe sum of overtime and...

4 criminals are caught and are to be punished. The Judge allows them to be freed if they can solve a puzzle. If they do not, they will be hung. They agreed.

The 4 criminals are lined up on some...

I am not sure what you are talking about.

If you are talking about update DML trigger, then you can get the old and new variables using :old and :new bind variables.

let us take 89th prisoner . He guesses that the reminder is going to be 88

Hence his guess would be 100+88 -86 =102 (mod 100) = 2

Hope this clears your doubt

Hi,

I was also thinking like you. But it looks like the answer is wrong... [:(].

But now I am clear with the right approach and i know the answer [:)].

I would like to give one more chance...

lf number of steps is 1.

IF number of steps =2
There are two different ways to finish 11,2

If number of steps =3
There are three different ways to finish 111,12,21

If number of steps =4...

Sorry for the delay to post my solution.

Let us assume that the sum of all number assigned to 100 prisoners is S(P) and the number assigned to the first prisoner is n1, the number to the second...