What is the system function to get the current user's user
id?
Answers were Sorted based on User's Feedback
Answer / dhivya
select * from v$session;
from this we can get the user's id.
| Is This Answer Correct ? | 1 Yes | 1 No |
Can you have a nested transaction?
Explain about a primary key?
What are defaults? Is there a column to which a default can't be bound?
How to generate OIDS
What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?
What is database design and development?
agregator gives one to many records or many to one record
Can an extended stored procedure be called from inside a user-defined function?
How is data stored in dbms?
How would you design a database for an online site, which would average a million hits a day?
What are the three basic rules which are to be followed for the relational model of the database?
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)