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;

src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

0 Answers   IBM,

---

can we pass two out parameters at a time in function?please answer to my question

3 Answers   Wipro,

---

can anyone help me ? an index has been done on the primary key of a table. an update operation was performed on that table. now my question is 1> what abt the performance ? means faster or slower due to indexing ? 2> does the operation affect to the primary key constraint ?

2 Answers   Allfon,

---

how to get the no employee in each department including the dept which has 0 employee

5 Answers  

---

Create table Employee ( Employee_Id varchar2(8) Constraint emp_id_pk primary key, FirstName varchar2(50), LastName varchar2(50), DeptID Number(5) Constraint dept_id_fk Foreign Key(DeptId) References Department(DeptId) ) Error I am getting: Constraint specification are not allowed here

2 Answers  

---

What is translate in oracle?

0 Answers  

---

Explain the difference between a procedure and a function? What do you understand by those terms?

0 Answers  

---

Explain do view contain data?

0 Answers  

---

How would you best determine why your MVIEW couldnt FAST REFRESH?

0 Answers  

---

Define 'view' advantage ?

2 Answers   AZTEC, TCS,

---

9)When information has to be stored w.r.t employees and their respective departments, which of the following is the Correct formulation of entries? A)Employee and department would together be represented as an entity. B)This is too less information to decide on entities. C)An employee would be one entity and a department would be another. D)Such a scenario cannot be modelled in RDBMS

2 Answers   Mind Tree,

---

What is an Index ?

2 Answers  

---