If in PL/SQL Autonomous transaction, you get error then how will you role back the main transaction?

Mohammad Jarwan

• Apr 9th, 2012

Used in table trigger to execute update statement for same table.

dhiren21

 Profile Answers by dhiren21 Questions by dhiren21

• Sep 20th, 2009

Before this Ask a Question to your Self... What are you Updating?When You Updated this?How you are updating?Then? Check the Commit?Point if commited not possible to rollback normally.Steps :::? Restor...

Answer Question  Select Best Answer

madhupriya.nukala

 Profile Answers by madhupriya.nukala Questions by madhupriya.nukala

• Sep 18th, 2008

When the session close,it will lose the data.

soumya_2003

 Profile Answers by soumya_2003 Questions by soumya_2003

• Jul 8th, 2008

The temporary tables retains data till the application referencing it, is active and running.

Answer Question  Select Best Answer

tinku981

 Profile Answers by tinku981 Questions by tinku981

• Jun 14th, 2013

We need to use triggers whenever we wish to perform an automatic operation on a DML query. In our organization we have Unix and OpenVMS servers. Due to some reason, Unix server is used to send and re...

talktobishu

 Profile Answers by talktobishu Questions by talktobishu

• May 20th, 2013

We use trigger when we want some event should happen automatically on certain desirable scenario. Lets take an example. You have a table which changes frequently,now you want to know how many times a...

Answer Question  Select Best Answer

Can you explain What is DUAL table in Oracle?

ashish88

 Profile Answers by ashish88 Questions by ashish88

• Jun 11th, 2008

hello  dual is a table which is created by oracle along with the data dictionary. It consists of exactly one column whose name is dummy and one record. The value of that record is X. sql> desc...

parthokonar

 Profile Answers by parthokonar Questions by parthokonar

• Apr 19th, 2006

Hi,Actually what happens when we issue create database command, Oracle automatically creates the tablespace and tables using the sql.bsq script found in the $oracle_home/rdbms/admin directory this scripts the dual table and is owned by the sys and has one column and one row.

Answer Question  Select Best Answer

pramod

• Oct 22nd, 2007

In the above code '-2' specifies that the only two digits before the decinmal points needs rounding up.and '+2' would mean two digits after the decimal point.

sudheer_ml

 Profile Answers by sudheer_ml Questions by sudheer_ml

• Apr 26th, 2006

as in u'r comment second prameter is negative,so it will count 2 digit from decimal point to left side .i.e 23 this 23 is less than 50 so it will round it zero.if u take above 50 it will round it to 1...

Answer Question  Select Best Answer

Rajeshwaran

• Oct 9th, 2006

 Hi sunitha,         The difference between oracle 8 and oracle 8i is that 8i supports for Internet related technologies..that is it supports for XML this feature is supplied in oracle 8i by a package named DBMS_XMLGEN .

rajat utreja

• Sep 4th, 2006

Hi thats a pretty easy question as much i knowthe version oracle8 is ORDBMSwhereas oracle8i is OIRDBMSthat means oracle8i includes certain ( I )internet features as well.contact :09868082850rajat

Answer Question  Select Best Answer

Jp

• May 25th, 2014

Lister is Network Service to establish connection between client machine and server .

Lister are stored at server side .Each lister listen to client request and establish connection.

Innila

 Profile Answers by Innila Questions by Innila

• Dec 4th, 2006

Oracle uses all three files (tnsnames.ora, sqlnet.ora, listener.ora) for network configuration.tnsnames.ora A tnsnames.ora file maps net service names to connect descriptors. In simple words, tnsnames...

Answer Question  Select Best Answer

KAMRANSAJID

 Profile Answers by KAMRANSAJID Questions by KAMRANSAJID

• Sep 21st, 2007

Crystal Report supports to create report from third party database, Oracle Report supports to create report from Oracle Database only.

najeebasghar

 Profile Answers by najeebasghar Questions by najeebasghar

• May 11th, 2007

Crystal Report is third party tool to develop different types of reports, just to connect database which are oracle , ms sql 2000 and ms access etc where as Oracle report is specially used for oracle data base

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

Answered by: thiru

• Jun 25th, 2014

---

Using for low cardinality purpose

meera

• Apr 27th, 2015

Indexes in general speeds up the data retreival from database. Generally the index we use in OLTP or the operational database is B-Tree index. But, Bitmap index is very much important in case of data...

thiru

• Jun 25th, 2014

Using for low cardinality purpose

Improve Answer

Punithavel

 Profile Answers by Punithavel Questions by Punithavel

• Mar 3rd, 2009

1. Checking from O/S levelps -ef | grep pmon2. Checking through connectivitysqlplus apps/apps3. Checking the listener. (Listener can run even without DB startup) but without listener we cant connect to DB from outside of server.

shubhendu_gupta

 Profile Answers by shubhendu_gupta Questions by shubhendu_gupta

• Sep 24th, 2007

ReshmaAt OS level you can check for Oracle background process (SMON, PMON) are running or not using the Unix command (ps -ef)Eg:1) ps -ef |grep smon2) ps -ef |grep pmonYou can check for your listener also like this ps -ef |grep -i listener

Answer Question  Select Best Answer

How its helps? Why we go for Conceptual Model?

vivekanand

• Dec 9th, 2013

Conceptual modeling is the very first level of data modeling once gathering the Business requirements. It tells about only the Entity and attributes , not the relations(constraints) or physical tables...

Sheraz Baig

• Dec 3rd, 2013

When we talk about Conceptual Model , so we definitely mean the High Level of information. Unlike Physical Model, Conceptual model doesn't discuss the data, but it discuss the process. as we told its ...

Answer Question  Select Best Answer

You have a very large query say of 2000 lines. How would you check if the indexes are being used or not. Would you read all the lines of explain plan in plan table to get it? If yes, will it be feasible? Do you have any other method of checking this?

raghuvir Khanna

• May 10th, 2012

We can moniter the use of indexed with the help of view V$object_usage simple we need to use
Alter index monitoring usage;
select tablename,indexname ,used from V$object_usage ;

Sam

• May 7th, 2012

Check and resolve join with the largest cost

Answer Question  Select Best Answer

In order to 'Compute Sum' clause in the SQL reports which of the following is mandatory1) Break on 2) Order by 3) Set page size 4) Set feedback

tinku981

 Profile Answers by tinku981 Questions by tinku981

• Jun 14th, 2013

Break and compute are required, but for spooling output you should be using all the another 3 functions.

Gaurav Saxena

• Apr 24th, 2013

Break on is compulsory for compute function.

Answer Question  Select Best Answer

In which format redo log files stores the changes ?

parthokonar1

 Profile Answers by parthokonar1 Questions by parthokonar1

• Feb 17th, 2009

Good Question. They are not stored in binary format , but in sql.

dheerajdba

 Profile Answers by dheerajdba Questions by dheerajdba

• Aug 7th, 2008

Binary-format

Answer Question  Select Best Answer

Query 1.
SELECT sal FROM emp e WHERE sal < any (SELECT sal FROM empWHERE empno=e.mgr)
(o/p:11 row)
Query 2.
SELECT SAL FROM emp e WHERE sal < any (SELECT sal FROM empWHERE mgr=e.empno)
(o/p:1 row)
What is the difference between the above 2 queries.

sen_sam86

 Profile Answers by sen_sam86 Questions by sen_sam86

• Aug 27th, 2009

How this query is possible i dont know, how the emp number and manager number will be same, i think the query in meaning less r am not understanding properly i dont know,,,, Let some one explain this...!

todeepakmalhotra

 Profile Answers by todeepakmalhotra Questions by todeepakmalhotra

• Sep 30th, 2008

These both are correlated subqueries.In the first one, we are knowing the salaries of employees who are earning less than there manager.In the second one we are knowing about the salaries of?managers who are earning less than their employees whom they manage.

Answer Question  Select Best Answer

MERGE INTO SAS F USING (SELECT PRODID, PRODID+10 F, DESCRIP FROM PRODUCT) L ON (F.PRODID=L.PRODID) WHEN MATCHED THEN UPDATE SET F.PRODID=L.F WHEN NOT MATCHED THEN INSERT VALUES (L.F, L.DESCRIP)Why does the above give error?

debjit20

 Profile Answers by debjit20 Questions by debjit20

• Apr 5th, 2010

The Error will be:Columns used in ON condition cannot be used in UPDATE.You cannot update the same column which you are using in the ON clause.

Lakshmi84

 Profile Answers by Lakshmi84 Questions by Lakshmi84

• Aug 12th, 2009

I think Error lies in the following statement INSERT VALUES (L.F, L.DESCRIP) THE STATEMENT SHOULD BE LIKE THIS  INSERT (F.PRODID,F.DESCRIP)VALUES(L.F,L.DESCRIP)

Answer Question  Select Best Answer

A table which consist of atleast one primary or Unique key is called as Parent Table.
True / False (Justify)

psingla

 Profile Answers by psingla Questions by psingla

• Apr 20th, 2010

Parent tables: are tables that are referenced(foreign key) by at least one table(child).As foreign key can reference only primary or unique key,so the only tables containing any of these keys can be parent keys.

taraldesai

 Profile Answers by taraldesai Questions by taraldesai

• Feb 23rd, 2009

Wrong and RightDepends how you take it. If i have emp table without primary key and i search dept table through emp id. Then this would be wrong. So, depends how you take it all i say is it's not verdict but it's an concept

Answer Question  Select Best Answer

Explain what are system tablespace and default tablespace? How do they differ from one another?

taraldesai

 Profile Answers by taraldesai Questions by taraldesai

• Mar 4th, 2009

System for oracle oracle metadata and default for when you create any user without providing any default tablespace clause will use this tablespace for objects

Punithavel

 Profile Answers by Punithavel Questions by Punithavel

• Mar 3rd, 2009

System Tablespace is the default tablespace for Oracle Database where it will store all the database dictionaries and DB related TablesWhereas Default tablespace is the tablespace created for each user.

Answer Question  Select Best Answer

How does a stand alone procedures differ from that of other procedures?

ayansmile07

 Profile Answers by ayansmile07 Questions by ayansmile07

• Mar 24th, 2010

These are the 4 differences between a Stand Alone Procedure and a Packaged ProcedureCreation - A standalone procedure is created using the CREATE PROCEDURE statement. A packaged procedure is created a...

macca

 Profile Answers by macca Questions by macca

• Mar 5th, 2009

Stand Alone Procedure is not part of an Package.

Answer Question  Select Best Answer

How to find out how much space a tablespace has remaining?

aravindhreturns

 Profile Answers by aravindhreturns Questions by aravindhreturns

• Apr 22nd, 2010

The total size of the tablespace can be determined through DBA_DATA_FILES. Likewise, free size of the tablespace can be determined through DBA_FREE_SPACE. So you can simply do this, Subract you can si...

gopal_1980

 Profile Answers by gopal_1980 Questions by gopal_1980

• Apr 6th, 2010

We can get tablespace free space from DBA_FREE_SPACE

Answer Question  Select Best Answer