Question: Create table named characters, the table have only two columns ( ch char ( 1 ) , type varchar 2 ( 1 5 ) )
Create table named characters, the table have only two columns ch chartype
varchar
b Fill in the table with the following data:
ch type
a
B
C
c Write a complete PLSQL block to check the characters stored in the characters
table whether they are letters or digits, place the type of character in the "Type" field.
d Commit before the end of the block.
e Select from characters table to verify that your PLSQL worked.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
