var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
I have difficulty in writting a query. i have table with onle column and i have to populate a psudo column by updating the value in first column. follwing is the table
invoice no psudocolumn
that is i have 3 entry for same invoice no say 1000 and i want my psudo column will show entry 10001, 10002,1003 for that corrosponding invoice no entry.
thnax in advance
SET psudocolumn = invoice+no + rownum
hey carlo it wil work for first invoice no 1000 but for invoice no 2000 my psudo column would be 20004 instead of 20001.
invoice || to_char( rank() over (partition by invoice order by rownum) ) psuedo
Actually your gonna need to wrap that update to reset the rownum counter.
CURSOR c_cur IS
SELECT DISTINCT invoice_no
FOR lv_rec in c_cur LOOP
SET psudocolumn = invoice_no +rownum
WHERE invoice_no = lv_rec.invoice_no ;
Thank you very much
I really appriciate your prompt reply