What is the purpose of init.ora. ? how many init.ora exist in oracle installation? suppose there are 3 database on one oracle server, how many init.ora do I have? what are various database objects? how will you identify memmory related performace issue in oralce? any idea about basic architure difference of oracle and db2? comment on which is better , with reasons? what is a fuction based index? is it recommended to use the same. ? what is global temporay table? what is teh signification of the parameter session_cached_cursor ?
HDFC,
1 5776Ho to insert no. of records at a time..i mean i want to insert 100 records at a time into a table
5 10644I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database
EDC,
2134Define the terms primary key foreign key and also the difference between primary and the unique key
2 11195i have a table and it has constraints and i want to get "ALTER TABLE table_name ADD CONSTRAINT constraint_name constraint type" this code must be in string type please help me if you want, i can give more explainings
2 4897i must get table name, constraint type, constrain name with using concads "||" and it must be in string type, then with join processes i need code please help immidiately
1 4439ex. one table is having 1 column with 10 records , then how to display all the values in row wise ?
4 7894How to transfer database(500 gb) of oracle enterprise edition to standard edition downtime is only 1 hour not using exp/imp option ?
3 7572SELECT * FROM (SELECT TITLE FROM MOVIE ORDER BY RANK DESC) WHERE ROWNUM > 4; when i run the above query .it produces output as NO ROWS SELECTED.why ?plz any one help me
TCS,
6 14305Post New Oracle General Questions
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE
What is Trigger in Oracle?
How to write text literals in oracle?
How to define a cusotmer as a supplier in ORACLE R12
List the various oracle database objects?
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
What is a cursor variable?
How to create a new tablespace in oracle?
How to delete all rows a table in oracle?
What are the uses of Database Trigger ?
please explain.. DB architecture ...
What is oracle join syntax?
How to convert numbers to characters in oracle?
What are the different windows events activated at runtime ?