Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
sum of array in pl/sql
DECLARE type markarray is varray(10) of number; vmark markarray; total integer; begin vmark:=markarray(16,29,32,45,52,60,71,75,38,16); total:=vmark(1)+vmark(2)+vmark(3)+vmark(10)+vmark(8)+vmark(9); dbms_output.put_line('sum:'||total); end;
run
|
edit
|
history
|
help
0
Srinivas
create table
SELECT table_name FROM user_tables
PL/SQL declaracionVariables
admt
Srinivas
ERR
Srinivas
Create a dynamic table
ttt