Oracle General (1809)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)
Oracle Security (38)
Oracle Forms Reports (510)
Oracle Data Integrator (ODI) (120)
Oracle ETL (15)
Oracle RAC (93)
Oracle D2K (72)
Oracle AllOther (241) 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 8459What 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?
2170what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?
HP,
2213While 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 7137We 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 7131
What is the data type of dual table?
What view would you use to determine free space in a tablespace?
What is Java Pool in Oracle?
Techniques of error handling - ignore, rejecting bad records to a flat file, loading the records and reviewing them (default values)?
Explain how are indexes update?
How to see the table columns used in an index?
Explain oracle’s server parameter file.
How to calculate date and time differences in oracle?
Can you tell me how to add new column in existing views?how?How is possible?
What degree do database administrators need?
Which directory will you copy your new custom form, what would be its extension (.fmb or .fmx)?
How can you tell if an index on particular table is used or not used in 9i?
How to execute the package in oracle?
How to define an anonymous procedure without variables?
What is rac?