# Search:

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

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

by Ash4u
5
Views
2,530

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

Hi,

yes you are correct.Thanks for rectifying.

by Ash4u
5
Views
3,174

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
20
Views
18,979

### 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

by Ash4u
6
Views
8,417

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
6
Views
24,472

### 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
7
Views
17,682

### 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
5
Views
2,530

### 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
5
Views
2,530

### 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