 Related Questions How to query to know, that dbms_rowid package contains ROWID_OBJECT, rowid_block_number ,etc procedures or functions in it. Hello,I need some info, that is it possible to find or make query ,that if we know the data stored in a table but don't know the field name in which the required data is stored.ExampleTable having fields like columnA, columnB, columnC, columnD,..........columnN and all have the same dataType. and you dont know in which field your data exists.suppose some data like e.g. "BackMan" exists in any Field of the table but we don't know in which Field this information is store.Is it How to return multiple records from procedure?e. g. I fired a select query and I want to retun a result to ? Latest Answer : Pre-query trigger fires only ones while post-query trigger fires each time.the Post-Query trigger fires each time Form Builder fetches a record into a block.RegardsPawan Ahuja ... Read Answers (1) | Asked by : Ramachandra I have to replace a particular value say "_" with a space in particular column of a table, kindly provide me the query how to achieve this. Read Answers (2) | Asked by : Pattabiraman How to write a query or procedure or function to retrieve all the tables from database where the table dont have any data (no rows). Database has 100 tables and some of the tables dont have any data. I want to pullout those table names from database in Oracle. Read Answers (3) | Asked by : Robert Latest Answer : 1) First identify the current excecution plan by using showplan.In most cases, creating and then forcing usage of the indexes result in drastic improvement.1) Ensure that indexes(single or composite) exist for columns referred to in the where clause.2) ... Read Answers (1) | Asked by : Muhammad Fayyaz How to query the customer details from a Table who have purchased No. of items greater than 5? Latest Answer : select column 1,...column n from table namewhere purchaseno 5 order by purchaseno;try this one .....ThanksRAJIV GUPTA YOGIK TECHNOLOGIES PVT LTD.JAMSHEDPUR ... How can i choose which query is best?i.e On which factors i can choose the best query? Latest Answer : By forcing the SQL engine to use indexes.If query is too much nested then break it into two or three queries using temp tables and then write one query by joining these temp table to perform the task. ... While tuning SQL query what should be taken into consideration? Latest Answer : During the SQL tuning, there couple of things need to be considered1. If it is below Oracle 9i we need make sure about the driving table concept (Since it uses RBO - Rule Based Optimization), which improves the performance, After
Oracle 9i Oracle will ...
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
