👤

PAEXPLAIN PO, REPORT LANG

PL/SQL offers three kinds of
strings

Fixed-length strings - In such strings, programmers specify the length while declaring the string. The string is right-padded with spaces to the length so specified.

Variable length strings - In such strings, a maximum length up to 32,767, for the
string is specified and no padding takes place.

Character large objects (CLOB) - These are variable-lenath strings that can be up to
128 terabytes.​


Sagot :

Answer:

To include a single quote in the string text, you will have to use two single quotes. For example, 'You think it' 's your choice'. For declaring a string variable, we have to specify the datatype and length value which defines the maximum length of the string.