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 :)
Type: Posts; User: jamesravid; Keyword(s):
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 :)
perhaps you did not pay much attention to my solution ;)...just kidding
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 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...
There are so many ways to achieve this in oracle.
1. create a view on the table only with those rows and columns that you want to share. Don't give any access privilege on table instead allow the...
I have the solution for this problem. Let us wait for few more days so that others can give a try.
Definitely you will be having the solution in this thread by the next week end. It can be either...
It looks like you people still have confusion in this problem. The following statement is a tricky one,
Pat is twice as old as Chris was when Pat was as old as Chris is now
let us assume that...
Yes. To become a Oracle Certified professional (OCP) you have to complete hands-on training for at least one paper.
Here is one of the famous challenging puzzle...
There are 100 prisoners assigned by numbers in 1 to 100 . Any number can be assigned to them . They need not be unique. They can talk one time...
you need to understand that you can also have literals in your select clause. Actually '12345' is a literal not a column value.
For instance in the following query displays the current server date,...
Each of them started with 100 marbles.
It is given than 4( (a+20)/3 ) = 5a/3 +40/3 -20
solving this you will get a = 100
Thanks dude...I have learnt a new concept today. Thanks a lot:)
Actually I was expecting Suresh answer only.
But Govind I can't say your answer is wrong...good thinking man.
Here is an Oracle pl/sql for printing tables with no records,
declare
/*Cursor to fetch all table names in the current schema*/
cursor table_csr is
select table_name from user_tables;
...