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...

What is using in sql?

1016

---

What are the advantages of normalization?

1038

---

how can we optimize or increase the speed of a mysql select query? : Sql dba

884

---

What is %rowtype in pl sql?

923

---

What is the use of prepared statement?

952

---

What can sql server reporting services do?

1055

---

What's the difference between inner join and left join?

947

---

What is a function in oracle pl sql?

976

---

how to check myisam tables for errors? : Sql dba

1257

---

What is partition by in sql?

1000

---

What are all the common sql functions?

969

---

What is the difference between a query and a report?

901

---

What is %type in pl sql?

924

---

What is Materialized View? In What Scenario we Use Materialized View?

9397

---

Explain the structure of pl/sql in brief.

1042

---