select 1,col1,col2 from table1. output?

5 Answers   Ramco,

---

how to calculate expressions with sql statements? : Sql dba

0 Answers  

---

Regarding joins what are the differences you observed in oracle 9i and sql server?

3 Answers   Choice Solutions,

---

Can a view be mutating? If yes, then how?

0 Answers  

---

What are the indexing methods?

0 Answers  

---

---

What is the sql query to display the current date?

0 Answers  

---

How to assign sql query results to pl sql variables?

0 Answers  

---

Which clause of an UPDATE statement allows you to affect only certain rows of a table? 1. The WHERE clause 2. The SET clause 3. The ROWS AFFECTED clause 4. The ORDER BY clause

6 Answers   HCL,

---

Can we use two order by clause in query?

0 Answers  

---

What are dml commands?

0 Answers  

---

Practice 1: Changes to data will only be allowed on tables during normal office hours of 8.45 in the morning until 5.30 in the afternoon, MONDAY through FRIDAY. A. Create a procedure called SECURE_DML that prevents the DML statement from executing outside of normal office hours, returning the message: “you may only make changes during normal office hours” b. Create a statement trigger on the PRODUCT table which calls the above procedure. c. Test it by inserting a new record in the PRODUCT table.

1 Answers   Tech Mahindra,

---

Can we enter data in a table in design view?

0 Answers  

---