Interested to Buy Any Domain ? << Click Here >> for more details...
What SQL query from v$session can you run to show how many
sessions are logged in as a particular user account?
- 1 Answers
- 3576 Views
- I also Faced
- E-Mail Answers
Answer / saraswathi muthuraman
SQL> select count(SID),USERNAME from v$session group by
USERNAME;
14
14 raghavan
2 P_21533
1 Saras
4 rows selected.
SQL>
| Is This Answer Correct ? | 2 Yes | 2 No |
how to see the data (in unix) using dataset in datastage?
What is procedure overloading in oracle?
How to establish administrator authentication to the server?
What do you mean by merge in oracle and how can you merge two tables?
How to check the server version in oracle?
Please help me how to write a Query to change the primary key constraint from 1 attribute to another attribute in a table
What is the meaning of recursive hints in oracle?
What are virtual columns?
How can you use check constraints for self referential integrity?
What is cursor
How can we manage the gap in a primary key column created by a sequence? Ex:a company has empno as primary key generated by a sequence and some employees leaves in between.What is the best way to manage this gap?
How to export data to a csv file?
Oracle General 
