create directory logfile as 'C:\log_file'; -- must have priv to do thisdeclare SFile utl_file.file_type;begin SFile := utl_file.fopen(logfile ,'sunil','w'); -- w is write. This returns...
Breaking News
Tuesday, December 13, 2011
write log file from procedure in oracle
// first you will create the CREATE DIRECTORY f
create directory logfile as 'C:\LOG_DIR';
create or replace
PROCEDURE prcBreakDataCircleWise(tableName in varchar2) is
circlecode varchar2(20);
tbl_exist...
like with regular expressions in oracle
select sum(TERT_COUNT) from gj_chl_tert_sales where REGEXP_LIKE(TERT_COUNT, '[[:digit:]]');select sum(TERT_COUNT) from gj_chl_tert_sales where REGEXP_LIKE(TERT_COUNT, '[^0-9]');select...
Subscribe to:
Posts
(
Atom
)