What data types does pl/SQL have?
Answers were Sorted based on User's Feedback
Answer / nashiinformaticssolutions
PL/SQL supports various data types, including:
• Scalar data types like VARCHAR2, NUMBER, DATE, and BOOLEAN.
• Composite data types like RECORD and TABLE.
• Reference data types like REF CURSOR and PL/SQL TABLE.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / glibwaresoftsolutions
PL/SQL supports various data types, including:
• Scalar data types like VARCHAR2, NUMBER, DATE, and BOOLEAN.
• Composite data types like RECORD and TABLE.
• Reference data types like REF CURSOR and PL/SQL TABLE.
| Is This Answer Correct ? | 0 Yes | 0 No |
PL/SQL supports various data types, including:
• Scalar data types like VARCHAR2, NUMBER, DATE, and BOOLEAN.
• Composite data types like RECORD and TABLE.
• Reference data types like REF CURSOR and PL/SQL TABLE.
| Is This Answer Correct ? | 0 Yes | 0 No |
How to find 3rd highest salary of an employee from the employee table in sql?
What is a unique key and primary key and foreign key?
what is the output of this query selet * from employee where 1=2 ??
What are types of indexes in sql?
Can a table contain multiple primary key’s?
how to escape special characters in sql statements? : Sql dba
Is it possible to create the following trigger: before or after update trigger for each row?
What type of database is sql?
What is compilation error in pl sql?
Does a join table need a primary key?
Show how functions and procedures are called in a pl/sql block.
Which one is the Best approach to put code, among Triggers and Procedures? Explain?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)