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

Can you have a nested transaction?

1 Answers  

What is denormalization and when would you go for it?

9 Answers   NBP,

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

1 Answers   Flextronics, Hexaware, SQL Star,

how to find the first two highest salaries in deptno in emp table

2 Answers  

Who are naive users?

0 Answers  




what is the use of foreginkey

2 Answers  

agregator gives one to many records or many to one record

1 Answers   IBM,

Explain about normal forms?

0 Answers  

How to generate OIDS

0 Answers  

How to create an external table.

1 Answers  

What are the main phases of database development?

0 Answers  

Define candidate key, alternate key, composite key?

30 Answers   IAS, IBM,

For more DB Development Interview Questions Click Here
Categories