Can we insert data into materialized view?

0 Answers  

---

What are different types of indexes?

0 Answers  

---

How can we make an if statement within a select statement?

0 Answers  

---

How are multiple column = value pairs delimited in the SET clause of an UPDATE statement? 1. With commas (SET price = 0, status = 'I') 2. With parentheses (SET (price = 0) (status = 'I')) 3. With double-pipes (SET price = 0 || status = 'I') 4. With square-brackets (SET [price = 0] [status = 'I'] 5. With single or multiple spaces (SET price = 0 status = 'I')

2 Answers  

---

How do you add a column to a table?

0 Answers  

---

How can I delete duplicate rows?

0 Answers  

---

In a table i have columns A,B,C and i have a composite index on columns A,B if so will the following query uses index or not? SELECT sal,name FROM <table_name> WHERE A=<value> AND B=<value> AND C=<value>;

2 Answers   Mastek,

---

what is single byte over head in oracle..?

0 Answers  

---

Explain UNION,MINUS,UNION ALL, INTERSECT?

1 Answers  

---

what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba

0 Answers  

---

Where are my tempfiles, I don't see them in v$datafile or dba_data_file?

0 Answers  

---

Which is faster joins or subqueries?

0 Answers  

---