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.
Srinivas
Create a dynamic table
My PLSQL
Character inception test
regexp example
neha1
First_Last_Day
Srinivas
3
SQL for overlapping ranges
Please log in to post a comment.