Answer / highness

mainly two types
1. scalar 2. composite

1.
boolean
char
binary integer
number
variable
constant
raw
rowid


2.
records
tables
varrays

Answer / menan

boolean
varchar2
bind variable
timestamp

What is recursive stored procedure?

0 Answers  

---

What are the two types of exceptions in pl/sql?

0 Answers  

---

Types of backups ?

3 Answers   TCS,

---

i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5

1 Answers  

---

write a query to find out the no. of employees whose age is less than 25 and max of salary for the employees belonging to a particular department is less than 20000

6 Answers  

---

How long will it take to learn pl sql?

0 Answers  

---

How sql query is executed?

0 Answers  

---

What are all different types of collation sensitivity?

0 Answers  

---

What is cost in sql execution plan?

0 Answers  

---

what is difference between procedure and function, procedure and trigger?

8 Answers   iFlex,

---

how do you restrict number of rows for a particular value in a column.For example:there is a table called fruits,having apples,bananas ,papayas.I dont want to have more than 100 apples in that table ,so how can u restrict number of rows for apple to hundred?

6 Answers  

---

what is a materialized view? : Sql dba

0 Answers  

---