HI ALL, I AM FACING DATABASE ERROR EXP-00002 IN ORACLE 10G, WIN XP OS. PLS HELP ME TO SOLVE THIS PROBLEM. AM NEW TO DBA ACTIVITIES
1 6787ORACLE/SQL-RDBMS 1.Max (), Min () Functions, 2. Order by, Group by Functions, 3. Sql Pipe Functions 4. Truncate Functions Which Part of Sql? DDL, DML, or TCL 5. Find Out Primary keys in databases 6. Select Customers who have same city Based on constraints based on index based on view based on group by
1939oracle 1st round What are the different types of joins? Explain normalization with examples. What cursor type do you use to retrieve multiple recordsets? Diffrence between a "where" clause and a "having" clause What is the difference between "procedure" and "function"? How will you copy the structure of a table without copying the data? How to find out the database name from SQL*PLUS command prompt? Tadeoffs with having indexes Talk about "Exception Handling" in PL/SQL? What is the diference between "NULL in C" and "NULL in Oracle?" What is Pro*C? What is OCI? Give some examples of Analytical functions. What is the difference between "translate" and "replace"? What is DYNAMIC SQL method 4? How to remove duplicate records from a table? What is the use of ANALYZing the tables? How to run SQL script from a Unix Shell? What is a "transaction"? Why are they necessary? Explain Normalizationa dn Denormalization with examples. When do you get contraint violtaion? What are the types of constraints? How to convert RAW datatype into TEXT? Difference - Primary Key and Aggregate Key How functional dependency is related to database table design? What is a "trigger"? Why can a "group by" or "order by" clause be expensive to process? What are "HINTS"? What is "index covering" of a query? What is a VIEW? How to get script for a view? What are the Large object types suported by Oracle? What is SQL*Loader? Difference between "VARCHAR" and "VARCHAR2" datatypes. What is the difference among "dropping a table", "truncating a table" and "deleting all records" from a table. Difference between "ORACLE" and "MICROSOFT ACCESS" databases. How to create a database link ? PL/SQL interview questions... Normalize many to many relationships Difference - Equijoin and union What is TEMP table space in Oracle, what is rollback segment How do we find row chaining? Pattern matching operators Features in oracle 9i and 10g Why truncating table is faster than delete copy commit syntax Convert Zulu time zone to US Eastern time zone Difference - union and union all Difference - Group by, Order by clause Which Ranking functions are available? Difference - Decode, NVL, NVL2 Tradeoffs of using partitioned tables How can we call stored procedure in SQL query What are the restrictions on calling PL/SQL from SQL Why EXISTS is preferable to distinct Give 2 examples of avoiding unnecessary parsing.
3753im interested making my careein oracle financials platform. my bkgund is btech cse,MBA in mkt,hr.having 3+experience.in hr work. pls suggest me .wht can i do
1 3215
Can we install Oracle database in VT100 Server?
How primary key is implemented in Oracle?
What are the Oracle specific tuning should be done?
Explain the difference between $ORACLE_HOME and $ORACLE_BASE.
Where in the Oracle directory tree structure are audit traces placed?
Is it possible to call oracle database through ADO control or Object?
how can one transfer LOB and user defined data from oracle to warehouse using ETL informaticabecause
Explain about the Optimizer values passed in Oracle?
How do you script this scenario in QTP using VB? Verify XML attributes in XML message against XSD and data mapping of fields to Oracle tables? Verify data in XML to data in a defined table?
How do you rate yourself in c#,vb.net,Asp.net,oracle,sql server ?
In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha
what is the difference between oracle 8i vs 9i
What are file in oracle.
Why Non-blob column in table required to perform operation with Oracle ?
Hi Friends, How many types of Data Bases available in market... What is the diff. while using Syabase and Oracle in a Project... ? and what is the main diff. of Syabase and Oracle databases... ? Thanx in advance..