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
- 3595 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 |
i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)
Explain the different normalization forms?
difference between procedures and function?
How to create a table interactively?
What are the differences between primary key and unique key?
Can you drop an index associated with a unique or primary key constraint?
What is a tns service name?
how to get last monday of a month?
How many data types are supported?
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
What is connection pooling in oracle?
Is it possible to join two tables, that are in two different users (e.g. SCOTT and HR etc.),but im same database (e.g. ORCL)? If yes, then how it is possible? Explain with step by step procedure.
Oracle General 
