What is the system function to get the current user's user
id?
Answer Posted / dhivya
select * from v$session;
from this we can get the user's id.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?
You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?
What is database design and development?
explain detail about ftp in datastage?
Explain about the database management systems.
Explain about a primary key?
Why does this query return 0?
Hi my program is accesing data from two db2 databases.what is the bind card for this program to genarate plan? how to specify the two owners and two qualifiers in bind card
How to replace not in with not exist?
Write short notes on manual refreshes.
Explain about relational database management systems?
How to read and create .LDC data files which are used by linguatic dictionary.
Explain about xml databases?
How can you fix a poorly performing query?
Explain the cube operator?