Search:

Type: Posts; User: jamesravid; Keyword(s):

Page 1 of 7 1 2 3 4

Search: Search took 0.02 seconds.

  1. Answers
    6
    Views
    9,442

    Re: pirates of the caribbean

    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 :)
  2. Answers
    10
    Views
    9,432

    Re: Prisoners problem....

    perhaps you did not pay much attention to my solution ;)...just kidding
  3. Answers
    30
    Views
    16,237

    Re: A simple Puzzle

    through out his life time?? ha ha ha
    An interesting question to be fair with you. But some one has to answer this qn :(
  4. Answers
    10
    Views
    20,673

    Re: Find the number....

    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
  5. Answers
    11
    Views
    10,707

    Re: Get 37 by using five five's

    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
  6. Answers
    7
    Views
    12,644

    Re: Chess board?

    Right approach from Suresh. Hats off man
  7. Answers
    7
    Views
    9,106

    Re: Find the correct boxes

    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...
  8. Answers
    8
    Views
    8,679

    Oracle Re: Convert Gender Column

    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);
  9. Oracle Re: calculating the sum of a field in a query with join

    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...
  10. Answers
    9
    Views
    166,799

    Who will shout first...

    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...
  11. Answers
    3
    Views
    1,676

    Oracle Re: Call Updated Value in Trigger

    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.
  12. Answers
    10
    Views
    9,432

    Re: Prisoners problem....

    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
  13. Answers
    10
    Views
    8,722

    Re: I lost my Boarding pass

    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...
  14. Answers
    8
    Views
    8,898

    Re: Climbing 10 Steps

    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...
  15. Answers
    10
    Views
    9,432

    Re: Prisoners problem....

    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...
  16. Thread: sql

    by jamesravid
    Answers
    1
    Views
    1,516

    SQL Re: sql

    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...
  17. Answers
    10
    Views
    9,432

    Re: Prisoners problem....

    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...
  18. Answers
    20
    Views
    13,512

    Re: How old is Chris now?

    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...
  19. Answers
    7
    Views
    8,936

    Re: oracle 10g certification

    Yes. To become a Oracle Certified professional (OCP) you have to complete hands-on training for at least one paper.
  20. Answers
    10
    Views
    9,432

    Prisoners problem....

    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...
  21. SQL Re: How DUAL diplays strings of length more than 1

    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,...
  22. Thread: puzzle

    by jamesravid
    Answers
    4
    Views
    3,168

    Re: puzzle

    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
  23. Answers
    5
    Views
    2,172

    SQL Re: Need a sql query or procedure or function

    Thanks dude...I have learnt a new concept today. Thanks a lot:)
  24. Answers
    13
    Views
    15,298

    Re: Find the next two numbers of the sequence

    Actually I was expecting Suresh answer only.

    But Govind I can't say your answer is wrong...good thinking man.
  25. Answers
    5
    Views
    2,172

    SQL Re: Need a sql query or procedure or function

    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;

    ...
Results 1 to 25 of 173
Page 1 of 7 1 2 3 4
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact