What is the system function to get the current user's user
id?
Answers were Sorted based on User's Feedback
Answer / dhivya
select * from v$session;
from this we can get the user's id.
| Is This Answer Correct ? | 1 Yes | 1 No |
Explain the family trees and connection by clause.
Explain about the relational database?
In which database can extended stored procedures be added?
Explain about the hierarchical model of the database?
How would you design a database for an online site, which would average a million hits a day?
Explain the general syntax for a SELECT statements covering all the options.
Can an extended stored procedure be called from inside a user-defined function?
Explain about query and reporting.
What is the physical representation for a many-to-many relationship?
What is an application role and explain a scenario when you would use one?
How can you fix a poorly performing query?
how to find the first two highest salaries in deptno in emp table
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)