Answer / Prashant Kumar Singh

To order siblings in Oracle hierarchy queries, you should use the ORDER BY clause. For example, consider the following query: SELECT * FROM department_hierarchy ORDER SIBLINGS BY department_name; This will sort the departments by their names.

wht is the difference between sqlaserver2000 and 2005

1 Answers   ABC, IBM,

---

What is indexing oracle sql?

1 Answers  

---

what is SCALAR Queries?

2 Answers   ITC Infotech,

---

What is a rank in sql?

1 Answers  

---

Do prepared statements prevent sql injection?

1 Answers  

---

display null value rows with out using null function?

8 Answers   Infosys,

---

Name the different types of indexes in sql and define them.

1 Answers  

---

Is natural join same as inner join?

1 Answers  

---

How we get all_group_function's(Sum,avg,count,max and min_value of a column(Sal) Using pl/sql anonymous block, with out using group function's. You shouldn't use more than one select statement in entire the program. Like cursor c is select * from <table_name>; except this you can't use another select statement. You can use no of variables as per requirement.

1 Answers  

---

I have one Excel file with 1,50,000 Records. Now I need to load that whole file into Oracle Database with same columns in Excel sheet . I need PLSQL Procedure or used by SQL PLUS

7 Answers   Polaris,

---

What are the properties of a transaction?

1 Answers  

---

How do you create a unique index?

1 Answers  

---