Re: Online backup script..........

2001-07-04 Thread Svend Jensen
program to perform a hot database copy to disc:\filesystem (NT) -- Backup destination is set in the 'begin' section below, the line after: -- put your .. -- Log file is made of database alteration: dohotbackup.log and not for the copy process, -- Oco

Re: HOW TO SUBSTR & INSTR THIS LIST

2001-06-29 Thread Svend Jensen
full_name,' ',1)-1) midle_name, substr(full_name,instr(full_name,' ',-1)+1) last_name from table You might have to substitute full_name with replace(full_name, '-'.) to get rid of dashes or replace( repalce (full_name,'(' ) , '(' ) to get rid of

Re: Oracle Table Record Lock

2001-06-27 Thread Svend Jensen
istGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -