Answer / prasanna

we can call user defined functions in select statements

Answer / tripti gour

yes, we can call user defined function in SELECT statement.

ex:
select function_name from dual;

What is a snapshot in oracle database?

0 Answers  

---

What is SYSTEM tablespace and When is it Created?

2 Answers  

---

How to convert the date format from dd/mm/yyyy to mm/dd/yyyy. (for eg). 22/05/2008 to 05/22/2008. when u use to_char(), it tells the month is invalid. how to resolve this problem.tel with eg.

2 Answers   AppLabs,

---

Without giving condition how to retrieve the unmatched records from table.

1 Answers   TCS,

---

Can objects of the same schema reside in different tablespace?

0 Answers  

---

---

How to compare dates in oracle sql?

0 Answers  

---

Given two table employee and department EMP ---------------- empid deptid(fk) Dept --------------------- deptid(pk) deptname que-Write a query to find count of employee in each department. Expected Output- deptid countofEmployee --------------------------- 10 57 20 20 30 15

2 Answers  

---

Which Oracle App Is Most Popular One ?

3 Answers  

---

How to call a trigger inside a stored procedure?Give an example.

2 Answers  

---

How to handle a single quote in oracle sql?

0 Answers  

---

What are the limitations oracle database 10g xe?

0 Answers  

---

Is the After report trigger fired if the report execution fails ?

0 Answers   Oracle,

---