1.how to extract the second highest salary from emp table having sal as a column which contains the salary of all employee of an organisation.
6 6977What is the meaning of "Modulus" and "Alignment" in a datafile. Data file might be from any database. Data file is created through unloading data from a table. So, while loading this data into my table, I need to use these keywords. Could any one can help me regarding this?
1605what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?
HP,
1820While connecting to Oracle Db i am getting the following error message- ORA-12154: TNS:could not resolve the connect identifier specified what are the steps to solve this problem?
IBM,
4 5690We have one Package(which has many function/procedures, SQL quires etc). Now we need to check, which query or procedure is taking lot of time in that Package. ? How do we do it.
IBM,
2 6117
what are actual and formal parameters?
How to check database size in Oracle?
How to insert a new row into a table in oracle?
What is SQL access advisor in Oracle?
Can we use oracle pl/sql block in core java? if so how? pls get back to me .....
How to display row numbers with the records?
What is the meaning of database backup?
What is tkprof and how can we use it?
Explain a synonym?
What are different types of receipt reversals ? Explain them : oracle accounts receivable
Why we use oracle d2k?
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
How to set up autotrace for a user account?
Which is better Oracle or MS SQL? Why?
Explain self joins in oracle?