package ODI;

import com.sunopsis.dwg.DwgObject;
import java.sql.*;

public class decrypt_password {

@SuppressWarnings(“deprecation”)
public static void main(String[] args) {

@SuppressWarnings(“deprecation”)
String strMasterPassEnc=”dNfHRQilqhZhupd,MDGYw7H5pEMUKrd”;
String strMasterPass=DwgObject.snpsDecypher(strMasterPassEnc);
System.out.println(strMasterPass);

}

}

You can find out which format (unix or dos) you have by typing :set

Display CRLF as ^M:
:e ++ff=unix

Substitute CRLF for LF:
:setlocal ff=unix
:w
:e

SELECT   ‘, ‘ || dtc.column_name
, dtc.num_distinct
, dtc.avg_col_len
FROM     dba_tab_cols dtc
WHERE    dtc.owner = ‘DWFACTS’
AND      dtc.table_name = ‘STATELINES_FACT’
ORDER BY dtc.num_distinct
, dtc.avg_col_len DESC;

To tar a directory

tar -zcvf <tarname>.tar.gz <directory>/

• -z: Compress archive using gzip program
• -c: Create archive
• -v: Verbose i.e display progress while creating archive
• -f: Archive File name

To untar a directory

tar -zxvf <tarname>.tar.gz

CREATE OR REPLACE FUNCTION username.parse_xml
( p_string     IN     VARCHAR2
, p_node       IN     VARCHAR2
)  RETURN VARCHAR2 AS
v_data                 VARCHAR2(4000);
v_node                 VARCHAR2(4000);
v_upper_str            VARCHAR2(4000);
v_startnode            VARCHAR2(4000);
v_endnode              VARCHAR2(4000);
v_startnodelength      NUMBER;
BEGIN
v_node               := UPPER( p_node );
v_upper_str          := UPPER( p_string );
v_startnode          := ‘<‘ || v_node || ‘>’;
v_endnode            := ‘</’ || v_node || ‘>’;
v_startnodelength    := LENGTH( v_startnode );
v_data := SUBSTR( p_string
, INSTR( v_upper_str, v_startnode ) + v_startnodelength
);
v_data := SUBSTR( v_data
, 1
, INSTR( UPPER( v_data ), v_endnode ) – 1
);
RETURN( TRIM(v_data) );
END;
/

CREATE TABLE username.XML_TABLE
(
XML  VARCHAR2(4000 BYTE)                          NULL
)
ORGANIZATION EXTERNAL
(  TYPE ORACLE_LOADER
DEFAULT DIRECTORY TMP
ACCESS PARAMETERS
( RECORDS DELIMITED BY ‘</item>’
BADFILE TMP’xml_file.bad’
LOGFILE TMP’xml_file.log’
FIELDS TERMINATED BY “,” LDRTRIM
)
LOCATION (TMP’xml_file.xml’)
)
REJECT LIMIT UNLIMITED
NOPARALLEL
NOMONITORING;

SELECT ROWNUM item_id
, username.parse_xml ( xml, ‘col1’ ) col1
, username.parse_xml ( xml, ‘col2’ ) col2
, username.parse_xml ( xml, ‘col3’ ) col3
, username.parse_xml ( xml, ‘col4’ ) col4
, username.parse_xml ( xml, ‘col5’ ) col5
FROM   username.XML_TABLE;

PROCEDURE WRITE
( p_text       IN VARCHAR2
, p_file       IN VARCHAR2 DEFAULT ‘d_log.log’
, p_action     IN VARCHAR2 DEFAULT ‘A’
, p_log_table  IN BOOLEAN  DEFAULT FALSE
, p_log_status IN VARCHAR2 DEFAULT ‘SUCCESS’
) IS
v_log utl_file.file_type;
PRAGMA AUTONOMOUS_TRANSACTION;
BEGIN
v_log  := utl_file.fopen( ‘LOG’
, p_file
, p_action
);
utl_file.put_line( v_log
, TO_CHAR(SYSDATE,’YYYY-MM-DD HH24:MI:SS’) || ‘ ‘ || p_text
);
utl_file.fclose( v_log );
IF p_log_table
THEN
INSERT INTO dwfacts.batch_log
( log_date
, log_text
, log_status
)
VALUES ( SYSDATE
, p_text
, p_log_status
);
COMMIT;
END IF;
END WRITE

SELECT LEVEL
, ss.parent_sess_no
, ss.sess_no
, CONNECT_BY_ROOT
ss.sess_name root_sess_name
, LPAD(‘> ‘,3*(LEVEL-1),’-‘) || sess_name sess_name
, ss.sess_beg
, ss.sess_end
, stl.rows_processed
, ss.sess_dur
, ss.sess_status
FROM  odi_atlas_work.snp_session ss
, (SELECT sess_no
, SUM(ABS(nb_row)) rows_processed
FROM odi_atlas_work.snp_sess_task_log
WHERE TRUNC(task_beg) >= ’01-JUL-2011′
AND TRUNC(task_end) < ’02-JUL-2011’
GROUP BY sess_no ) stl
WHERE      ss.sess_no = stl.sess_no
AND UPPER(ss.agent_name) = ‘APOLLOSERVER’
START WITH ss.parent_sess_no IS NULL
AND ss.sess_beg >= ’01-JUL-2011′
AND ss.sess_end < ’02-JUL-2011′
CONNECT BY PRIOR ss.sess_no = ss.parent_sess_no

http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14261/subprograms.htm#i18574

To give the package the same rights as the caller of the package