SELECT O.ROWID, O.* FROM OV_VIEWS O WHERE O.OVERVIEW_ID = :id
CREATE TABLE OV_VIEWS
(
OVERVIEW_ID VARCHAR2(10) NOT NULL,
OVNAME VARCHAR2(50) NULL,
FILTER_ID VARCHAR2(10) NULL,
CATEGORY VARCHAR2(20) NULL,
ENABLED CHAR(1) DEFAULT '1' NULL,
RESTRICTED CHAR(1) DEFAULT '0' NULL,
IS_PUBLIC CHAR(1) DEFAULT '0' NULL,
BIN_IMAGE BLOB NULL,
LAST_MOD_DATE DATE NULL,
REFRESH_LEVEL INTEGER DEFAULT 0 NULL,
COLUMN_INF CLOB NULL,
ORDER_INF CLOB NULL,
ACCOUNT_ID VARCHAR2(10) NULL,
LAST_MOD_ACCOUNT VARCHAR2(10) NULL,
IS_AREA_OF_RESP CHAR(1) DEFAULT '0' NULL,
AREA_OVERVIEW_ID VARCHAR2(10) NULL,
PNG_IMAGE BLOB NULL
)
LOGGING
NOCACHE
NOPARALLEL;