sharmasl

 Profile Answers by sharmasl Questions by sharmasl

• Mar 23rd, 2009

These are the querys:- FOR Odd number of records: select * from emp where (rowid ,1) in (select rowid, mod(rownum,2) from emp);   FOR Even number of records: select * from emp where (rowid ,0) in (select rowid, mod(rownum, 2) from emp); try.........................

nandk.sharma

 Profile Answers by nandk.sharma Questions by nandk.sharma

• Jun 30th, 2008

We can use the below query to get the odd record of the table  --select r from (SELECT rownum r FROM EMP)where mod(r,2) != 0We can use the below query to get the even record of the table  --select r from (SELECT rownum r FROM EMP)where mod(r,2) = 0

Answer Question  Select Best Answer

sharmasl

 Profile Answers by sharmasl Questions by sharmasl

• Mar 23rd, 2009

use the following syntex for drop the columnalter table emp drop column ename;

NARENDRA

• Dec 12th, 2006

Alter table?TABLENAME drop column?COLUMNNAME Generally rollback cant be followed are implemented along with these DDL statements. The commit statement automatically involves.

Answer Question  Select Best Answer

supratim.kundu

 Profile Answers by supratim.kundu Questions by supratim.kundu

• Mar 4th, 2010

An equi join is used to?retrieve?all the columns from both the tables. An inner join is used to?retrieve selected columns from tables.

patilpravin_1981

 Profile Answers by patilpravin_1981 Questions by patilpravin_1981

• Jan 28th, 2008

Inner jon Or equi join  is The query that retrives the rows that exact match using (=) sign in where clause

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

Answered by: NK

• Jun 29th, 2005

---

A join is a query that combines rows from two or more tables, views, or materialized views. Oracle performs a join whenever multiple tables appear in the query's FROM clause. The query's select list can select any columns from any of these tables. If any two of these tables have a column name in common, then you must qualify all references to these columns throughout the query with table names to avoid ambiguity. 
 
Most join queries contain WHERE clause conditions that compare two columns, each from a different table. Such a condition is called a join condition. To execute a join, Oracle combines pairs of rows, each containing one row from each table, for which the join condition evaluates to TRUE. The columns in the join conditions need not also appear in the select list. 
 
To execute a join of three or more tables, Oracle first joins two of the tables based on the join conditions comparing their columns and then joins the result to another table based on join conditions containing columns of the joined tables and the new table. Oracle continues this process until all tables are joined into the result. The optimizer determines the order in which Oracle joins tables based on the join conditions, indexes on the tables, and, in the case of the cost-based optimization approach, statistics for the tables. 
 

csbhaskar

 Profile Answers by csbhaskar Questions by csbhaskar

• Apr 7th, 2011

A join is a query that results in combining rows from two or more tables, views, or materialized views. Oracle Database performs a join whenever names of multiple tables, views or materialized views a...

nirmal1in

 Profile Answers by nirmal1in Questions by nirmal1in

• Jan 3rd, 2010

Join is relation between more than one table. No of minimum join conditions required is equal to n-1 (where n is number of tables joined together)

Improve Answer

Read Best Answer

Editorial / Best Answer

Answered by: Sailaja Pasupuleti

• Dec 4th, 2005

---

    A sub-query is a part of query.  Sub-queries are useful to find unknown value(s).

   Ex:  To find details of employees who are getting maximum salary.

         In this requirement, the maximum salary not mentioned.

Solution:    

To find maximum salary, 

          select max(sal) from emp;

For that maximum salary the employee details, 

          select * from emp where  sal = (select max(sal) from emp);

So, in the above query, "select max(sal) from emp"  is also a query but it returns a value (unknown or not given) and compares with "sal" column.  This query is called sub-query.

kshsingh1

 Profile Answers by kshsingh1 Questions by kshsingh1

• Jan 22nd, 2007

A query nested within another SQL statement is called a subquery.

thumatinagaraju

 Profile Answers by thumatinagaraju Questions by thumatinagaraju

• Oct 25th, 2006

Simple reply nalini ..goodnagthumati_nagaraju@yahoo.co.in

Improve Answer

Gayathri Panchangam

 Profile Answers by Gayathri Panchangam Questions by Gayathri Panchangam

• Sep 4th, 2008

Yes.Becoz sysdate contains date and time.For example: if u create a table like thiscreate table ex(id number,date1 date defualt sysdate unique);u get table created. After that if u insert rows in that...

lovely sethii

 Profile Answers by lovely sethii Questions by lovely sethii

• Jun 17th, 2008

Yes it will

Answer Question  Select Best Answer

Answer posted by Scott on 2005-05-25 18:39:48: When you create a sequence with CYCLE option, you are saying that when the sequence reaches its MAXVALUE, it will start over at the MINVALUE. This is not wise if using the sequence for primary key creation.  When you create a sequence with NOCYCLE option, you are saying that when the sequence reaches its MAXVALUE, it will NOT start over at the...

rahul

• Aug 6th, 2017

I tried ....sequence will start from 1

feliz

• Aug 15th, 2016

Kirnapps, this is not correct - CYCLE will restart with the minvalue again - it will not go past the maxvalue, as kiranapps post reply states.

Answer Question  Select Best Answer

Deepika S Verma

• Mar 10th, 2014

Ref Cursors are used in two conditions
(1) When we have a dynamic query, means when we get the information at runtime related to query(like column name, table name etc)
(2) Or when we want to pass whole resultset to another proc/func.

suresh reddi

• Aug 19th, 2011

Using ref cursor we can pass different values( i.e by changing parameters) to the cursor which is declared in the package specification from the package body. Ref cursors are of 2 types a) weak r...

Answer Question  Select Best Answer

abhi_only12000

 Profile Answers by abhi_only12000 Questions by abhi_only12000

• Jan 2nd, 2010

Grant all privileges of user_name1 to user_name2 with grant option.where user_name1 is the user of which we have to pass privileges,and user_name2 is the user to which we are assign the privileges,and grant  option is nothing but it allows the user_name2 to pass all privileges to another.

mukesh

• Mar 20th, 2007

SELECT 'GRANT ' ||privilege ||' ON '||table_schema||'.'||table_name ||' TO '||USER ||' ;' FROM ALL_TAB_PRIVSWHERE grantee ='TILITS' -- user name that has already access 

Answer Question  Select Best Answer

Answer posted by Scott on 2005-05-25 18:43:29: SELECT rownum, rowid FROM sometable

Ankush Gupta

• Feb 10th, 2012

Common Pseudo columns are CURRVAL,NEXTVAL,ROWID,ROWNUM,SYSDATE etc.

laxman

• Oct 9th, 2011

Pseudocolumns are uid,user,sysdate,rownum,rowid,level,rowscn

Answer Question  Select Best Answer

emraan

 Profile Answers by emraan Questions by emraan

• Dec 29th, 2009

Select sal, to_char(to_date(sal, 'j'), 'jsp') from emp

bhaskar1981buie

 Profile Answers by bhaskar1981buie Questions by bhaskar1981buie

• Dec 4th, 2007

The number which have precesion can be spelled in words by this way..SELECT DECODE(SUBSTR(LPAD('1256932.1',DECODE(INSTR('1256932.1','.'),0,11,DECODE(LENGTH('1256932.1')...

Answer Question  Select Best Answer

If changes are made to the tables which are base tables of a view will the changes be reference on the view.

Andy

• Jul 9th, 2015

You cannot associate a view with trigger

Animesh Mondal

• May 11th, 2015

The view must have the Primary Key and NOT NULL columns of the base table for any insert to happen on a view

Answer Question  Select Best Answer

What is default constraint? How we you apply it?

Sam Kolta

 Profile Answers by Sam Kolta Questions by Sam Kolta

• Apr 25th, 2010

1. What is default constraint? Constraints are specific values that used to limit the type of data that can go into a table by ensure certain columns have a true condition when data is inserting, modi...

gdurga

 Profile Answers by gdurga Questions by gdurga

• Jun 15th, 2009

A coulumn can be given a default value by using DEFAULT option. This option prevents null values from entering the column if a row is inserted with out a value in to the table.Ex: .......Hire_date DATE DEFAULT SYSDATE,.......

Answer Question  Select Best Answer

csbhaskar

 Profile Answers by csbhaskar Questions by csbhaskar

• Mar 25th, 2011

SQL statements can be subdivided into the following six types:1. Data Definition Language (DDL) statements let you to perform these tasks:          CREATE,...

majidwgl

 Profile Answers by majidwgl Questions by majidwgl

• Dec 5th, 2009

Data Definition Language.Data Manipulation Languge.Data Transaction Control Language. Data Manipulation Control Language.Data session control. Data system control. etc these are SQL types statements.

Answer Question  Select Best Answer

katgeektalk

 Profile Answers by katgeektalk Questions by katgeektalk

• Aug 26th, 2010

If the values in the field comm both NULL and 0 the query should beselect empno, decode(nvl2(comm, to_char(comm), 'N/A'), '0', 'N/A')from scott.empNVL2 to convert NULL value into N/ADecode to convert 0 value into N/A

emraan

 Profile Answers by emraan Questions by emraan

• Dec 29th, 2009

1) SELECT e.*, nvl2(comm, 'Not Null', 'Null') FROM emp e  2) SELECT e.*, decode(comm, '', 'Is Null', 'Is not Null') FROM emp e

Answer Question  Select Best Answer

Join is a query which retrieves related columns or rows from multiple tables.Self Join - Joining the table with itself.Equi Join - Joining two tables by equating two common columns.Non-Equi Join - Joining two tables by equating two common columns.Outer Join - Joining two tables in such a way that query can also retrieve rows that do not have corresponding join value in the other table.

GOPAL

• Jul 28th, 2015

Joins are used to join the columns of different tables. Types of Joins: 1. Inner Joins, 2. Outer Joins Inner Joins are sub divided into two types 1. Self Join, 2. Equvi Join Self Join is used to joi...

sukanya

• Jun 28th, 2015

Can any one tell me what is self join? What is difference between GROUP BY and HAVING?

Answer Question  Select Best Answer

emraan

 Profile Answers by emraan Questions by emraan

• Dec 29th, 2009

Select * from emp where substr(ename, -1) = 'S'Thanks & Regrads

goutamgeek

 Profile Answers by goutamgeek Questions by goutamgeek

• Dec 23rd, 2009

select * from table_name where substr(first_name,length(first_name),1)='S'

Answer Question  Select Best Answer

ranadhee_85

 Profile Answers by ranadhee_85 Questions by ranadhee_85

• Feb 9th, 2011

SELECT sysdate FROM dual;

younaskhan40

 Profile Answers by younaskhan40 Questions by younaskhan40

• Apr 20th, 2010

Select To_Char(SYSDATE,'DD-MON-RRRR HH:MI:SS AM') From Dual;

Answer Question  Select Best Answer

TRUNCATE commits after deleting entire table i.e., can not be rolled back. Database triggers do not fire on TRUNCATEDELETE allows the filtered deletion. Deleted records can be rolled back or committed.Database triggers fire on DELETE.

nandk.sharma

 Profile Answers by nandk.sharma Questions by nandk.sharma

• Jun 27th, 2008

Truncate is faster than delete as it does not generate rollback segment.

nandk.sharma

 Profile Answers by nandk.sharma Questions by nandk.sharma

• Jun 27th, 2008

TRUNCATE -  Truncate is a ddl command.DELETE-     Delete is a dml command.TRUNCATE - We can not use 'where' clause with truncate.DELETE-      We can use 'where '  clause  with delete .

Answer Question  Select Best Answer

Sai

• Aug 22nd, 2017

A view doesnt hold any data it just shows you the statements .... A materialized view holds data and it is used to connect to other server to access data from particular table and it just brings data...

annaiah

• Jun 26th, 2014

In views query result in not stored in disk or database but materialized views allow to store query result in disk or database when we create views using any table rowid of view is same as original ta...

Answer Question  Select Best Answer