Tips for making packages, procedures, other schema objects in Oracle Database
I am making a project for my portfolio using PL/SQL.
I am using Virtualbox with Oracle Developer Days installed so the schema I have is this:
Basically I need to make as many different things using PL/SQL as possible.
Please give me tons and tons of tips for different packages, procedures, functions, etc that I could make for this db to show I have PL/SQL knowledge.
I'm not asking for code. I'm asking for ideas of what would be good for me to make from experienced DB people. Thanks
I am using Virtualbox with Oracle Developer Days installed so the schema I have is this:
Basically I need to make as many different things using PL/SQL as possible.
Please give me tons and tons of tips for different packages, procedures, functions, etc that I could make for this db to show I have PL/SQL knowledge.
I'm not asking for code. I'm asking for ideas of what would be good for me to make from experienced DB people. Thanks
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
>>right,I should have said stored procedures.
What you posted implied stored procedures... I'm not following?
What you posted implied stored procedures... I'm not following?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
@slightwv sorry, my mistake. I was thinking that you could make a procedure and not store it.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you. This is a good start. Please post more ideas for me if you think of others. Thanks so much!
ASKER