Database

CREATE SEQUENCE SEQ_TEST
    MINVALUE 1
    START WITH 1
    INCREMENT BY 1
    CACHE 20
    ORDER
/

CREATE OR REPLACE TRIGGER TRG_TEST_AUTONUMBER 
BEFORE INSERT ON TEST
FOR EACH ROW
WHEN (NEW.ID IS NULL)
BEGIN
  SELECT SEQ_TEST.NEXTVAL
  INTO   :NEW.ID
  FROM   DUAL;
END;
/

Sharma Dinesh Kumar wrote:

I mean to Disable The Window Auth. mode.

Sharma Dinesh Kumar wrote:

So That Another Person Not To Open The database even in Window Auth. Mode.

I are troll

DECLARE @tbl TABLE (sField VARCHAR(20))

INSERT @tbl (sField) VALUES ('Z') 
INSERT @tbl (sField) VALUES ('A') 

SELECT * FROM @tbl

Mycroft Holmes wrote:

STOP - you are making me sick, this is the WORST design for a table you can possibly have. I STRONGLY suggest you chuck this table out and design a correct data structure. Something like:
Recipie
Ingredients