Question: can u solve the mistake please??? Language SQL Rows 10 C A:: 1 create or replace function FindMax ( 2 x in number , y

 can u solve the mistake please??? Language SQL Rows 10 C
A:: 1 create or replace function FindMax ( 2 x in number
, y in number , z in number) 3 return number 4
can u solve the mistake please???

Language SQL Rows 10 C A:: 1 create or replace function FindMax ( 2 x in number , y in number , z in number) 3 return number 4 is 5 c number; 6 begin 7 if (x > y and x > 2 ) then c:=x; 8 elsif (y > x and y > 2) then c:=y; 9 else c=Z; 10 end if; 11 return; 12 end; 15 16 test it SET serveroutput on; Declare Results Explain Describe Saved SQL History APEX App Builder SQL Workshop Team Deve SQL Commands Language SQL Rows 10 Q Q A A:: 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 test it SET serveroutput on; Declare X number; y number; z number; s number; begin X:=10; y:=20; Z:=30; S:=FindMax(x,y,z); dbms_output.put_line('max of (10,20,30): '||s); end; Results Explain Describe Saved SOL History ORA-00922: missing or invalid option ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_200200", line 670 ORA-06512: at "SYS.DBMS_SYS_SQL", line 1658 ORA-06512: at "SYS. WWV_DBMS_SQL_APEX_200200", line 656 ORA-06512: at "APEX_200200. WWV_FLOW_DYNAMIC_EXEC", line 1768 4. y number(2):=20; 5. z number (2):=30; 6. s number; 7. begin 8. s:=FindMax(x,y,z)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!