PL/SQL supports 13 built-in scalar data types: NUMBER, CHAR, VARCHAR2, DATE

How many scalar data types are supported in pl/sql?

Question Posted / Puneet Kumar Srivastava

1 Answers
1128 Views
I also Faced
E-Mail Answers

Answer Posted / Puneet Kumar Srivastava

PL/SQL supports 13 built-in scalar data types: NUMBER, CHAR, VARCHAR2, DATE, RAW, BOOLEAN, LONG, LONG RAW, BINARY_FLOAT, BINARY_DOUBLE, INTERVAL YEAR TO MONTH, INTERVAL DAY TO SECOND, and TIMESTAMP.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Can we use distinct and group by together?

1131

what is sql server agent? : Sql dba

1179

Can delete statement be rollbacked?

1050

Does group by remove duplicates?

1112

Can we rollback truncate?

1072

what is schema? : Sql dba

1137

what is dbms? : Sql dba

1061

If a cursor is open, how can we find in a pl/sql block?

1235

Is inner join faster than left join?

1273

how many tables will create when we create table, what are they? : Sql dba

1140

what are all the common sql function? : Sql dba

1127

What is the current version of sql?

1091

what is bcp? When does it used? : Sql dba

1053

What is the current version of postgresql?

1170

how to escape special characters in sql statements? : Sql dba

1110