gemini burj

 Profile Answers by gemini burj Questions by gemini burj

• Oct 23rd, 2007

As in case of normalization and properly index conditions and order of coulumns are not require to care the pointer of the new record created at last. This will be managed by the indexes and orders of...

Madhu

• Mar 24th, 2007

Suppose a table dept contains 3 columns say deptno,dname and loc.If u want to change the order of dname and loc in reverse,then write  a query as followscreate table dept1 as  (select deptno,loc,dname from dept);drop table dept;create table dept as (select * from dept1); 

Answer Question  Select Best Answer

vishnu vardhan reddy

 Profile Answers by vishnu vardhan reddy Questions by vishnu vardhan reddy

• Sep 16th, 2008

To join a table itself is called self join.

krishnaindia2007

 Profile Answers by krishnaindia2007 Questions by krishnaindia2007

• Jun 22nd, 2008

Join the table to itself is called self join. It is used when you need to join the data with the same table data.Ex:- SELECT A.ENAME,A.SAL ,B.ENAME,B.SAL        FROM EMP A,EMP B      WHERE A.MGR = B.EMPNO

Answer Question  Select Best Answer

g_sidhu

 Profile Answers by g_sidhu Questions by g_sidhu

• Feb 7th, 2008

An inline view is created by placing a subquery in the FROM clause and giving that subquery an alias. The subquery defines a data source that can be referenced in the main query.

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 12th, 2006

When a query is given inplace of tablename in from cluse .  The query becomes a inline view.

Answer Question  Select Best Answer

krishnaindia2007

 Profile Answers by krishnaindia2007 Questions by krishnaindia2007

• Jun 22nd, 2008

A cusor can tabke out parameter. But never use OUT and IN OUT parameters in functions. The main purpose of function is to take zero or more parameters and return a single value.

BASAVARAJ KOLUR

• Mar 9th, 2007

function can take out parameter and in out parameter in that case it returns values  to calling program with return value also    accroding to me its not good programing style to u...

Answer Question  Select Best Answer

ravi.8311

 Profile Answers by ravi.8311 Questions by ravi.8311

• Jun 30th, 2008

Ref cursor is dynamic and no need to declare variables.ref cursor as two types 1.stong cursor(it has return value)2.week cursor (it has no return value)

bharatdwajmishra

 Profile Answers by bharatdwajmishra Questions by bharatdwajmishra

• Jun 23rd, 2008

I know about REF cursor..it is one datatype , which by we return data to web pages fetch by java.. but REP cursor is new foe me..

Answer Question  Select Best Answer

Praveen2384

 Profile Answers by Praveen2384 Questions by Praveen2384

• Sep 9th, 2008

Delete from table_name where rownum in (select min(rownum) from table_name group by column2,column3);where column2 and column3 are repeating columns.

Karthik

• Mar 14th, 2007

Hi,If you have primary key Constrains in the tableFollowing is query will select the duplicate ----------------------------------------Select * from X a, X bWhere a.1 != b.1 ( Primary Key) And a 2 = b...

Answer Question  Select Best Answer

Imran_Javed

 Profile Answers by Imran_Javed Questions by Imran_Javed

• May 12th, 2008

SELECT   SUM(col_name)FROM   ( SELECT ROWNUM rn,  col_name FROM tab_name)WHERE   MOD(rn,2)!=0;

Rohan Deshpande

• Jan 30th, 2007

Select sum(max(sal)) from table_name;

Answer Question  Select Best Answer

daravipg

 Profile Answers by daravipg Questions by daravipg

• Dec 7th, 2008

Select sum(decode(sign(num), 1, num,0)) pos, sum(decode(sign(num), -1, num,0)) negfrom Table_name

Rina_S

 Profile Answers by Rina_S Questions by Rina_S

• Dec 24th, 2007

E.g. SELECT * FROM TAB1; COL1 C----- -   -1 A   -2 A    1 B    2 BSELECT DECODE(SIGN(COL1), -1, col1, null) A, DECODE(SIGN(COL1), 1, COL1, NULL) ...

Answer Question  Select Best Answer

puritm

 Profile Answers by puritm Questions by puritm

• Nov 25th, 2010

 GRANT SELECT ANY TABLE TO user2;

yagneswarasankar

 Profile Answers by yagneswarasankar Questions by yagneswarasankar

• Nov 24th, 2010

SQL> conn sample/sample;Connected.SQL> select count(1) from girija.employees;select count(1) from girija.employees             &n...

Answer Question  Select Best Answer

rahul.katke

 Profile Answers by rahul.katke Questions by rahul.katke

• Jun 24th, 2008

The column numbers are used so that you can do the order by without keying in all the column names in the order by clause. For eg.select empno, ename from emp order by empno; -- qry 1could b...

krishnaindia2007

 Profile Answers by krishnaindia2007 Questions by krishnaindia2007

• May 16th, 2008

There is no relation between column_id in user_tab_columns and column number in order by clause.For exampleSelect ename,job, sal from emp order by 1;Here it will arrange data in the order of employee ...

Answer Question  Select Best Answer

How can we view sysdate for n number of times

rpsingh

 Profile Answers by rpsingh Questions by rpsingh

• Jun 21st, 2008

Select sysdate from dual;

krishnaindia2007

 Profile Answers by krishnaindia2007 Questions by krishnaindia2007

• Jun 21st, 2008

Select sysdate from user_tables where rownum <=50; Here you can use any table name that contains more than 50 rows.

Answer Question  Select Best Answer

How can I copy the stucture of a table to a text file.

sampra

 Profile Answers by sampra Questions by sampra

• Mar 6th, 2012

Create table ABC as (select * from XYZ where 1=2)

krishnaindia2007

 Profile Answers by krishnaindia2007 Questions by krishnaindia2007

• Jun 21st, 2008

You can copy the definition of objects to text file using dmbs_metadata package.This is the query to copy emp table definition to text file.spool textfilenameselect dbms_metadata.get_ddl('TABLE','EMP','CMSJAN') from dual;spool off;

Answer Question  Select Best Answer

What is a SET operator? What are the types what is the difference between SET operators and JOINS?

Aparna

• Apr 5th, 2012

Union --> All rows/cols from 1st select and 2nd select with no duplicates Union All -->All rows/cols from 1st Select and 2nd Select with duplicates Intersect --> Rows common in both select statements...

dajjaal

 Profile Answers by dajjaal Questions by dajjaal

• Sep 20th, 2010

The UNION operator is used to combine the result-set of two or more SELECT statements.   SQL joins are used to query data from two or more tables, based on a relationship between certain columns in these tables.

Answer Question  Select Best Answer

How to delete contents in two tables at a time? When you delete contents in one table then other table contents should also be deleted.

sampra

 Profile Answers by sampra Questions by sampra

• Mar 6th, 2012

1> always avoid select * from
2> do not use in operator

krishnaindia2007

 Profile Answers by krishnaindia2007 Questions by krishnaindia2007

• Jun 20th, 2008

You may also use triggers for this purpose. But specifying on delete cascade while defining foreign key constraint is better option.

Answer Question  Select Best Answer

What are Column Level Constraint and Table Level Constraint? How do they differ from one another?

katgeektalk

 Profile Answers by katgeektalk Questions by katgeektalk

• Aug 22nd, 2010

You can create the constarin at either the column or table level. Constrain defined at the column level are included when the column is defined. Table-level constrains are defined at the end of the ta...

hindol_saha

 Profile Answers by hindol_saha Questions by hindol_saha

• Jan 20th, 2010

The NOT NULL constraint can be define only at column level,It enforces that a value must be define for this column such tht the column may not be NULL for any row in any circumstance.

Answer Question  Select Best Answer

How to handle Null value in WHERE Condition?

taaznyonker

 Profile Answers by taaznyonker Questions by taaznyonker

• Mar 31st, 2010

Use "IS NULL" to check whether value is null or "IS NOT NULL" to check the value is not NULL

nikhilanshuman

 Profile Answers by nikhilanshuman Questions by nikhilanshuman

• Mar 16th, 2010

You should use "IS NULL" or "IS NOT NULL" in the where clause.For example :select DEPT_NAME from DEPT where DEPT_CD IS NOT NULL;The above query returns all those department names from the table "DEPT" where the column "DEPT_CD" is not null.

Answer Question  Select Best Answer

Construct a query which finds the job with the highest average salary

Shubham kumar

• Oct 21st, 2021

Hope, This Will Help

Code
 

taaznyonker

 Profile Answers by taaznyonker Questions by taaznyonker

• Mar 31st, 2010

If you want to get only highest average salary of particular dept, then you can use SELECT MAX(AVG(sal)) FROM emp GROUP BY deptno and if want the dept number too, with the average sal, then query ould...

Answer Question  Select Best Answer

There is a table with pluks and zinks. Each pluk only resides on a single zink and each zink may contain multiple pluks. How do you find how many pluks are on each and every zink?

royalcrown

 Profile Answers by royalcrown Questions by royalcrown

• Aug 15th, 2011

Select zink_id,count(*) total from table_name group by zink_id;

goel_vibhore

 Profile Answers by goel_vibhore Questions by goel_vibhore

• Apr 12th, 2010

Select Zink, count(plunk) as Count from PZgroup by zink

Answer Question  Select Best Answer

I have to tables A and B. My records in this table are in such a way that

Table A Table B

10 15
11 16
12 10
13 11

Question :- I want only the 10 and 11 records as my output.

Can anyone help me out ( 5 ways...

hussain

• Mar 29th, 2012

Code
 

SivaKumar

• Mar 23rd, 2012

Method 1

Code
 

Answer Question  Select Best Answer

Delete from table_name where rowid not in (select max(rowid) from table group by duplicate_values_field_name); ordelete duplicate_values_field_name dv from table_name ta where rowid <(select min(rowid) from table_name tb where ta.dv=tb.dv);

thirupathireddy

 Profile Answers by thirupathireddy Questions by thirupathireddy

• Feb 2nd, 2010

DELETE FROM table_name a WHERE rowid > (SELECT min(rowid) FROM table_name b WHERE a.column_name=b.column_name)

syam sundar

• Aug 18th, 2007

Delete table_name t1where rowid>(select rowid from table_name t2)and t1.column1=t2.column1

Answer Question  Select Best Answer