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 load data with sql*loader?
What are all different types of collation sensitivity?
What will you get by the cursor attribute sql%rowcount?
What is the maximum rows in csv?
What is Data Concarency and Consistency?
if we give update table_name set column_name= default. what will happen?
define join and explain different type of joins? : Sql dba
I have the table like this S.No Name ID 01 Xyz 123 I want the result as 01Xyz123 How to write the query to retrieve the entire row data in a single column?
what is blob? : Sql dba
what is a stored procedure? : Sql dba
what are the demerits of sql?
How many joins can you have in sql?
Oracle (3253)
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)