Increase sequence value

--add 1000 to sequence current value

DECLARE
   i   NUMBER;
   a   NUMBER;
BEGIN
   FOR i IN 1 .. 1000
   LOOP
      SELECT appuser.sq_fisno.NEXTVAL
        INTO a
        FROM DUAL;
   END LOOP;
END;

Excel to insert sql

Zaman zaman hepimize bu tarz bir uygulama lazım olmuştur.

Tablo formatındaki bir verinin insert ifadelerinin oluşturulması :)

http://tools.perceptus.ca/text-wiz.php?ops=7

Örnek Tablo:

apple
types	color	size
golden	yellow's my favorite colour	large
mac	reddish	medium
golden	red	varies
gala	yellowish	small

Returns:

INSERT INTO apple (types,color,size) VALUES ('golden','yellow\'s my favorite colour','large');
INSERT INTO apple (types,color,size) VALUES ('mac','reddish','medium');
INSERT INTO apple (types,color,size) VALUES ('golden','red','varies');
INSERT INTO apple (types,color,size) VALUES ('gala','yellowish','small');