I want to add a new column in our table and i already have 4 column in table i want that my column should be added at 3rd position not in last position ..

S. Venmathi

• Jan 5th, 2015

if we are a Admin there is some possible. As my thought, it is not possible. but we can change the order of the column when we show the table. Example, consider your your fourth column is last_name, w...

Answer Question  Select Best Answer

Which type of binding does PL/SQL use?

kanhaiya

• Oct 9th, 2014

Early binding

Answer Question  Select Best Answer

What is sql query to retrieve the second effective employees from job data for all the employees?

sathis raja

• Sep 11th, 2014

We can get 2nd maximum salary of the employees.

VIBHAV MISHRA

• Jun 30th, 2014

Select max(Sal) from Emp Where Sal not in(Select max(Sal) from Emp)

Answer Question  Select Best Answer

sweety

• Aug 23rd, 2014

Denormalization is done to increase query performance and
normalization is done to reduce data redundancy

Bhoomika sharma

 Profile Answers by Bhoomika sharma Questions by Bhoomika sharma

• Dec 16th, 2008

To increase the query performance thus demoralization is done.

Answer Question  Select Best Answer

DEPARTMENT_ID ,EMP_COUNT, DEPT_PERCENTAGE

VIBHAV MISHRA

• Jun 30th, 2014

Update

Answer Question  Select Best Answer

What is difference b/w coreleated subquery and nested subquery?

pradeep

• Nov 21st, 2013

A outer query out put is input of inner query

Vikas

• Jul 31st, 2013

Co-related sub query give reference to outer main query but nested sub query will have independent result set to be passed to outer query.

Answer Question  Select Best Answer

Aria Ansari

• Nov 12th, 2013

It is about referential integrity or making data both reliable and Secure. As an example by applying a foreign key constrain between customer and order tables It will not be allowed to create an order...

Answer Question  Select Best Answer

Can we make DML operations on base tables using a simple view?Can we insert or update or delete rows to the base tables using a view?

lviswanath

 Profile Answers by lviswanath Questions by lviswanath

• Jul 22nd, 2013

Of course we can do anything i.e. updating/deleting/inserting on a base table underlying a simple view, until unless its covering NOT NULL columns of the table in the query of the simple View.

ppad001

 Profile Answers by ppad001 Questions by ppad001

• Feb 27th, 2013

Yes we can use DML operations on single table view.

Answer Question  Select Best Answer

pradip

• May 26th, 2013

The primary difference between the DBMS and RDBMS we can add the foreign keys for relating the tables In dbms ,relation is between two files . while in rdbms relation is made between two tables. rdbms...

parth

• Jan 29th, 2013

Dbms does not support client/server architecture and rdbms supports client/server architecture.

Answer Question  Select Best Answer

Explain the normalization and why it is done. explain the case when we avoid the normalization in database.

ppad001

 Profile Answers by ppad001 Questions by ppad001

• Feb 27th, 2013

For perfomance optimization.
Like in case of datawarehousing operation the no of tables to be joined to get the desired output might be too high. In such a case we de-normalize to serve our purpose.

Answer Question  Select Best Answer

robindas

 Profile Answers by robindas Questions by robindas

• Jan 11th, 2013

Few steps for query tuning. 1) Check for if any sub query or exists or not exists is there if yes then try to change it in the joins 2) Try to check the way joins had been written try to put it in f...

samareshoracle

 Profile Answers by samareshoracle Questions by samareshoracle

• Aug 4th, 2012

Following a Tuning Methodology Objectives:: Determine performance problems Manage performance Describe tuning methodologies Identify goals for tuning Describe automatic SQL tunin...

Answer Question  Select Best Answer

In a table the persons name is in lower case "abc" and is there any SQL query to obtain that persons name as "ABC" as an output?

Muzeeb

• Jan 6th, 2013

Yes, using SQL UPPER function.

Code
 

Answer Question  Select Best Answer

True

Guru

• Dec 19th, 2012

True

Durgesh Kumar Singore

• Feb 7th, 2012

In SQL 2005 only != and operator perform same operation

^= does not work

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

Answered by: Sushant

• Oct 25th, 2006

---

The difference is that, Clustered index is unique for any given table and we can have only one clustered index on a table. The leaf level of a clustered index is the actual data and the data is resorted in case of clustered index. Whereas in case of non-clustered index the leaf level is actually a pointer to the data in rows so we can have as many non-clustered indexes as we can on the db.

Sameer

• Nov 1st, 2012

Now SQL SERVER 2008 onwards we can have 1 cluster index and 999 non cluster index on one table.

primarykey2000

 Profile Answers by primarykey2000 Questions by primarykey2000

• Apr 22nd, 2008

clustered index  - the index order matches the order of physically stored data.cluster index can be used on table that doent get changes frequentlyusing DML statement on cluster index column have...

Improve Answer

V.E.Rajani

• Oct 3rd, 2012

Only SELECT statement can be used in Functions. INSERT,UPDATE,DELETE are used.

Answer Question  Select Best Answer

ratnam

• Aug 3rd, 2012

How write a SQL statement to query the result set and display row as columns and columns as row?

Vasanth Kumar

• Oct 6th, 2006

The simplest way to implement this in SQL 2000/OracleSelect * from table1Create a temp table with No of columns = No of rows in table 1No of rows = No of columns in table 1and insert the data into the temp table using a loop logic.

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

nirmal1in  

 Profile Answers by nirmal1in Questions by nirmal1in

• Member Since Jan-2010 | Jan 17th, 2010

---

This can be accomplished in following way:

Example: table - emp

For First n rows:

SELECT * FROM
(SELECT empno,ename,job,row_number() over (order by ename desc) a
FROM emp) x
WHERE x.a < 5 --- say n is 5 display first 5 records

For last n rows:

SELECT * FROM
(SELECT empno,ename,job,row_number() over (order by ename) a
FROM emp) x
WHERE x.a < 5

FROM )WHERE .a<

This query can be used for finding nth row also say n = 5

SELECT * FROM
(SELECT empno,ename,job,row_number() over (order by ename desc) a
FROM emp) x
WHERE x.a = 5

deepthi

• May 17th, 2012

Code
 

Vasavi Katakam

 Profile Answers by Vasavi Katakam Questions by Vasavi Katakam

• Jul 18th, 2011

For First N Rows:

Code

1.  

For Last N Rows:

Code

1.  

Improve Answer

1. How to delete a duplicate records in a table without using rowid?
2. What is the use of Connect by clause?
3. What is the use of Connect by clause?
4. How to display "Experience of employee"?E.g. 3 years 4 months 19 days?
5. What is select statement to spe?

Muralidhar

• Apr 6th, 2012

We delete the duplicate records using level and rownum. The query is

Code
 

pravesh28

 Profile Answers by pravesh28 Questions by pravesh28

• Nov 28th, 2010

1 Delete from table_name where ROWID not in ( selectmax(rowid) from table group by duplicate_values_field_name);

Answer Question  Select Best Answer

Hi,

I have 3 files each having 2 cols
e.g
File1
empid deptid
1 100
2 200
3 200
4 100
5 300

File2
empid salary
1 10
2 20
3 30
4 40

Mark Haynes

 Profile Answers by Mark Haynes Questions by Mark Haynes

• Mar 2nd, 2012

I believe what you are looking for is a query like this:

select f3.deptname dept_name, sum(isnull(f2.salary,0)) amt_spent_each_dept
from file3 f3 left join file1 f1 on (f3.deptid = f1.deptid)
left join file2 f2 on (f1.empid = f2.empid)
group by f3.deptname
order by f3.deptname

Answer Question  Select Best Answer

Lokesh M

 Profile Answers by Lokesh M Questions by Lokesh M

• Feb 18th, 2012

Force view creates the view even if the underlying tables / referenced objects are not present. Force View are used while executing a script that has create tables and views statements or while creating a view for remote table.

Answer Question  Select Best Answer