Database

insert into tablename<br />
select name,'2009' from tablename where [year]='2008'

SQL> DESC TEST
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------
 ID                                        NOT NULL NUMBER
 NAME                                               VARCHAR2(10)
 YEAR                                               NUMBER(4)

SQL> 

SQL> INSERT INTO TEST
  2  SELECT NAME,2009 FROM TEST WHERE YEAR=2008
  3  /
INSERT INTO TEST
            *
ERROR at line 1:
ORA-00947: not enough values

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