Search:

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

1. Thread: I want to load target table as totalsal for each record

by Ash4u
Answers
5
Views
2,312

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

Hi,

yes you are correct.Thanks for rectifying.
2. Thread: Want to know about this term in SQL

by Ash4u
Answers
5
Views
2,863

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. Thread: How old is Chris now?

by Ash4u
Answers
20
Views
15,403

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. Thread: Simple one to start with...

by Ash4u
Answers
6
Views
7,735

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. Thread: I want SQL query output into excel

by Ash4u
Answers
6
Views
24,248

Oracle Re: I want SQL query output into excel

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

by Ash4u
Answers
7
Views
17,255

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. Thread: I want to load target table as totalsal for each record

by Ash4u
Answers
5
Views
2,312

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. Thread: I want to load target table as totalsal for each record

by Ash4u
Answers
5
Views
2,312

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.