Search:

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

Search: Search took 0.00 seconds.

  1. Data Warehousing - Re: I want to load target table as totalsal for each record

    Hi,


    yes you are correct.Thanks for rectifying.
  2. Answers
    5
    Views
    4,691

    Oracle Re: Want to know about this term in SQL

    Explain plan is to find the excution cost of a particular query.
    Independent of the sequencing of statments it gives the cost of a query in terms of time taken to execute the same.

    the explain...
  3. Answers
    20
    Views
    267,816

    Re: How old is Chris now?

    Pat's Present Age = 24

    let Chris be x years younger to pat.

    So , present age of Chris = 24 -x.

    SO when Pat's Age was 24-x (present age of chris)

    Then Chris's age = 24-x-x=24-2x
  4. Answers
    6
    Views
    14,764

    Re: Simple one to start with...

    Let Initially total number of apples be x.

    After first person takes his share : x*2/3

    After second person takes his share : (x*2/3)*2/3
    N.b. each time one person taes his share left one is two...
  5. Answers
    6
    Views
    25,678

    Oracle Re: I want SQL query output into excel

    The same can be done using third party tool
  6. Oracle Re: Inserting nextval after sequence has reached maximum value

    ORA-08004: sequence ASHISH.NEXTVAL exceeds MAXVALUE and cannot be instantiated
    This is the error oracle will throw
  7. Data Warehousing - Re: I want to load target table as totalsal for each record

    create table totalsal as
    select emp.*, (nvl(sal,0)+nvl(comm,0))totalsal from emp

    This is the simplest solution.
  8. Data Warehousing - Re: I want to load target table as totalsal for each record

    one of the most simplest way is doing the same with an sql loader program.

    Also you can use a External table and then do the change.

    First take all data from source table into excel sheet.
    ...
Results 1 to 8 of 8
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