Answer / 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.

Where is pl sql used?

1 Answers  

---

How to update salary of employees department wise?

6 Answers  

---

I have a package in which a table was used in a procedure and compiled later i have dropped the table used in the package what would be the status of package specification and body

1 Answers   TCS,

---

How many sectors are in a partition?

1 Answers  

---

how to delete duplicate rows from a specified table(only single table) how do you know which join is need to be used

11 Answers   UST,

---

What is a self join ?

6 Answers   BirlaSoft,

---

What is difference between function and trigger?

1 Answers  

---

Is like operator in sql case sensitive?

1 Answers  

---

ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

1 Answers   Wipro,

---

What are sql ddl commands?

1 Answers  

---

Can we create a trigger on view?

1 Answers  

---

How does index help in query performance?

1 Answers  

---