I have table with col1 values , col2 1st row value should be same col1 1st row, then col 2 row onwards row each should added each row values eg: col1 values 10,20,30. Etc, in col2 values display like 10, 30,60 etc. how we can write sql query ?

roshan.gwr

 Profile Answers by roshan.gwr Questions by roshan.gwr

• Mar 13th, 2015

Using Lag we can get it.
Select col1,col1+lag(col1,1,0) over (order by col1) col2 from table;

Vinod Kumar G M

• Nov 7th, 2014

SELECT COL_NAME , SUM(COL_NAME) OVER ( ORDER BY COL_NAME) FROM TABLE_NAME

Answer Question  Select Best Answer

TABLESVIEWSINDEXESSYNONYMSSEQUENCESTABLESPACES etc

suresh

• Mar 13th, 2015

Table,view,procedure,function,package,synonums,triggers,index,sequencess

ankitagujrati28

 Profile Answers by ankitagujrati28 Questions by ankitagujrati28

• Apr 30th, 2010

There are 5 objects:-1.Table2.View3.Synonyms4.Sequences5.Index

Answer Question  Select Best Answer

sanjay pradhan

• Sep 26th, 2014

Alter trigger trigger_name disable

vijaya

• May 11th, 2013

Alter trigger trigger_name disable/enable all triggers.

Answer Question  Select Best Answer

kitty

• Sep 8th, 2014

Can u plz explain me in detail about the answer you have provided with correlated sub query.

Thnks in advance !

yagneswarasankar

 Profile Answers by yagneswarasankar Questions by yagneswarasankar

• Dec 2nd, 2010

4th Highest Salary  1*  select a.last_name,a.salary from (select b.*,rownum rn from (select last_name,salary from employees order by salary desc)b)a where rn = &nSQL> /Enter value for...

Answer Question  Select Best Answer

jomarie

• Sep 2nd, 2014

This is formed when join conditions is omitted or invalid

sampra

 Profile Answers by sampra Questions by sampra

• Feb 26th, 2008

When a join condition is omited when getting  result from two tables then that kind of query gives us Cartesian product, in which all combination of rows displayed. All rows in the first table is joined to all rows of second table......

Answer Question  Select Best Answer

AiM

• Aug 23rd, 2014

Trigger code to create a trigger in disable mode starting 11g "oracle create or replace trigger prac_trig_emp1 before insert or update OR DELETE ON emp1 REFERENCING NEW AS NEW OLD...

Answer Question  Select Best Answer

How to convert rows in column using SQL in Oracle;
for example
sl_no
1
2
3
4
output is 1234;

How to convert one column value into rows using SQL
for example
employee_name
Kumar

output
K
u
m
a
r

Megamind

 Profile Answers by Megamind Questions by Megamind

• Apr 14th, 2014

We can do it via pivot keyword..... it will change the row into column.. its simply a pseudo column

Kandavel Durairaj

• Nov 8th, 2013

Using LISTAGG. Read the oracle documentation for more info.

Answer Question  Select Best Answer

What is the literal meaning of SQL

bhagare

 Profile Answers by bhagare Questions by bhagare

• Feb 5th, 2014

Structure quary launguge

nagarjuna

• Nov 21st, 2013

The terms literal and constant value are synonymous and refer to a fixed data value.For example, JACK, BLUE ISLAND, and 101 are all character literals

Answer Question  Select Best Answer

srini

 Profile Answers by srini Questions by srini

• Dec 6th, 2013

Using PIVOT we can do this:

http://www.dba-oracle.com/t_pivot_examples.htm

VIJAY SHARMA

• Sep 24th, 2012

SELECT SYS_CONNECT_BY_PATH(DEPTNO, )I ,
SYS_CONNECT_BY_PATH(DNAME, ) II,
SYS_CONNECT_BY_PATH(LOC, ) III
FROM DEPT
WHERE LEVEL = &TOTALDEPARTMENTS
START WITH DEPTNO = 10
CONNECT BY PRIOR DEPTNO < DEPTNO;

Answer Question  Select Best Answer

ambika

• Oct 21st, 2013

Recovery in centralized dbms

su4surya

 Profile Answers by su4surya Questions by su4surya

• Aug 24th, 2009

A centralized database has all its data at one place so there may occur problems of data avalability, and a system crash may lead to whole dataloss. In a distributed database, database is stored on se...

Answer Question  Select Best Answer

HAVING clause is used when you want to specify a condition for a group function and it is written after GROUP BY clause. The WHERE clause is used when you want to specify a condition for columns, single row functions except group functions and it is written before GROUP BY clause if it is used.

Mushtaque

• Aug 25th, 2013

WHERE clause can contains condition that must be met and should directly follow the from clause. And HAVING clause can precede GROUP BY clause,but it is more logical to declared in after GROUP BY clau...

Santhoshkandula

 Profile Answers by Santhoshkandula Questions by Santhoshkandula

• May 11th, 2011

?? we have to?apply the condition?Before grouping the records then you have to?use WHERE clause.?? we have to apply the condition after grouping the records then you have to apply HAVING clause.? Thanks & Regards??? K.Santhosh

Answer Question  Select Best Answer

Ehsan Rehmani

• Aug 7th, 2013

The set transaction statement used to establish the current transaction as read only or read write, establish its isolation level or assign it to a specified rollback segment or when someone use DDL statement.

Answer Question  Select Best Answer

What are Pair Wise & Non-Pair Wise Columns?

Vinod Tuteja

• Jun 6th, 2013

NON PAIRWISE COMPARISON SUBQUERY: "sql SELECT employee_id, manager_id, department_id FROM employees WHERE manager_id IN (SELECT manager_id FROM employ...

Answer Question  Select Best Answer

aytasirs

• Apr 29th, 2013

Yes We can. If we use the combination "unique+not null" the referential integrity is not maintained and that is not the case with primary key.

EHSAN REHMANI

• Apr 27th, 2013

There is only one primary key per table but we can use unique and not null constraints more than one column in a table. Primary key having both functionality as it can not be null but unique.

Answer Question  Select Best Answer

List the premium customers who is not using the service within the last one week.if you have these tables: 1-'Premuim_USER'columns: Customer_ID, post_paid.2-'calls'columns: called_number, Customer_ID, call_date, call_time_started, Call_time_ended, transaction_no.

Vijay

• Mar 20th, 2013

By using merge statement we can do it simply.

smi

• Jul 30th, 2012

Use merge stat

Answer Question  Select Best Answer

SQL> select sal, (to_char(to_date(sal,'j'), 'jsp'))from emp;the output like,SAL (TO_CHAR(TO_DATE(SAL,'J'),'JSP'))--------- -----------------------------------------------------800 eight hundred1600 one thousand six hundred1250 one thousand two hundred fiftyIf you want to add some text like, Rs. Three Thousand only.SQL> select sal "Salary ",(' Rs. '|| (to_char(to_date(sal,'j'), 'Jsp'))|| ' only.'))"Sal...

Talal Haider

• Mar 16th, 2013

Can we convert a number in words without using direct function/method?

boobal

• Mar 21st, 2012

This answer is no different to
select to_char(to_date(1290,j),jsp) from dual;

Answer Question  Select Best Answer

How to fetch alternate rows from the table?

Ram

• Feb 6th, 2013

Code
 

Millar

• Jul 26th, 2012

Code
span style="font-style: italic;">--to find even rows in a table
--to find even rows in a table
--to find odd rows in a table

Answer Question  Select Best Answer

How can we retrieve some rows from the database without using select clause?

Ehsan Rehmani

• Jan 31st, 2013

Select clause is must for retrieving data from the database. You cant retrieve data without select clause.

Ehsan Rehmani

• Jan 2nd, 2013

Impossible! Rows will not be rerieved without select keyword.

Answer Question  Select Best Answer