What data types does pl/SQL have?

Question Posted / nashiinformaticssolutions

3 Answers
1274 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What data types does pl/SQL have?..

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 data types does pl/SQL have?..

Answer / glibwaresoftsolutions

Is This Answer Correct ?

0 Yes

0 No

What data types does pl/SQL have?..

Answer / hr@tgksolutions.com

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More SQL PLSQL Interview Questions

Does truncate table reset auto increment?

0 Answers

Explain what is table in a database?

0 Answers

What is natural join in sql?

0 Answers

Practice 1: Changes to data will only be allowed on tables during normal office hours of 8.45 in the morning until 5.30 in the afternoon, MONDAY through FRIDAY. A. Create a procedure called SECURE_DML that prevents the DML statement from executing outside of normal office hours, returning the message: “you may only make changes during normal office hours” b. Create a statement trigger on the PRODUCT table which calls the above procedure. c. Test it by inserting a new record in the PRODUCT table.

1 Answers Tech Mahindra,

Define commit, rollback and savepoint?

0 Answers

What is trigger in sql?

0 Answers

what is ref cursor in pl/sql?

3 Answers

What is the difference between microsoft access and sql server?

0 Answers

How much does sql cost?

0 Answers

What is the most restrictive isolation level? : Transact sql

0 Answers

How can analyze query after generating explain plan ?

2 Answers Thermotech,

If there are 1 to 100 numbers in a table and in that 100 numbers some 10 numbers are deleted.I want to find out the missing numbers between 1 to 100 by pl/sql how?

9 Answers JPMorgan Chase,

For more SQL PLSQL Interview Questions Click Here