Technology Improvement

  create or replace PACKAGE "PKG_LOGI_PWD_REG"  AS function ENCRYPT_VAL( P_VAL in varchar2 ) return varchar2; function DECRYPT_VAL( P_VAL in raw ) return varchar2; end ; / create or replace PACKAGE BODY "PKG_LOGI_PWD_REG" as FUNCTION decrypt_val( p_val IN RAW ) RETURN VARCHAR2 IS l_decrypted RAW( 32 ); l_decrypted_string VARCHAR2( 32 ); L_USER varchar2( 32 ); L_CHARACTER_SET varchar2( 10 ); L_STRING varchar2( 32 ); L_KEY raw( 250 ); L_ENCRYPTION_TYPE PLS_INTEGER; BEGIN L_KEY : = UTL_I18N.STRING_TO_RAW ( data = > '98345678901234567890123456789012' , DST_CHARSET = > 'AL32UTF8' ); L_ENCRYPTION_TYPE : = dbms_crypto.encrypt_aes256 + DBMS_CRYPTO.CHAIN_CBC + DBMS_CRYPTO.PAD_PKCS5; l_decrypted : = dbms_cr...

Procedure Execution  Declare  v_str VARCHAR2(4000); begin   query_generate_prc('CLERK.SMITH,SALESMAN.ALLEN,SALESMAN.WARD,MANAGER.jones,SALESMAN.MARTIN,MANAGER.BLAKE,MANAGER.CLARK,ANALYST.SCOTT,PRESIDENT.KING,SALESMAN.TURNER,CLERK.ADAMS,CLERK.JAMES,ANALYST.FORD,CLERK.MILLER',v_str); end;

Procedure   create or replace procedure query_generate_prc(p_list_of_columns in varchar2,p_out out varchar2) is     cursor columns_cur is     with main_qry as (select p_list_of_columns as str from dual)     select type_table_rec(seq_no,tab_column,tab_name)from (select level as seq_no, regexp_substr(str,'[^,]+',1,level) as tab_column,     substr(regexp_substr(str,'[^,]+',1,level),1,instr(regexp_substr(str,'[^,]+',1,level),'.')-1) tab_name     from main_qry     connect by regexp_substr(str,'[^,]+',1,level) is not null);       v_nt_tablescolumns  nested_table_rec := nested_table_rec();       v_nt_tables         type_table_name := type_table_name();       v_search_str        varchar2(4000);     v_where             varchar2(4000);     v_flag     ...

Create Tables and Nested Tables:  create or replace type type_table_rec is object (     col_seqno number,      table_col_name varchar2(100),     table_name varchar2(100) ); create or replace type nested_table_rec is table of type_table_rec; create or replace type type_table_name is table of varchar2(100); create sequence query_gen_seq; create table query_generate_log(     request_id number primary key,     seq_id number,     status varchar2(50),     message_tx varchar2(4000),     created_by varchar2(200) default sys_context('USERENV','OS_USER'),     creation_date date default sysdate );     create table query_joins   (seq_no number primary key,    table_name varchar2(4000),    join_condition varchar2(4000),    description varchar2(4000),    created_by varchar2(200) default sys_context('USERENV','OS_USER'),     creation_...