answered
The advantage of the pl/sql over the sql is we use the procedures to  perform more then one query and to solve the complex problem which do not solve through  the single query,we also used the trigger to fire the event