Wednesday, October 14, 2009

ID Auto generation with SYS_GUID()

CREATE TABLE test_halim (ID RAW(16) DEFAULT SYS_GUID(), NAME VARCHAR2(10))


INSERT INTO test_halim(NAME) VALUES ('HALIM' );

INSERT INTO test_halim(NAME) VALUES ('HALIM1' );

INSERT INTO test_halim(NAME) VALUES ('HALIM2' );

COMMIT;


SELECT * FROM test_halim;

No comments: