This preview shows page 1. Sign up to view the full content.
Unformatted text preview: select count(movie_cat_id) into v_count from mm_movie_type where movie_cat_id = 6--auto number select max(movie_id) into v_new_id from mm_movie-- assign new value v_new_id := v_new_id + 1-- Insert Insert into mm_movie (movie_id, movie_title, movie_cat_id, movie_value,Movie_qty)...
View Full Document
This note was uploaded on 06/11/2011 for the course DBM 405 taught by Professor Panja during the Spring '11 term at DeVry Columbus North.
- Spring '11