Answer / Prem Pal

ROWID is a system-generated unique identifier for each row in a table. It's physically stored with the data itself and can be used to directly access a row without using a primary key. ROWNUM is a pseudocolumn that returns the sequential number of a row within the result set of a SQL query. It starts from 1 by default, but it can be reset if ORDER BY clause is used.

How to change the order of columns in Oracle SQL Plus ?

1 Answers   MCN Solutions,

---

How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?

1 Answers  

---

Why indexing is needed?

1 Answers  

---

I Have A Table Like This. Cityno Cityname Mails 1 Bangalore 8km 2 Hsr Layout 20km 3 Mejistic 30km 4 Jayadeva 55km 5 Itpl 80km 6 Hebbal 115km I Have Data Like This I Want O/p Like This Distance No.ofcity 0-50km 3 51-100km 2 101-150km 4 And So On

6 Answers   DELL, HCL, Oracle,

---

How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?

1 Answers  

---

How to order siblings in oracle hierarchy queries?

1 Answers  

---

Is t sql a programming language?

1 Answers  

---

How to fetch alternate records from a table?

1 Answers  

---

Why is sharding used?

1 Answers  

---

Write a unique difference between a function and a stored procedure.

1 Answers  

---

is it mandatory to select all the column in a view then what columns should be selected

2 Answers  

---

hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

1 Answers  

---