|
| 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 : contents or data of the table can be sorted by using clause ORDER BY in SELECT statement.By default the table is in ASCENDING order.SYN: SELECT * from [table name] where [condition] ORDER ... Latest Answer : There are 3 types of joins basis on Oracle 8i
Simple join
     1. Equi join : Equi join is one which contains comparision operator '=' in where clause.
     2. Non Equi join: If the comparision operator in the join condition is other than ... Latest Answer : Depends on when you commit the changes. If u are processing like above (in a for loop) you should commit post processing, after the cursor is closed. But that's often not useful on huge amount of data. any commited transactions to cursor data while the ... Latest Answer : No it isn't. If you are going to select most of the entries then you will have to read through the entire table anyway. Forcing the use of an index will just be an extra overhead. ... Latest Answer : select sum(bytes)/1024 from dba_segments where segment_name='TABLE_NAME' and owner=' 'As segment_name represents table_name,index_name..provide the table_name and index_name in the above query ... I currently can't see my custom SQL views from IDS9 in MS Access when I want to link the table to an Access DB which is used for integration.IDS runs on SuSE9, MS Access 2K on XP. Latest Answer : Lookup tables are like constraints which hold a value. The content in the lookup tables dosen't change often, hence refered as lookup (reference). Example : Countries table Countries are not added on regular bases hence one can consider the table ... What are the merits & demerits of uniformed sized extents in locally managed table spaces over non uniformed sized extents in dictionary managed table spaces? Read Answers (1) | Asked by : nutan Latest Answer : FTS means the oracle server reads all the records from the concerned table. And it all depends on the size of the table/ partitioned table. What you say if a table consists of 10 million of records. so we musr avoid FTS. And after all Oracle is ... When normalizing a table that can have a many to many relationship with another table, what steps should you take? looking for a detailed answer if possible View Question | Asked by : jim hickey
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
1 
0