Answer Posted / bhanu

select to_char(sysdate,'DD/MON/YYYY') from dual;

What is the sql query to concatenate column values from multiple rows in oracle?

553

---

What is the usage of control file in oracle?

599

---

Give the constructs of a package, function or a procedure.

530

---

How to use null as conditions in oracle?

572

---

Explain the use of consistent option in exp command.

545

---

---

What do you mean by cdb and pdb in oracle 12c?

633

---

How to define a data source name (dsn) in odbc manager?

521

---

What is Virtual Private Database in Oracle?

608

---

What is an Oracle index?

1170

---

How can we force the database to use the user specified rollback segment?

553

---

How to start instance with a minimal initialization parameter file?

525

---

What are the tools for Oracle ?

597

---

How to select some rows from a table in oracle?

588

---

Does oracle partitioning improve performance?

542

---

What is oracle join syntax?

561

---