Guest User

Untitled

a guest
May 23rd, 2018
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.40 KB | None | 0 0
  1. create or replace function idxF(status IN char) return char deterministic is
  2. retVal CHAR(1);
  3. begin
  4. dbms_output.put_line('P');
  5. retVal:=CASE status
  6. when 'P' then 'P'
  7. when 'H' then 'H'
  8. else null
  9. end ;
  10. return retVal;
  11. end idxF;
  12. create index setIndexOnStatus on ORDER(idXF(STATUS));
  13.  
  14. SQL Error: ORA-00904: "IDXF": invalid identifier
  15.  
  16. create index setIndexOnStatus on "ORDER"(idXF(STATUS));
Add Comment
Please, Sign In to add comment