Sign Up Login


  1. Categories >> Software >> Databases >> DB Development
  2. Suggest New Category

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

Question Posted / guest

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

What is the physical representation for a many-to-many relationship?

0 Answers  

What is dbms and its application?

0 Answers  

Write the difference between case version and decode version.

2 Answers  

Who are naive users?

0 Answers  

How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables?

1 Answers   Flextronics, Hexaware, SQL Star,

What is normalization? Explain different levels of normalization?

8 Answers   CG-VAK, Choice Solutions, College School Exams Tests, IBM, Wipro,

Explain about the relational database?

0 Answers  

Write the fastest query to find out how many rows exist in a table?

0 Answers  

What is a self join? Explain it with an example?

16 Answers   TCS,

Explain what a database is?

0 Answers  

What is the database development process?

0 Answers  

Does QTP Support the Propjects which are running in Dot Net? As we are starting with new project in Dot net need to use automation tool?Please advice & let me know what would be the best.

0 Answers  

For more DB Development Interview Questions Click Here
Categories