Answer Posted / thanigesan.m

view is a virtual table that doesn't exist in rdbms,it is
associated with the SELECT statement materialized is also same
like the view but it exist in rdbms.
we use materialized view
e.g if we r having a table with 4 columns
empno ename sal comm
33 xxxy 1000 234
we can create a materialized view as totalsal by sum that 2
columns....

What is sql*loader?

1285

---

define join and explain different type of joins? : Sql dba

1002

---

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

3623

---

What is microsoft t sql?

985

---

Is sql considered coding?

1088

---

Explian rowid, rownum? What are the psoducolumns we have?

1045

---

Is sql a microsoft product?

997

---

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2068

---

Why stored procedure is faster than query?

1157

---

Is sql similar to python?

1042

---

What is the benefit of foreign key?

1069

---

Can we use ddl statements in stored procedure?

1192

---

What is varchar sql?

1207

---

What is hibernate and its relation to sql?

1171

---

i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

1631

---