Answer Posted / nazeer
pseudo column act as database table column, but not actually the exact column in the table....we can fetch values from the pseudo column....
The Columns are..
user,
userid,
rownum,
rowid,
level,
nextval,
curval,
sysdate.......
| Is This Answer Correct ? | 14 Yes | 2 No |
Post New Answer View All Answers
How do I run a program in pl sql?
what is try_catch block in procedure
Which one is better sql or oracle?
Which certification is best for sql?
How consistent is the view of the data between and within multiple sessions, transactions or statements ?
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...
How do I view stored procedures?
Define sql delete statement.
what is sp_pkeys? : Transact sql
Can we use commit inside a trigger?
What is the limitation on the block size of pl/sql?
How do you update sql?
Do prepared statements prevent sql injection?
What is pl/sql language case sensitive?
Which command is used to call a stored procedure?
