What is the system function to get the current user's user
id?

Answers were Sorted based on User's Feedback



What is the system function to get the current user's user id?..

Answer / dhivya

select * from v$session;

from this we can get the user's id.

Is This Answer Correct ?    1 Yes 1 No

What is the system function to get the current user's user id?..

Answer / lakshmi narayanan r

SELECT CURRENT_USER

Is This Answer Correct ?    1 Yes 1 No

What is the system function to get the current user's user id?..

Answer / ajitnayak

select USERNAME,user_id from user_USERS;

Is This Answer Correct ?    0 Yes 0 No

What is the system function to get the current user's user id?..

Answer / dinesh sharma


select User_Id()

Is This Answer Correct ?    2 Yes 4 No

Post New Answer

More DB Development Interview Questions

When installing the datastage7.5x2 edtion iam getting aproblem i.e the cpu count is 2 but the cpu count in installation is one . how can i install in my p.c (system is dual core).

0 Answers  


Who are end users in dbms?

0 Answers  


What is denormalization and when would you go for it?

9 Answers   NBP,


What are cursors? Explain different types of cursors?

6 Answers  


What are defaults? Is there a column to which a default can't be bound?

2 Answers  






Explain about relational operator join?

0 Answers  


can you give me the syntax of named procedure??

2 Answers  


What are the key features of dbms?

0 Answers  


What is an application role and explain a scenario when you would use one?

0 Answers  


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?

0 Answers  


Explain about the database management systems.

0 Answers  


What are the three basic rules which are to be followed for the relational model of the database?

0 Answers  


Categories