Answer / d ashwin

SELECT XMLELEMENT
("Emp", XMLELEMENT("name", e.fname ||' '|| e.lname),
XMLELEMENT ( "hiredate", e.hire))
AS "RESULT"
FROM employees e
WHERE employee_id > 200 ;


This query produces the following typical XML result:

RESULT
-----------------
<Emp>
<name>John Smith</name>
<hiredate>2000-05-24</hiredate>
</Emp>
<Emp>
<name>Mary Martin</name>
<hiredate>1996-02-01</hiredate>
</Emp>

Answer / ksonga

SET VERIFY OFF
SET ECHO OFF
SET PAGES 0
SET LONG 100000
SET lONGCHUNKSIZE 10000
SET LINESIZE 200
select dbms_xmlgen.getxml('select * from emp') from dual

Answer / dfd

select * from emp hahahaha

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

1 Answers  

---

What WHERE CURRENT OF clause does in a cursor?

2 Answers  

---

How to use select statement to count the number of rows in oracle?

1 Answers  

---

What is the difference between view and materialized view in Oracle?

1 Answers   MCN Solutions,

---

What is execute immediate in oracle?

1 Answers  

---

How can one skip any number of rows while loading the DB tables with SQL Loader? Similarly how can one skip any column?

1 Answers   IBM,

---

what is difference between DBMS and RDBMS?

2 Answers   Metric Stream,

---

Is oracle a relational database?

1 Answers  

---

What does ROLLBACK do ?

1 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  

---

What are the uses of Rollback Segment ?

2 Answers  

---

How to create an initialization parameter file?

1 Answers  

---