-
-
Difference between HASH JOIN And MERGE JOIN
Hash joing is implemented in CBO and comparatively faster. Merge joing is comparatively slow because both the row sources are to be sorted before merging.
-
-
How to get top 50 URLs for a particular date.i,e getting the distinct count of URLs,then getting the maximum of that and next 49 URLs depending on count.It should be in descending order
rajamuna
- Apr 4th, 2006
SELECT *,ROWNUM r FROM (SELECT COUNT(url_name) hit,url_name FROM URL_DETAILS_TBL WHERE url_name IN (SELECT DISTINCT url_name FROM URL_DETAILS_TBL WHERE TO_DATE(ENTRY_DATE,'MM/DD/YYYY') = '12/13/2005')...
-
Can a function take OUT parameters. If not why?
No. A function has to return a value,an OUT parameter cannot return a value.
-
-
-
How do i execute a query sayselect * from tablename and write reasult to a text file say c: kk.txt
Sarfaraz Ahmad Khan
- Jul 18th, 2006
yeah its very simpleuse the syntax like this:spool <somefilename> (you can give the path also like c:sarfarazxyz.txt)<now your query>and to see that whether the result is actually st...
vssandilya
- Jun 12th, 2006
please give an exampe as to how to do it in SQL SERVERFOR EXAMPLE IAM HAVING A TABLE DEPARTMENT1I WANT TO STORE THE CONTENTS OFSELECT * FROM DEPARTMENT1 INTO C:KK.TXT.
-
-
How do we restrict the insert/ updates on the foreign column in a table if that table is in different instance that the table with Primary Key. Say for Example Emp and Dept Table. We have deptno in both tables and Deptno in Emp table is the Primary Key and other is foreign Key. How do we control what values we insert in Dept table if both the tables are not in the same instance.
dmadhusudhanarao
- Aug 2nd, 2006
see if you want totally restric insert and update create a view with required columns and give it to them. dont forget to readonly while creating the view.
Prakash Pagam
- Jul 24th, 2006
We can do using databasename.tablename
-
-
-
What are ORACLE PRECOMPILERS?
Using ORACLE PRECOMPILERS, SQL statements and PL/SQL blocks can be contained inside 3GL programs written in C,C++,COBOL,PASCAL, FORTRAN,PL/1 AND ADA.The Precompilers are known as Pro*C,Pro*Cobol,...This form of PL/SQL is known as embedded pl/sql,the language in which pl/sql is embedded is known as the host language. The prcompiler translates the embedded SQL and pl/sql ststements into calls to the...
-
-
-
There is a varchar2 column ,How can I insert data which contains ' in it ,eg-Ora'cle ??The value to be inserted may vary with every insertion and we can't specifically tell as to whats the position of single quotes ..
senkumaar
- Oct 12th, 2006
In MS-SQL server we can use likeINSERT INTO () VALUES CONVERT(VARCHAR,))ExampleINSERT INTO SEN_TEST(NAMEE) VALUES(CONVERT(VARCHAR,10))
senthilkumar
- Oct 12th, 2006
-MS SSQL Inserting integer values in to varchar columINSERT INTO (col1) VALUES(CONVERT(VARCHAR,10))
-
-
-
-
Why statistics are different in oracle9i and oracle 10g?
Not sure about this, better we could try again with right samplesize in both the versions. Use DBMS_STATS.AUTO_SAMPLE_SIZE.ExecuteDBMS_STATS.GATHER_SCHEMA_STATS('SCOTT',estimate_percent=>DBMS_STATS.AUTO_SAMPLE_SIZE,GRANULARITY=>'ALL',CASCADE=>TRUE);
Jian Zhang
- Oct 22nd, 2006
Deafult Optimizer9i: CHOOSE10g: CBO
skumarpenugonda
- Jul 7th, 2006
Hi,I just started reading 10g. What I came to know that there are many features added and w.r.t. statistics, below are the changes, or new features.1. AWR ( Automatics Work Load repository )...
Oracle SQL Interview Questions
Ans