Latest Answer: To Display even row numbers---------------------------select * from emp where (rowid,0) in (select rowid,mod(rownum,2) from emp ) To Display odd row numbers---------------------------select * from emp where (rowid,1) in (select rowid,mod(rownum,2) ...

Read Answers (6) | Asked by : kowmudiswarna

Answer Question Subscribe

Write a query to display employee records having same salary?

Latest Answer: SQL> select distinct e.name,e.salary from employe e, employe a 2 where e.salary = a.salary and e.name != a.name;NAME SALARY---------- ----------MANI ...

Read Answers (5) | Asked by : kowmudiswarna

Answer Question Subscribe

In a table a column is having value like 'Steven Kovy'. without using concat() function and

In a table a column is having value like 'Steven Kovy'. without using concat() function and concatenate operator "||" how to display like 'Kovy Steven'

Read Answers (2) | Asked by : us.arvindpriya

Answer Question Subscribe

How do you view the last record added to a table?

Latest Answer: /* * How do you view the last record added to a table? */Select Top 1 * from Emp Order By EmpID Desc ...

Read Answers (3) | Asked by : t_ahwaz

Answer Question Subscribe

Why is insert faster than delete?Which indexing technique works best for Oracle based database?

Latest Answer: The purpose of both the commands is different. Then how can you compare insert and delete performane? ...

Read Answers (1) | Asked by : Usman

Answer Question Subscribe

Is it possible to index a table through stored procedure? If Yes, How?

Latest Answer: Yes.. Using execute immediate which executes dynamic sql and pl/sql ...

Read Answers (1) | Asked by : ramprakash

Answer Question Subscribe

How to give select privilege on all the objects owned by an user(say user1) to another user say(user2)

How to give select privilege on all the objects owned by an user(say user1) to another user say(user2) using a single sql statement?

Read Answers (2) | Asked by : bijay bhowmick

Answer Question Subscribe

What is the difference between SQL standard joins and Oracle propreitary joins

Latest Answer: The Oracle9i database offers join syntax that is SQL: 1999 Compliant. Prior to release 9i, the join syntax was different from the ANSI standards. The new SQL: 1999 Compliant join syntax does not offer any performance benefits over the Oracle proprietary ...

Read Answers (1) | Asked by : Shreyoo

Answer Question Subscribe

Explain the differences between cost-based optimizer and Rule-based optimizer ? Why DB2, Sybase is cost

Explain the differences between cost-based optimizer and Rule-based optimizer ? Why DB2, Sybase is cost based and SQL, Oracle are Rule Based Optimisers ?

Read Answers (1) | Asked by : Aruna.G

Answer Question Subscribe

View page << Previous 1 2 3 [4] 5 6 7 8 9 10 Next >>

Go Top

#	User Name	Count
1	rampratap409	59
2	patilpravin_1981	26
3	g_sidhu	23
4	kowmudiswarna	13
5	ddkdhar	13
6	krishnaindia2007	12
7	globalanil18	10
8	nileshsingh	8
9	sbagai2001	8
10	dmadhusudhanarao	7

Get Latest Updates Via RSS Reader or by Email
Forum Discussion
Knowledge Base
Learning Series
Freelance Jobs
GeekInterview Blog
Testing Interview Questions
Oracle Interview Questions
Java Interview Questions
Latest Placement Papers
Free Training
Learn AJAX