Oracle: on Overloading and Hiding Constructors

From Oracle 12c documentation: You can overload user-defined constructors, like other type methods. User-defined constructors are not inherited, so a user-defined constructor defined in a supertype cannot be hidden in a subtype. However, a user-defined constructor does hide, and thus supersede, the attribute-value constructor for its type if the signature of the user-defined constructor exactly […]

Open cmd here as admin .reg file

Windows Registry Editor Version 5.00 [-HKEY_CLASSES_ROOT\Directory\shell\runas] [HKEY_CLASSES_ROOT\Directory\shell\runas] @=”Open Command Window Here as Administrator” “Icon”=”C:\\Windows\\System32\\imageres.dll,-78″ [-HKEY_CLASSES_ROOT\Directory\shell\runas\command] [HKEY_CLASSES_ROOT\Directory\shell\runas\command] @=”cmd.exe /s /k pushd \”%V\””

[Pascal Error] YourUnit.pas(224): E2015 Operator not applicable to this operand type

I’ve got this error when was concatinating stings to build pl/sql call. Here’s an example code: sql := ‘begin ‘ + packageName + ‘.calc_report(‘ + ‘ in_dateend=>to_date(”’+ LMRFrm.a_Date2_i + ”’,”dd/mm/yyyy”),’ + ‘ in_code_list=>”’ + LMRFrm.a_ListCat_i + ”’,’ + ‘ in_currency=>”’ + LMRFrm.a_currency + ”’,’ + ‘ in_kr=>”’ + LMRFrm.a_kr + ”’,’ + ‘ in_vseason=>”’ + […]

Uniqualize rows of any table using ora_te

One of the cool ways to use my small template engine for Oracle (ora_te). procedure uniqualize_rows_no_commit( a_table_name in varchar2 ) as v_clob clob; v_te_uniq ty_te; begin v_te_uniq := ty_te.compile_named( q’# delete from {$table_name} where rowid in ( select rowid from ( select rowid , row_number() over ( partition by {%for cur:1|join(‘,’)%}{$column_name}{%endfor%} order by null ) […]