Psudo colums
Answer / mathan r
It is a column that is not an actual column in the table.
eg USER, UID, SYSDATE, ROWNUM, ROWID, NULL, AND LEVEL.
rowid
versions_xid
versions_operation
versions_startscn
versions_endscn
sysdate
systimestamp
rownum
ora_rowscn
object_value
level
user
| Is This Answer Correct ? | 0 Yes | 1 No |
What are secondary xml indexes?
What is transaction ? Give me one example.
How to use values from other tables in update statements in ms sql server?
What is a transaction and what are ACID properties?
14 Answers Config Systems, IBM, TCS, Virtusa,
How would you add a section to a table?
there is a table having two columns no and name and the data is 1 A 2 B 3 C write a query that will result a horizontal output A,B,C
What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?
Can you pass expressions to stored procedure parameters?
What is the difference between a local and a global variable?
How to recreate an existing index in ms sql server?
How many null values we can have in a unique key field in sql server?
when inserting to a table how many rows will be effected using triggers
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)