- Installation
$ git clone https://github.com/peihanw/plsql_runlog.git
$ cd plsql_runlog/
$ sh ./pls_chg_tbs.sh $REAL_TABLESPACE_NAME
$ sqlplus user/passwd@sid
> @run_log.sql
> @run_log_cfg.sql
> @l.sql
- Usage examples
$ sqlplus user/passwd@sid
> @pkg_unit_test.sql
> exec pkg_unit_test.case_01;
While RUN_LOG_CFG is configed below:
Only log text from line 10,8 and 7 will be logged.
Pkg_unit_test.case_02 is another example. Result screenshot below:
- For now, only 'extract' is provided in the CSV utility.
$ sqlplus user/passwd@sid
> @csv.sql
> select csv.extract('a,bb,ccc,dddd',3) from dual;
- Test environment is Oracle 11g (11.2.0.3.0).
- SQL is formatted with Toad Extension for Eclipse.