What is indexing in sql and its types?

0 Answers  

---

What is the sql case statement?

0 Answers  

---

how to Update table Sales_summary with max(sales) data from table sales_dataTable 1. sales_data table Table 2. Sales_summary Region sales Region sales N 500 N 0 N 800 W 0 N 600 W 899 W 458 W 900 I want the Sales_summary After Update like this Region Sales N 800 W 900

8 Answers  

---

What is the plv (pl/vision) package offers?

0 Answers  

---

Does view contain data?

0 Answers  

---

how to fetch alternate records from a table? : Sql dba

0 Answers  

---

Can we insert in sql function?

0 Answers  

---

Which is faster truncate or drop?

0 Answers  

---

How do I truncate a word?

0 Answers  

---

25.67,-1 Trunc = 20 Round= 30 HOW????

2 Answers   Karrox,

---

Create table emp (id number(9), name varchar2(20),salary number(9,2)); The table has 100 records after table created.Now i nee to change id's Datatype is to be Varchar2(15). now Alter table emp modify(id varchar2(15),name varchar2(20), salary number(9,2)); Whether it will work or returns error? post answer with explanation.

13 Answers   Oracle, TCS,

---

hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

0 Answers  

---