CREATE OR REPLACE PACKAGE XX14_SO_INBOUND_PKG AS PROCEDURE main ( x_errbuf OUT NOCOPY VARCHAR2 , x_retcode OUT NOCOPY NUMBER , p_data_file_path IN VARCHAR2 ); END XX14_SO_INBOUND_PKG;

In above procedure what is the use of NOCOPY...?

Sasirekha

• Jan 8th, 2018

NOCOPY is used to pass the out variables also by reference

Answer Question  Select Best Answer

How to insert records into Oracle db table if I got error while inserting 4th record then how to insert 5th,6th.... records continuously

Sunil Borra

• Sep 6th, 2018

I am pretty sure that unless you correct the 4th rec or remove it altogether from all the other inserts you would not make past the 4th insert. How are you inserting the data by the way?

Answer Question  Select Best Answer

How to find out the max high value using varray?

Kaushik Nayak

• Jan 19th, 2018

Code
 

Answer Question  Select Best Answer

gyanudba

 Profile Answers by gyanudba Questions by gyanudba

• Jul 29th, 2011

We can not delete responsibillity but we can disable the responsibility from user so that user can not use this resp he is not authorised to use particular responsibility.

psicre

 Profile Answers by psicre Questions by psicre

• Jul 22nd, 2010

You cannot delete reps in EBS....

Answer Question  Select Best Answer

aStewart

 Profile Answers by aStewart Questions by aStewart

• Feb 23rd, 2010

The index status can be found in the dba_indexes, dba_objects, or the equivalent  user_ view. The possibilities are VALID, INVALID, UNUSABLE, or N/A.  Invalid or unusable indexes will not be...

Asim Jamal

• Apr 13th, 2006

The current status and details of an index could be accessed by system table sys.dba_indexes. The status could be VALID,INVALID,N/A.The invalid indexes unnecessarily occupies the space in a Tablespace.

Answer Question  Select Best Answer

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