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 |
What are the operators used in select statements?
How do I find duplicates in the same column?
What is data types in sql?
How to place comments in pl/sql?
How to fetch common records from two tables?
Is left join inner or outer?
There is a sequence with min value 100. I want to alter this sequence to min value as 101. If the table has already data in the sequence column as 100,101,102... Is it possible to do so ?
Can there be more than one function with a similar name in a pl/sql block?
What is normalization ?
9 Answers BirlaSoft, CTS, HCL,
----> There is a table T with two columns C1 and C2. The data is as below: C1 C2 1 4 2 5 3 6
Does sql view stored data?
how do you control the max size of a heap table? : Sql dba
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)