Hi,
yes you are correct.Thanks for rectifying.
Type: Posts; User: Ash4u; Keyword(s):
Hi,
yes you are correct.Thanks for rectifying.
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...
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
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...
The same can be done using third party tool
ORA-08004: sequence ASHISH.NEXTVAL exceeds MAXVALUE and cannot be instantiated
This is the error oracle will throw
create table totalsal as
select emp.*, (nvl(sal,0)+nvl(comm,0))totalsal from emp
This is the simplest solution.
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.
...