| dense_rank() in forms 6i [message #283066] |
Mon, 26 November 2007 01:10  |
varu123
Messages: 754
Registered: October 2007
|
Senior Member |
|
|
I have a procedure thats uses DENSE_RANK() function in WHEN BUTTON PRESSED trigger.
I am using it as: dense_rank()over(order by b.v_no)in the code
WHen itry to complile it, it shows the error:
Encounter the sysmbol "(" when expecting on of the following:
,from.
The code runs well in sqlplus.
|
|
|
|
|
|
| Re: dense_rank() in forms 6i [message #283128 is a reply to message #283066] |
Mon, 26 November 2007 03:10  |
varu123
Messages: 754
Registered: October 2007
|
Senior Member |
|
|
It seems your belief is correct.
I created a procedure
create or replace procedure proc
as begin
execute immediate 'select dense_rank()over(order by v_no)rank
from bill_ent';
end;
I want to use this procedure in my trigger to achieve the same functionality as dense_rank() in pl/sql.
I want to use rank as a column in the insert into statement.
HOw can ido that?or Can ido that?
|
|
|
|
|
|
| Re: dense_rank() in forms 6i [message #283164 is a reply to message #283066] |
Mon, 26 November 2007 04:08 |
varu123
Messages: 754
Registered: October 2007
|
Senior Member |
|
|
I have columns in my intr_vch_tmp_dtl1 table.
v_no,gr_amt....etc..
I want to assign rank to the v_no such that the rank changes as the v_no changes.
Something Like this:
rank v_no sal
1 10 1000
1 10 500
2 20 200
For this purpose i a m using Dense_rank but since it is not supported in forms 6i,Is there any workaround to achieve the same functionality?
|
|
|
|
|
|
|
|
|
|
| Re: dense_rank() in forms 6i [message #467327 is a reply to message #467317] |
Fri, 23 July 2010 06:10 |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
|
Perhaps you didn't notice, but it is not that the original poster doesn't understand DENSE_RANK, but his inability to use it in Forms Builder ver. 6.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
