Thanx for reply.
I found a very very good link regarding this solution.This much similar as yr but little modified.
...
Type: Posts; User: bhaski; Keyword(s):
Thanx for reply.
I found a very very good link regarding this solution.This much similar as yr but little modified.
...
Hi i have the data set like this -->
with t as
(
select 1 as invoice,5000 as tot_amount,'1/1/2008' as pay_date,100 as payment from dual
union
select 1 ,5000 ,'5/1/2008' ,200 from dual...
why not using bulk update method?
there r many ways 2 do this
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:766825833740
or search google pivot query
I prepared this document from oracle documentation think may help u--
a view cannot be modified by update, insert, or delete statements if the view query contains any
of the following...
there are so many processes to do so
i am assuming that table has one column(in my case t column salary)
with p as
(
select rownum as num,salary as salary from t
order by rownum desc
)...
a change
with t as
(
select rownum as num,t.* from your_table t
order by rownum desc
)
select t.*from t
where num<&desired_row
order by rownum
question is not advantage of dynamic sql but in such case i mentioned which is appropriate?
when to use dynamic sql rather than static sql
if answer is
in static sql one hve a fixed sql statement but where in dynamic sql u can build sql statements as charecter string at run time
...
hi plss try it with yr table
with t as
(
select rownum as num,t.* from your_table t
order by rownum desc
)
select t.*from t
where rownum<&desired_row
order by rownum
here in this forum people submits problems and members try their level best to solve problems.
So first give some real problems.
cheers
go through the link
sorry go to this link
http://www.adp-gmbh.ch/ora/concepts/sql_stmt.html
Nice.
This is truly and only soccer related sprint and (means of a striker) and longer distance (of a winger)
cheers.
i have seen Thoughts Of The Day thread .
It is very good thread of intellectual comments.Now i want to post a comment of ronaldo to those who love soccer--
“I've never timed myself over 100m, but...
i am interested in online training session.
In which topic this session will be given?
do u mean somthing like --
copy from user1@database1 to user2@database2 insert tab2 using select * from tab1
?
there are several functions to do your job
here i give u a sample query and it's o/p where i used dense_rank() and rank() function as see the o/p and then try to use it in yr query as needed.I...
have u pk/referential integrity on this table index on column?
according to the moderator u can use decode for it
here is a sample------
with t as
(
select 'a' as col from dual
union
select 'a' from dual
union
moderator said you the perfect ans i want to add somthing to it for knowledge sharing------
truncate statement resets the hwm(high water mark) to it's initial value and free the space.
pls send detail data of your table and req. o/p
thank you sir
hi pls explain me clearly how operaters in regexp works.
SELECT REGEXP_INSTR('500 Oracle Pkwy, Redwood Shores, CA', '[o][[:alpha:]]{4}', 1, 1, 0, 'i') RESULT
FROM dual
0/p is----> 5
can't understand what u want.
SQL> Select round (6500*0.5/100) from dual;
ROUND(6500*0.5/100)
-------------------
33
SQL> Select (6500*0.5/100)from dual;
sorry i don't know sql server but if u want it in oracle i can do that.