Give the structure of the procedure ?

1 Answers  

---

can we update a view which is created from two tables

11 Answers  

---

what is clause? : Sql dba

0 Answers  

---

Can you skip header records while loading? : aql loader

0 Answers  

---

What is scalar and vector?

0 Answers  

---

---

How can we optimize a sql query?

0 Answers  

---

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  

---

I have one table,in that table (1)i have java1.1 version books are 2 and java1.5 version books are 4. (2).Net2.0 books are 3, .Net3.5 books are 2 (3)ABC1.6 books are 4, ABC2.0 books are 3. Now i want output is like Book Count Java 6 .Net 5 ABC 7 For this i need sql query, please help me if anyone how to get this result. Thanks, Seenu

4 Answers   Adea,

---

What are the two types of cursors in pl sql?

0 Answers  

---

what are the system privileges that are required by a schema owner (user) to create a trigger on a table?

0 Answers  

---

Why you are not able to create a table using select command,if it is having a LONG column? for eg:create table test as select * from test1 here test1 containg a column having LONG datatype...

1 Answers  

---

If i insert record in table A and these record should update in table B by using Trigger.How to achieve this.

4 Answers   Saama Tech, TCS,

---