[Waste-first] WasteFirst_post_deployment_SQL_script_run_log

[oracle at epic229.dep.state.fl.us]

SQL> SET serveroutput ON SIZE 1000000
SQL> spool $sqlDir/WF_Script_1.lis
/u01/projects/scripts/sqlScript/WF_Script_1.lis
SQL> /******************************************************************************
DOC> *		     FOR USE ON THE SERVER EWOC DATABASE			  *
DOC> *----------------------------------------------------------------------------*
DOC> * PURPOSE: 								  *
DOC> * - Required data for Nortification feature				  *
DOC> *										  *
DOC> * EXECUTE THIS AS EWOC							  *
DOC> *										  *
DOC> * Author: Rajitha Kantamneni						  *
DOC> *										  *
DOC> * Date:   21 July, 2006							  *
DOC> *										  *
DOC> ******************************************************************************/
SQL> SELECT systimestamp FROM dual;
22-JUL-06 04.30.00.527544 AM -04:00                                                                                                                   

1 row selected.

SQL> 
SQL> UPDATE stcm.first_client_updates
  2  	 SET clients = null
  3  	 WHERE	first_client_update_id = 18;

1 row updated.

SQL> 
SQL> SELECT systimestamp FROM dual;
22-JUL-06 04.30.00.650545 AM -04:00                                                                                                                   

1 row selected.

SQL> --------------------
SQL> spool off
/u01/projects/scripts/sqlScript/WF_Script_2.lis