Write a query to display the current date in sql?

0 Answers  

---

How does postgresql compare to oracle/db2/ms sql server/informix?

0 Answers  

---

Can we edit a view in sql?

0 Answers  

---

First round ------------------- - Procedure - Packages - Views - Virtual tables - Can we use dcl with in function? - Joins and few scenarios - Triggers and its type - Pragma, type and its functionality - How to create db link in oracle - Materialized view - How to find duplicate values from table? - Cursor and its functionality - Write a script to display friday and its date from a entire year. - Exception Handling Second round ------------------------ Gave a scenario like. Need to write a function to perform. When user try to change a password. It must not be last five password and a given password can be combination of characters, symbols, upper and lower case.

0 Answers   Prodapt,

---

How can multiply values of a column? OR How can multiply value of a row of a column using a single query in SQL?

1 Answers   Pitney Bowes,

---

What does count (*) do in sql?

0 Answers  

---

Which is better stored procedure or query?

0 Answers  

---

i want to display 1 to 10 numbers using one select statement.

18 Answers   HCL, Nyros, Oracle,

---

What are the packages in pl sql?

0 Answers  

---

What is auto increment feature in sql?

0 Answers  

---

Can we join same table in sql?

0 Answers  

---

can we use out parameter in a function?Give an example.

4 Answers   Logica CMG, TCS,

---