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

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

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

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

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

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

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

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

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

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

If changes are made to the tables which are base tables of a view will the changes be reference on the view.

Andy

• Jul 9th, 2015

You cannot associate a view with trigger

Animesh Mondal

• May 11th, 2015

The view must have the Primary Key and NOT NULL columns of the base table for any insert to happen on a view

Answer Question  Select Best Answer

It won't, Because SYSDATE format contains time attached with it.

Ashima Chhabra

• Jun 20th, 2015

No...you can save a single row with the sysdate but not more than 1 on same date because format of date is YYYY-MM-DD and format of datetime is YYYY-MM-DD hh:mm:ss[.nnn] and format of smalldatetime is YYYY-MM-DD hh:mm:ss

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 8th, 2006

yes with unique constraint on date column we can have same date becuase internally date is stored as  dd-mon-yyyy hh:mi:ss

Answer Question  Select Best Answer

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

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

Deepika S Verma

• Mar 10th, 2014

Ref Cursors are used in two conditions
(1) When we have a dynamic query, means when we get the information at runtime related to query(like column name, table name etc)
(2) Or when we want to pass whole resultset to another proc/func.

suresh reddi

• Aug 19th, 2011

Using ref cursor we can pass different values( i.e by changing parameters) to the cursor which is declared in the package specification from the package body. Ref cursors are of 2 types a) weak r...

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

Read Best Answer

Editorial / Best Answer

Answered by: Zimmy

• Jul 10th, 2005

---

ROWID is the psedo columns indicate the stored location of the data physically in the database.

Ravi

• Jul 3rd, 2013

ROWID: It is pseudo column,it has physical address location of row in ORACLE database
The format is: OOOOOO.FFF.BBBBBB.RRR
OOOOOO is the object ID
FFF is the file number
BBBBBB is the block number
RRR is the row number

vikas

• Dec 21st, 2012

But according to you it has 16 digits ... and according to my oracle 10g it is showing 18 digits. like AAAC9EAAEAAAABXAAA .. why??

Improve 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

shailendra

• Aug 22nd, 2012

You can add 1024 column in the one table.

vik_ora

 Profile Answers by vik_ora Questions by vik_ora

• Apr 17th, 2008

Hi guys I am new to Oracle. Thank you for sharing your knowledge.

Answer Question  Select Best Answer

Answer posted by Scott on 2005-05-25 18:43:29: SELECT rownum, rowid FROM sometable

Ankush Gupta

• Feb 10th, 2012

Common Pseudo columns are CURRVAL,NEXTVAL,ROWID,ROWNUM,SYSDATE etc.

laxman

• Oct 9th, 2011

Pseudocolumns are uid,user,sysdate,rownum,rowid,level,rowscn

Answer Question  Select Best Answer