Shailu

• Oct 6th, 2006

When you try to execute procedure from procedure just  write procedure name. If you  are executing from SQL*Plus them write EXEC Thanks, Shailu

Naseem

• Aug 23rd, 2006

Executing a Procedure:exec To View a Procedure:desc -- gives u only the in/out parameters used by procedure.Select text from user_source where name = ' -- gives u the whole procedure contents.

Answer Question  Select Best Answer

Vrushali

• Aug 9th, 2007

Tablespace : A tablespace is a logical structure on a Oracle database consisting of one or more datafiles. The objects are stored in a tablespace.Clusters: When two or more tables have a requirements ...

Ramco

• Oct 9th, 2006

Table space is the logical data units of a database. every database is divided into Database -> tablespace -> segments - > externsin short (tablespace is a logical group of data files in a da...

Answer Question  Select Best Answer

Ashish

• Sep 28th, 2006

Use DBMS_PROFILER to tell you exactly which lines in the PL/SQL code are taking time.

Priya

• Sep 26th, 2006

You can use DBMS_UTILITY.GET_TIME procedure.

Answer Question  Select Best Answer

How to take backup using RMAN backup, without catalogdb?

gyanudba

 Profile Answers by gyanudba Questions by gyanudba

• Jul 6th, 2011

First you connect to oracle usersu - oracle2then goto cd $ORACLE_HOME/bintype rmanRMAN> connect target;          >  backup database plus archivelog;

smmdba

 Profile Answers by smmdba Questions by smmdba

• Jul 7th, 2008

 How to connect to RMAN without catalog

Answer Question  Select Best Answer

Explain what are Oracle Catlog & Oracle Archive Log ?

jazz

• Sep 20th, 2011

When the log writer writes into the redo logs i.e online redo logs in circular motion.when one redo log is full it switches to another redo log , at this point of transfer it is called log switch.

gyanudba

 Profile Answers by gyanudba Questions by gyanudba

• Jul 29th, 2011

oracle catalog used for recovery purpose in RMAN our target database registered in catalog and storing metadata for the target database. Archivelog is also used for recovery purpose but its store red...

Answer Question  Select Best Answer

How will you find the total number of databases present in our system via LINUX OS?

Richard Naveen

• Oct 31st, 2011

Etc/oratab

subrahmanyam pattapu

• Jul 20th, 2011

We can find which databases are running in server. by using the following command.

ps-ef|grep smon

It will show the databases is up and running.

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