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

How do I run a sql script?

798

---

What is $$ in sql?

784

---

How to process query result in pl/sql?

840

---

Does user triggers have entry for trigger with compilation errors?

845

---

What is a unique key and primary key and foreign key?

782

---

what is union, minus and interact commands? : Sql dba

927

---

Why do we use procedures in pl sql?

791

---

Define concurrency control. : Transact sql

867

---

Can you call pl/sql package functions from within a fast formula?

825

---

What is record data type?

721

---

Can we group by two columns in sql?

779

---

What is attribute indicator in pl sql?

775

---

What is the difference between inner join and left join?

792

---

Is sql similar to python?

767

---

how to escape special characters in sql statements? : Sql dba

778

---