Answer Posted / guest

1.Simple/Inner/Natural Join
2.Equi(contains only = sign) /Non-Equi Joins(other simbles)
3.Outer Joins(Left Outer Join/Right Outer Join)
4.Cross Join
5.Self Join

What is the most important ddl statements in sql are?

981

---

What found sql?

932

---

What is a string data type in sql?

1023

---

What is trigger in pl sql with examples?

1016

---

Explain what is a subquery ?

1167

---

What is the file extension for sql database?

982

---

Differentiate between syntax and runtime errors.

1167

---

What is %rowtype in pl sql?

975

---

What is clause in sql?

1093

---

what is an extent ? : Sql dba

1073

---

State few characteristics of pl/sql?

964

---

What is difference between stored procedure and trigger?

1135

---

what is a database? : Sql dba

1143

---

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

1569

---

What is scalar and vector?

987

---