Insert via Script replicate data set January 29, 2016 DECLARE CURSOR C1 IS SELECT COLUMN_NAME FROM TABLE WHERE CONDITIONS; BEGIN FOR R1 IN C1 LOOP INSERT INTO TABLE 2(COLUMN DEFINING) VALUES (VALUES DECLARATION); END LOOP; END ; Read more
Update existing varchar column which has numbers and add 000 before the value January 06, 2016 UPDATE TABLE_NAME SET COLUMN_NAME = LPAD(COLUMN_NAME, 4 , '000' ) WHERE CONDITIONS; Read more