rrudnik
7/9/2015 - 9:15 AM

Sql Fiddle

Sql Fiddle

sample.sql
content_copyfile_download
--build schema
create table abc(
  CRUISE_ID NUMBER,
  cr_date date)
//

CREATE SEQUENCE SEQ_CRUISE_ID
//

--run SQL
-- execute pl/sql block 
BEGIN
FOR i IN 1 .. 3 LOOP
  INSERT INTO abc(CRUISE_ID, cr_date)
  VALUES(SEQ_CRUISE_ID.NEXTVAL, sysdate-i);
END LOOP;
END;
//

SELECT CRUISE_ID,cr_date, ROWNUM,ORA_ROWSCN from abc
//