     START WITH 10000000
     NOCACHE ORDER NOCYCLE;
 
-  --Get Current Sequence Value without increment:
+  -- Renamed ASSET_ID_SEQ to ASSET_SEQ
+  CREATE SEQUENCE FMDR.ASSET_SEQ
+    MINVALUE 10000000 MAXVALUE 999999999
+    INCREMENT BY 1 START WITH 10001055
+    NOCACHE ORDER NOCYCLE;
+
+
+  -- Get Current Sequence Value already in Session without increment:
   SELECT FMDR.ASSET_ID_SEQ.CURRVAL FROM DUAL;
 
-  --Get Current Sequence Value and increment its value (except for the initial value):
+  -- Get Current Sequence Value and increment its value (except for the initial value):
   SELECT FMDR.ASSET_ID_SEQ.NEXTVAL FROM DUAL;
 
-  --To see the lastest LAST_NUMBER without incrementing the Sequence Object:
+  -- To see the lastest LAST_NUMBER without incrementing the Sequence Object: 
+  -- Or without having the CURRVAL value in current Session.
   SELECT *
     FROM USER_SEQUENCES
    WHERE SEQUENCE_NAME = 'ASSET_ID_SEQ';

/* FURTHER MDR DDL */

/* FMDR USER */
/* 
CREATE USER FMDR IDENTIFIED BY fmdr
  DEFAULT TABLESPACE FRTHR

    INCREMENT BY 1
    START WITH 9000
    NOCACHE ORDER NOCYCLE;

  -- Moment of Reset to New Sequence Scheme of 10000000
  CREATE SEQUENCE FMDR.ASSET_ID_SEQ
    MINVALUE 9000 MAXVALUE 9999
    INCREMENT BY 1 
    START WITH 9146
    NOCACHE ORDER NOCYCLE;
*/


/* ***** BEG TABLES ***** */
