SQL Language (MOSC)

MOSC Banner

functional index condition

hello,

could you be so kind please and explain the condition in this functional index ?

CREATE UNIQUE INDEX "FSIPRDLIB"."HOUSEBILL_ACTIVE_UQ_IDX" ON "FSIPRDLIB"."HOUSEBILL" (CASE "STATUS" WHEN 4 THEN NULL WHEN 5 THEN NULL ELSE "WHCD" END , CASE "STATUS" WHEN 4 THEN NULL WHEN 5 THEN NULL ELSE "HBNUMBER" END )

PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS

STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "FSI" ;

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center