Oracle Write declare example

Attention:

1. Assign Value: =

2. Or the relationship is represented by or

Declare

Prefix VARCHAR2 (2); --Prefix

Res_value VARCHAR2 (20);

Begin

Prefix: = ' QZ ';

For I in (select Col1,col2 from table_name) loop

If i.col1= ' col1 ' or i.col2= ' col2 ' then
Res_value: = ' 123456 ';
End If;

End Loop;

Res_value: = SUBSTR (res_value,0,2); --intercepts the string starting from the first bit (0 and 1 representing the first digit) to intercept 2

Dbms_output.put_line (Res_value); --Output statement

End

Final Output "12"

Oracle Write declare example