Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE OR REPLACE PROCEDURE VYSKLADAJ_SKUPINU
- (
- P_PRACOVISKO VARCHAR2
- , P_ODBOR ST_ODBORY.ST_ODBOR%TYPE
- , P_ZAMERANIE ST_ODBORY.ST_ZAMERANIE%TYPE
- , P_ROCNIK STUDENT.ROCNIK%TYPE
- , P_KRUZOK IN VARCHAR2
- , P_ST_SKUPINA OUT STUDENT.ST_SKUPINA%TYPE
- ) AS
- BEGIN
- SELECT '5' || P_PRACOVISKO || sk_odbor || sk_zamer || P_ROCNIK || P_KRUZOK
- INTO p_st_skupina
- FROM priklad_db2.st_odbory
- WHERE c_st_odboru = p_odbor
- AND C_SPECIALIZACIE = p_zameranie;
- END VYSKLADAJ_SKUPINU;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement