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

Answered by Scott on 2005-05-12 10:18:34: Constraints are found under the USER_CONSTRAINTS table.

amol shinde

• Apr 15th, 2016

Constraints are stored in data dictionary

Rahul B

 Profile Answers by Rahul B Questions by Rahul B

• Jun 25th, 2007

Correction to some answers aboveUser_Constraints is a view and not a table

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

How do you get back into SQLPlus to disable restricted session if you enabled.

sandeep

• Jun 30th, 2017

First of all login with sysdba,
Use the query..
Alter system disable restricted session;
this query disable restricted session

Lanie Acosta

• Aug 27th, 2015

Yes

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

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

Read Best Answer

Editorial / Best Answer

Answered by: srinivasan

• Aug 16th, 2005

---

A varchar2 datatype, when stored in a database table, uses only the space  
allocated to it. If you have a varchar2(1999) and put 50 bytes in the table, we  
will use 52 bytes (leading length byte). 
 
A char datatype, when stored in a database table, always uses the maximum length  
and is blank padded. If you have char(1999) and put 50 bytes into it, it will  
consume 2001 bytes (leading length field is present on char's as well). 
 
In the database -- a CHAR is a VARCHAR that is blank padded to its maximum  
length. 

Nitin Yadav

• Nov 9th, 2017

Char is fixed and varchar 2 is variable.

gopalakrishna

• Jul 28th, 2015

Char is a data type based on the given size memory is used
varchar2 based on the given characters memory is used

Improve 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

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

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
SELECT (SELECT COUNT(NAME) FROM TABLE_NAME WHERE UPPER(SEX) LIKE M%) AS COUNT_OF_MALE,
           (SELECT COUNT(NAME) FROM TABLE_NAME WHERE UPPER(SEX) LIKE F%) AS COUNT_OF_FEMALE
FROM DUAL;

Answer Question  Select Best Answer