|
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
 Related Questions Latest Answer : When this query will be submitted to oracle it goes into different stages .ie. parse,bind,execute and fetch the result set. ... Read Answers (7) | Asked by : SaratKumar Latest Answer : When any DML operation is taking long time which may lead reuse of datablocks of undo segment by another DML, in this case oracle will throw snapshot too old error.For any DML oracle stores the undo image in rollback segment, suppose transaction A is ... Read Answers (5) | Asked by : SaratKumar Latest Answer : 8i-materilized views, instead of triggers, support internet, granting of columns
9i-timestamp, rename of column, new datatypes, rank, dense_rank, 9i joins ... Read Answers (9) | Asked by : Reddeppa When i type 'ed' or 'edit' in oracle i did n't presented by any editor,what is the problem? In oracle we are using dual table name for the temporary purpose. which table we are using in SQL server Latest Answer : V$backup : This status column of this view shows whether a tablespace in hot backup mode.The status 'ACTIVE' shows the datafile to be in backup mode.V$datafile_header : The fuzzy column also helps a dba to monitor datafile which are in backup mode. ... Read Answers (1) | Asked by : Deep Chandra Padey Tags : Backup Latest Answer : hello dual is a table which is created by oracle along with the data dictionary. It consists of exactly one column whose name is dummy and one record. The value of that record is X. sql> desc dualName Null? ... Latest Answer : When you try to execute procedure from procedure just write procedure name. If you are executing from SQL*Plus them write EXEC Thanks, Shailu ... Read Answers (3) | Asked by : vasant Tell me the diffrences between oracle 8 and oracle 8i versions. wat are the features added in 8i version. thank u Read Answers (4) | Asked by : laxmikanth Latest Answer : char(size) max size upto 2000 min 1varchar2(size) max upto 4000 min 1 ... Read Answers (1) | Asked by : Mounica
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
