| PL/SQL by exmaple multi choice question [message #386123] |
Thu, 12 February 2009 16:46  |
happyjoshua777
Messages: 33
Registered: February 2009
Location: United States
|
Member |
|
|
how are you? i was wondering if someone could help me...
I am readin PL/SQL by Example 3rd edition and on page 65 there was the following question:
which of the following are valid character types for PL/SQl?
a. numbers
b. english letters
c. paragraph returns
d. arith. symbols
e. Japanese Kanji
The answer at the back of the book is B. I thought when i 1st saw this question that it should be both A and B since CHAR type excepts LETTERS and NUMBERS (integers) and not just English letters. I looked in to Errata and there is not correction.
please help,
thank you:)
|
|
|
|
| Re: PL/SQL by exmaple multi choice question [message #386127 is a reply to message #386123] |
Thu, 12 February 2009 17:03  |
ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany
|
Senior Member |
|
|
Seems wrong to me, too.
| Quote: |
You use the CHAR datatype to store fixed-length character data. How the data is represented internally depends on the database character set.
|
Source
And the same is true for varchars.
So any characters can be valid if the character set supports them, which would basically include ALL the answers in the list.
|
|
|
|
|
|
| Re: PL/SQL by exmaple multi choice question [message #386131 is a reply to message #386128] |
Thu, 12 February 2009 17:24 |
ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany
|
Senior Member |
|
|
Unless they mean something completely different by "valid character types for PL/SQL", like some definition of "character" that can be used in PL/SQL code that they only use in the book.
For instance, a variable name in PL/SQL can only contain English characters and numbers (and a few other characters like - and _) , and must start with an character. But that is not really called a character "type" in the normal documentation.
[Updated on: Thu, 12 February 2009 17:25] Report message to a moderator |
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
