Entity relationship diagrams and pl/sql code

Could you tell me about some examples worked out with entity relationship diagrams and pl/sql code of perhaps sales projects, stores, online sales.
Where can I find some examples of complete projects with modeling, entity relationship diagrams and the development of the above mentioned with pl/sql packages, functions, procedures

Thank you so much