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 edit a trigger in sql developer?

943

---

Define commit?

950

---

What is pl sql in oracle?

1000

---

Is big data nosql?

894

---

How consistent is the view of the data between and within multiple sessions, transactions or statements ?

2177

---

How do I turn a list into a table?

916

---

How long will it take to learn pl sql?

897

---

What is a scalar value in sql?

1019

---

column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

7159

---

How to move files from one directory to another in pl sql?

1139

---

what is log shipping? : Sql dba

1066

---

Can we rollback delete command?

947

---

what are the system privileges that are required by a schema owner (user) to create a trigger on a table?

1014

---

What are the benefits of stored procedures?

1010

---

What are the events on which a database trigger can be based?

1111

---