Question: Based on the following definition, correct the below code and find the generated outputs in the tagged line below: use oracle live Declare val1
Based on the following definition, correct the below code and find the generated outputs in the tagged line below: use oracle live Declare val1 varchar2(30):= 'HelKSWE$32070'; val2 number(2); val3 varchar2(30); val4 varchar2(30); Begin Outputs: 1. 2. 3. 4. 5. val2: INSTR(val1, 'S'); DBMS_OUTPUT.PUT_LINE (val2:' || val2); val3:= SUBSTR(val1, 1, (val2-1)); DBMS_OUTPUT.PUT_LINE DBMS_OUTPUT.PUT_LINE DBMS_OUTPUT.PUT_LINE DBMS_OUTPUT.PUT_LINE (val3); (val1 ); (val2); ( length || Length(val 1)); val4:= SUBSTR (val1, val2, (LENGTH(val1)- val2)); DBMS_OUTPUT.PUT_LINE (val4);
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
