Answer / satya

simply greatest,least are rowlevel functions
max,min are the column level functions

Answer / shivaindu

greatest/Least: we can pass any no. of exp
Max/Min: we can pass one exp that may a column

Case: is a statement function, cannot process null
Decode: is a function, can process null, we can use in
update statement.

Answer / jyothi

greatest gives largest value from the list of values passed
where as max gives maximum value in that column.similarly
least and min too.
decode performs only equality conditions and it doesn't work
in plsql.process null.
case compares all the cases.null cannot processed. case
performs all the actions of decode and it works in pl/sql.

Answer / prakasha

n0

How to add a column ‘salary’ to a table employee_details?

0 Answers  

---

what is the difference between trigger and constraint?

3 Answers   HSBC,

---

How many unique keys can a table have?

0 Answers  

---

The in operator may be used if you know the exact value you want to return for at least one of the columns.

0 Answers  

---

Is oracel sql developer written in java?

0 Answers  

---

What are the attributes of SQL*PLUS ?

2 Answers   Dream Careers, Oracle,

---

Is it possible to read/write files to-and-from PL/SQL?

0 Answers  

---

Which table is left in left join?

0 Answers  

---

SELECT flavor, SUM (ice_cream_sales) FROM sales_detail GROUP BY flavor ORDER BY 2 DESC If the "sales_detail" table contains ten records with different values in the flavor column (two "vanilla," three "chocolate," four "strawberry," and one NULL), how many rows are returned by the sample code above? 1. 0 rows 2. 1 row 3. 3 rows 4. 4 rows 5. 10 rows

8 Answers   Sonata,

---

When do we create bitmap indexes

2 Answers   CTS,

---

What is time based sql injection?

0 Answers  

---

Is postgresql a server?

0 Answers  

---