Answer Posted / nagarjuna reddy

A pseudo column is a column but it is not physically existed
in the table.if we want to use these column by specifying
externally in select statement for projection or selection.
but we can't insert,delete and update pseudo columns.
some of pseudo columns are
1 ROWID
2 ROWNUM
3 LEVEL
4 CURRVAL
5 MEXTVAL
etc...

Explain what is sql*plus?

1150

---

Compare sql & pl/sql

1144

---

How to call a javascript function from pl sql?

1145

---

What is a join?

1075

---

what is transaction? : Sql dba

1011

---

how to enter binary numbers in sql statements? : Sql dba

981

---

What are some predefined exceptions in pl/sql?

1173

---

What is a database trigger?

1073

---

What is pls_integer in pl sql?

1108

---

Why use truncate instead of delete?

1020

---

How can you load microsoft excel data into oracle? : aql loader

1179

---

What is the difference between nvl function, ifnull function, and isnull function?

1117

---

What is error ora-01000: maximum open cursors exceeded

1151

---

how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba

1197

---

How to use sql*plus built-in timers?

1209

---