GitHub

Deepika-3012/IMPLEMENTATION-OF-IMPLICIT-AND-EXPLICIT-CURSOR-TO-MANIPULATE-A-TABLE-IN-PL-SQL

A cursor is a pointer to this context area. PL/SQL controls the context area through a cursor. A cursor holds the rows (one or more) returned by a SQL statement. The set of rows the cursor holds is ...
GitHub

Prameterized_Cursor_2.txt

cursor c_supplier(no number) is select p.pid,p.pname,c.qty,p.unit_rate,(c.qty*p.unit_rate) "Total Price" from parts p,catalog c,supplier s where p.pid=c.pid and s.sid=c.sid and s.sid = no; ...
note

SQL Developer - PL/SQL - 最初の1歩

SQL DeveloperでPL/SQLを作成して実行してみたい。 まずは、Hello World的な事をやってみたい。 このペインに「パッケージ ...