list_tracks.sql

来自「此程序都是企业级 的数据库开发程序 全面揭示了JAVA对数据库的操作」· SQL 代码 · 共 13 行

CREATE OR REPLACE FUNCTION list_tracks (id IN NUMBER)
RETURN types.cursorType IS tracks_cursor types.cursorType; 
BEGIN 
OPEN tracks_cursor FOR 
SELECT r.recordingid, t.tracknumber,
t.tracktitle
FROM recordings r, tracks t
WHERE r.recordingid = id 
AND t.recordingid = r.recordingid; 
RETURN tracks_cursor;
END;
/