CREATE TABLE FAVORITOS(
   IDFAVORITOS 			VARCHAR2(200) 	NOT NULL,
   NMFAVORITOS 			VARCHAR2(200) 	NOT NULL,
   DSFAVORITOS 			VARCHAR2(200) 	NOT NULL,
   CDOPERADOR 			VARCHAR2(12)  	NOT NULL,
   NRORG 				NUMBER 			DEFAULT SYS_CONTEXT('nrorg_ctx','nrorg') NOT NULL,
   IDATIVO          	VARCHAR2(1)     DEFAULT 'S' NOT NULL,
   DTINCLUSAO       	DATE            DEFAULT SYSDATE,
   DTULTATU         	DATE            DEFAULT SYSDATE,
   NRORGINCLUSAO 		NUMBER 			DEFAULT SYS_CONTEXT('nrorg_ctx','nrorg') NULL,
   CDOPERINCLUSAO   	VARCHAR2(12)    DEFAULT '1' NULL,
   NRORGULTATU      	NUMBER 			DEFAULT SYS_CONTEXT('nrorg_ctx','nrorg') NULL,
   CDOPERULTATU     	VARCHAR2(12)    DEFAULT '1',
		CONSTRAINT PK_FAVORITOS PRIMARY KEY (IDFAVORITOS),
		CONSTRAINT CKC_IDATIVO_FAVORITOS CHECK (IDATIVO IN ('S','N'))
)
/ 