Database Administrator
Showing posts with label
plsql
.
Show all posts
Showing posts with label
plsql
.
Show all posts
Tuesday, July 20, 2010
Bulk Updation in Address: Move one column data to another
›
Declare cursor CUR_TAB is SELECT rowid,a.* FROM accountaddressdetail11 a WHERE CODE LIKE 'In%'; l_b number:=0; Begin for CUR_REC in ...
Bulk Updation: update EmailCC column
›
Declare cursor CUR_BULK_UPDATE is SELECT rowid,a.* FROM ACCOUNTEMAILDETAIL a WHERE CODE NOT LIKE '%M'; l_b number:=0; Begin for CURS...
›
Home
View web version