Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started