Biswadeepak Swain

• Jun 3rd, 2015

This is not Cartesian products that one is Cartesian products. Thanks

abhi_only12000

 Profile Answers by abhi_only12000 Questions by abhi_only12000

• Jan 2nd, 2010

In Oracle we can catogrise joins in following ways -(1) Equi Join (Query having equal sign for condition)select empno, ename, dnamefrom emp join depton emp.deptno = dept.deptno;(2) Natural Join : both...

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

krishna420  

 Profile Answers by krishna420 Questions by krishna420

• Member Since Jul-2008 | Jul 23rd, 2008

---

There are 5 types of joins available in sql server

1) inner join
2) outer join( left outer join,Right outer join)
3) Full Join
4) Cross Join
5) Self Join

1) inner Join : Two tables having the common column values go with inner join.

Example:
select * from emp inner join empsalary
on
emp.empid=empsalary.empid

2) outer join:
Outer join has two sub types left outer join,Right outer join
Left outer join: Taking Left side values of the table checking into right side
select * from emp left outer join empsalary
on emp.empid=empsalary.empid
Right Outer join:Taking Right side values of the table checking left side
select * from emp right outer join empsalary
on emp.empid=empsalary.empid

3) Full join :
Full join is combined with left outer join ,Right outer join.
select * from emp full join employee
on emp.empid=employee.empid

4) cross Join: cross join is an carteasion product ,its like matrix format here it wont come on condidtion

select * from emp cross join employee

Self join :

Self join can check within the table called self join.

zunaid

• Oct 12th, 2012

Different types of joins

Natural join
Inner join
outer join
cross join
equi join
non equi join
self join

vamsi krishna devineni

• Nov 27th, 2011

Mainly we uses some joins in the real time environment.. that is 1) Inner join 2) left outer join 3) right outer join 4) full outer join 5) cross join i will explain in easy way so that u can underst...

Improve Answer

csbhaskar

 Profile Answers by csbhaskar Questions by csbhaskar

• Mar 25th, 2011

A transaction is a logical unit of database related work that contains one or more valid and executable SQL statements. A transaction begins with the first executable SQL statement and ends when it is...

bandna chaudhary

 Profile Answers by bandna chaudhary Questions by bandna chaudhary

• Dec 8th, 2009

Transaction is a logical unit of work area.

Answer Question  Select Best Answer

abhi_only12000

 Profile Answers by abhi_only12000 Questions by abhi_only12000

• Jan 2nd, 2010

SELECT ename, sal FROM (select ename,sal,dense_rank() OVER (order by sal desc) dr FROM emp) WHERE dr =n;

chirla_pavan

 Profile Answers by chirla_pavan Questions by chirla_pavan

• Sep 12th, 2008

Select * from employee where 1=(select count(*) from employee as e where employee.sal<e.sal)

Answer Question  Select Best Answer

A View can be updated/deleted/inserted if it has only one base table if the view is based on columns from one or more tables then insert, update and delete is not possible.

Maheswara Raju. Varakavi

• Aug 29th, 2016

If a view is updated, deleted , or inserted will the changes be reflected on the base table? YES--> If it is in the case of simple view (which consists only one base table). NO---->If it is in the c...

Mahendra K Garnayak

• Jun 7th, 2016

Thanks M.R. Varakavi for providing a valuable information.
could you please confirm in instead of trigger action will be performed on which table in case of join condition

Answer Question  Select Best Answer

In how many ways can I delete all the contents of a table and the entire table. Explain with syntax ?

ranadhee_85

 Profile Answers by ranadhee_85 Questions by ranadhee_85

• Feb 9th, 2011

we delete record in a table  2 ways 1.by using delete command        syntax:delet from table name where condition.     example:delete from emp where en...

mukesh chand yadav

 Profile Answers by mukesh chand yadav Questions by mukesh chand yadav

• Dec 7th, 2010

There are two(2) ways to delete recordes from a table are as follows:              1. Delete a specific record from table.   ...

Answer Question  Select Best Answer

Geek

• Feb 19th, 2018

NO there are Maximum 12 triggers

Sathiya

• Feb 19th, 2017

You can create N numbers of triggers on a table but the maximum possible types trigger can be applied is 3*2*2=12

(Insert/Update/Delete= 3, Before/After= 2, Row Level/Statement Level=2)

Answer Question  Select Best Answer

mudassir

• Mar 26th, 2014

I have created VIEW in oracle with more than one table and i tried to delete the record by using the command "delete viewname where fieldname = 3 and the record is get delete. Can you plz explain why this happed

fayaz ahmad khan

• Sep 23rd, 2013

View is used for simplicity and for security of a table in simply a query can also called a view and a stored query which is used a lot of time then it can waste our time so a view is used to reduce a time confusion

Answer Question  Select Best Answer

Kelly Bailey

• Feb 28th, 2018

For people like myself, who might not immediately recognize why we might want to use Force: 1) Not all logins have the same privileges. If the code is developed under one login, but the view is cre...

gopalakrshna

• Jul 28th, 2015

Force view can be created without containing any table in schema

Answer Question  Select Best Answer

Naveen Kumar39

 Profile Answers by Naveen Kumar39 Questions by Naveen Kumar39

• May 3rd, 2011

Delete from emp where rowid not in(select max(rowid) from emp group by empno);

SujitKr

 Profile Answers by SujitKr Questions by SujitKr

• Feb 24th, 2010

DELETE FROM WHERE rowid NOT IN (SELECT max(rowid) FROM GROUP BY <column name containing repeated datas>);AStable name: tcolumn name: ename,branchSQL:  DELETE FROM t WHERE rowid NOT IN (SELECT MAX (rowid) FROM t GROUP BY ename,branch)Sujit

Answer Question  Select Best Answer

Balakrishna12207

 Profile Answers by Balakrishna12207 Questions by Balakrishna12207

• Feb 7th, 2011

Primarykey is a combination of Unique Key and NotNull constraints.The major difference is dependence upon the query performance.One table can have only one Primarykey, But One table can have meny comb...

abinitiohari

 Profile Answers by abinitiohari Questions by abinitiohari

• Feb 6th, 2011

Primarey key does not allow null values, Unique key allows null values.

Answer Question  Select Best Answer

katgeektalk

 Profile Answers by katgeektalk Questions by katgeektalk

• Aug 26th, 2010

Select hiredate,  to_char(hiredate, 'Day')  "DAY OF THE WEEK"from scott.emporder by to_char(hiredate-1, 'D')

dj_dj_dj

 Profile Answers by dj_dj_dj Questions by dj_dj_dj

• Mar 22nd, 2010

Select to_char(hire_date, 'day')from table_nameorder by to_char(hire_date -1 ,'day');RegardsDharmendra Jaiswal

Answer Question  Select Best Answer

Bibhudatta Pand

• Jun 18th, 2019

Suppose below is the city table contains NAME SEX Bangalore FEMALE Bangalore MALE Bangalore MALE Bangalore FEMALE Bangalore MALE Bangalore MALE Hyderabad MALE Hyderabad MALE Hyderab...

Karthik K Shetty

• Jun 20th, 2016

Code
 

Answer Question  Select Best Answer

sandip.dhopat

 Profile Answers by sandip.dhopat Questions by sandip.dhopat

• Jun 9th, 2011

Select nth Row:select * from(select t1.c1, t1.c2, .... , rank(col_name) over (order by col_name) rnkfrom table_name t1)where rnk = n;To select top n rows in a order.select * from(select t1.c1, t1.c2, ...

p.mamta

 Profile Answers by p.mamta Questions by p.mamta

• Aug 30th, 2010

How to get the nth row from the table ?select distinct(Salary),* from Employee A where n=(select count(distinct(Salary)) from Employee b where b.Salary <= a.Salary);how to  select  first ...

Answer Question  Select Best Answer

Answer posted by Scott on 2005-05-25 18:30:04: TRUNCATE is a DDL command and cannot be rolled back. All of the memory space is released back to the server. DELETE is a DML command and can be rolled back.  Both commands accomplish identical tasks (removing all data from a table), but TRUNCATE is much faster.

Read Best Answer

Editorial / Best Answer

Answered by: Prangya Sahu

• Nov 21st, 2005

---

1>TRUNCATE is a DDL command whereas DELETE is a DML command.

2>TRUNCATE is much faster than DELETE.

Reason:When you type DELETE.all the data get copied into the Rollback Tablespace first.then delete operation get performed.Thatswhy when you type ROLLBACK after deleting a table ,you can get back the data(The system get it for you from the Rollback Tablespace).All this process take time.But when you type TRUNCATE,it removes data directly without copying it into the Rollback Tablespace.Thatswhy TRUNCATE is faster.Once you Truncate you cann't get back the data.

3>You cann't rollback in TRUNCATE but in DELETE you can rollback.TRUNCATE removes the record permanently.

4>In case of TRUNCATE ,Trigger doesn't get fired.But in DML commands like DELETE .Trigger get fired.

5>You cann't use conditions(WHERE clause) in TRUNCATE.But in DELETE you can write conditions using WHERE clause.

Shahida Sultana

• Mar 6th, 2014

TRUNCATE removes all rows from a table. The operation cannot be rolled back and no triggers will be fired. As such, TRUCATE is faster and doesnt use as much undo space as a DELETE.

saravanan

• Sep 18th, 2012

Delete & truncate command will delete entries from a table.. where as we can delete a single entry using delete but incase of truncate it wont be possible..

using truncate will delete the log files,buffer storage in a table permanently but incase of delete it wont

Improve Answer