PL/SQL Character Set

Published: 30 March 2020
on channel: Anand Harsha
768
23

PL/SQL Character Set

basic character set includes
1. alphbets A-Z(Upper case)
and a-z(Lower Case)
2. Numbers 0-9
3. Symbols ()+-*/=!;:.@etc


Note : Words used in PL/SQL block are
called lexical units and blank space can be used between lexical units this have no effect on the pl/sql block

Literals
Literals is a numeric or character string used to represent itself. It is of three types

1. Numeric literals
Can be either integer or floats. floating part can be represented using and separated by period symbol. Some eg.
2,6,124, 23.45,23e-3,+17 etc

2.String Literals/Character Literals
'Hello world!' (Set of characters)
'a','*' etc

3.Logical Literals
these are predetermined constants, the values can be assigned to this data type are TRUE,FALSE,NULL.


You can write to me

anandharsha44@gmail.com

or you can reach me on

https://www.anandharsha.wordpress.com

for more videos on oracle.


On this page of the site you can watch the video online PL/SQL Character Set with a duration of online in good quality, which was uploaded by the user Anand Harsha 30 March 2020, share the link with friends and acquaintances, this video has already been watched 768 times on youtube and it was liked by 23 viewers. Enjoy your viewing!