Answer Posted / ramesh

Column Names of a table are stored in the data dictionary
table user_tab_columns along with column_id. By referring
column_id we can display the column name as :

select column_name from user_tab_columns where table_name
= 'EMP' and column_id = 3;

Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?

1013

---

Where are my tempfiles, I don't see them in v$datafile or dba_data_file?

997

---

Is record in pl sql?

966

---

State few characteristics of pl/sql?

971

---

Is it possible to read/write files to-and-from PL/SQL?

1100

---

What are its different types of dbms?

999

---

What is a stored procedure in sql with example?

1125

---

What is the use of count (*) in sql?

1051

---

what is a unique key ? : Sql dba

1089

---

Do we need to rebuild index after truncate?

1031

---

how to use myisamchk to check or repair myisam tables? : Sql dba

968

---

name 3 ways to get an accurate count of the number of records in a table? : Sql dba

1063

---

Is null operator in sql?

1029

---

What does partition by mean in sql?

959

---

Can you have more than one key in a database?

932

---