Tag Info

New answers tagged

1

It is in fact a configuration issue in the Oracle Client Set NLS_LANG to AMERICAN_AMERICA.WE8MSWIN1252 and no more conversion error. UPDATE Why? Because 0.6 in French would be read as a character value whereas in English it remains numeric. 0,6 in French is 0.6 in English. Defining NLS_LANG as American means that 0.6 stays numeric thus allowing the ...


0

It is the definition v_ord_rec c_ord_cur%ROWTYPE; that is wrong. It must be v_ord_rec shoba.ord%ROWTYPE;. Also the insert statements should insert into real table and not into the cursor.


0

Reference: Oracle Forum WITH ADRECURSIVEUSERLEADER AS ( SELECT CONNECT_BY_ROOT US.CDLEADER AS CDLEADER ,US.CDUSER AS CDUSER ,US.NMUSER ,US.FGUSERENABLED FROM ADUSER US CONNECT BY PRIOR US.CDUSER = US.CDLEADER -- child / parent ) SELECT * FROM ADRECURSIVEUSERLEADER T WHERE 1 = ...


1

I found by only using update you can also do this. ` UPDATE concatenate c2 SET c2.payer_name = source_id ||' '|| payer_name WHERE c2.rowid > (SELECT min(c1.rowid) FROM concatenate c1 WHERE upper(c1.payer_name)=upper(c2.payer_name));'


2

Use partition by on the name column, and count the rows based on the order of id-s. Where the row number of the actual row is greater than 1, concatenate id and name, else just use the name. with t as ( select 1 as id, 'john' as name from dual union all select 2, 'david' from dual union all select 3, 'zed' from dual union all select 4, 'john' from dual ...


0

Resolved by removing Alias ASMCMD> rmalias '+TEMPDATA/rm/datafile/TEMPRM_TEMPFILE_1.dbf'



Top 50 recent answers are included