Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
display student details in pl/sql
declare type namesarray is varray(3) of varchar2(20); type grades is varray(3) of integer; names namesarray; marks grades; total integer; begin names:=namesarray('vikash','ranjeet','ratandeep'); marks:=grades(88,87,86); total:=names.count; dbms_output.put_line('Total '|| total || ' Students'); for i in 1 .. total loop dbms_output.put_line('Student: ' || names(i) || ' Marks: ' || marks(i)); END LOOP; end;
run
|
edit
|
history
|
help
0
Please
log in
to post a comment.
ishu
record type
[Manutenção] Prova Supero - Oracle
Bcom
Factorial
IT
Srinivas
addition of arrays
oracle plan
PL/SQL declaracionVariables
Please log in to post a comment.