For Project 2, you will implement the design as specified in project 1.
Some ideas for functions and procedures:
RANDOM function or package - picks a random number --- 2 examples are given to you
PX procedure - prints stars for separation
PL procedure - to save typing DBMS_OUTPUT.PUT_LINE
GET_SUIT function - Use a random number from 1 - 4 to return one of four suits ('Hearts', 'Clubs', etc..)
GET_CARD_NAME function - turns a 1 into an ACE, a 2 into TWO, 11 into Jack, 12 into Queen, etc..
NORMALIZE function - to convert jacks, queens, and Kings into a value of ten
DRAW procedure - used by a player or dealer to draw a card
CHECK_BUSTED function - see if anyone has a score over 21
... you get the idea ...
Example of desired output:
SQL> @objack1
Enter value for player_limit: 17
*******************************
Dealer's turn:
Drew a Ten of Diamonds
That's worth 10 points
. The total is now: 10 points.
*******************************
Player's turn:
Drew a Five of Spades
That's worth 5 points.
. The total is now: 5 points.
*******************************
Dealer's turn:
Drew a Four of Hearts
That's worth 4 points.
. The total is now: 14 points.
*******************************
Player's turn:
Drew a Seven of Clubs
That's worth 7 points.
. The total is now: 12 points.
******************************
Dealer's turn:
Drew a Seven of Hearts
That's worth 7 points.
. The total is now: 21 points
******************************
Player's Turn:
Drew an Eight of Spades
That worth 8 points.
. The total is now: 20 points.
******************************
Dealer won. What a Shame. Oh well, Play again.
Hello, I am full time employed SQL Server and Oracle developer, and I can make your blackjack application without much of a problem. You gave the pretty clear explanation of the project so i wouldn't have much of a questions. Also, ratings are very important to me so i would do my best. If you are interested in my help, feel free to contact me. Anyway, thank you for the consideration and I wish you all the best with your assignment :)
HI
Contact me for an efficient, perfect, well documented
development of your project according to 100% accuracy
and requirements, with dedicated support.
Thanks
Farah Saif
Hi,
I don't know what project 1 is and what was a requirement, but I created a package with some procedures and functions that plays black jack. Please contact me on PM for more information. Oracle is my expertise.
Here is my output when entering 20 for player_limit.
Enter value for player_limit: 20
*******************************
Dealer's turn:
Drew a Ace of Hearts
That's worth 1 points.
The total is now: 1
*******************************
Player's turn:
Drew a Queen of Clubs
That's worth 10 points.
The total is now: 10
*******************************
Dealer's turn:
Drew a King of Clubs
That's worth 10 points.
The total is now: 11
*******************************
Player's turn:
Drew a Six of Spades
That's worth 6 points.
The total is now: 16
*******************************
Dealer's turn:
Drew a Queen of Hearts
That's worth 10 points.
The total is now: 21
*******************************
Player's turn:
Drew a Queen of Spades
That's worth 10 points.
The total is now: 26
*******************************
Dealer won. What a Shame. Oh well, Play again.
PL/SQL procedure successfully completed.
I have 3 years of real time experience in IT programming particularly in SQL, and scripting languages like shell and Perl. The example given was quite same to the projects i worked for.
-I have completely understood this project & I have started working for it based on the example you gave.
-I have 1 year of experience in SQL & PL/SQL
-I have completed my training in SQL & PL/SQL with 100% score.
-I believe in quality work at low price.