How to check errors from plsql package not by log file not by "show err"from sql * plus provided concurrent program name

prakash

• Jun 8th, 2015

Using dbms_utility.format_error_mask function will be used to get errors from that package.

Karthik Sai

• Feb 2nd, 2015

Using exception / dbms output are the best and easier methods

Answer Question  Select Best Answer

anjum

• May 1st, 2015

When update statement fires data will be loaded into buffer from data files and keeps the old image into undo tablespace and modifies the data in buffer once you commit modified data will be written to data files if you rollback data from undotablespace it will read and writes to the data files.

premk

 Profile Answers by premk Questions by premk

• Dec 23rd, 2009

When a user issues a update statement the server process checks for weather the same type of command is executed recently or not if that command is executed very recently then it directly proceed to t...

Answer Question  Select Best Answer

Samudrala

• Jan 30th, 2015

ANY The ANY comparison condition is used to compare a value to a list or subquery. It must be preceded by =, !=, >, ANY (2000, 3000, 4000); EMPNO SAL ---------- ---------- 7...

Samudrala

• Jan 30th, 2015

ALL The ALL comparison condition is used to compare a value to a list or subquery. It must be preceded by =, !=, >, ALL (2000, 3000, 4000); EMPNO SAL ---------- ---------- 783...

Answer Question  Select Best Answer

Vijay Shewale

• Sep 11th, 2014

The reason behind char is still in oracle that is some of the table and objects are stored in oracle in char data types. to support that data types for that it is still in oracle. one more thing that ...

Paras

• Feb 23rd, 2013

To Provide backward compatibility. i.e. program written in older version of Oracle might have CHAR used in it. The newer version should be compatible with it. Thats why CHAR is still there in Oracle ..

Answer Question  Select Best Answer

rc

• Aug 15th, 2014

CONSTRAINTS:= 1.it will check the existing data and feature data. 2.we cant change the constraint behavior these are predefined. 3.constraint are not support the object tables. 4.constraints can crea...

vishnuvardhanarao

• Nov 14th, 2012

Check constraints it cant work multiple tables

Answer Question  Select Best Answer

What is the function BASECONV.CONVDATA(FILED_01,ARG_1,ARG_2) used for ?

nagarjuna

• May 2nd, 2014

Baseconv.convdata is the conversion of some encrypted data to numeric data. the conversion values depends on the arguments u are passing for the function

Answer Question  Select Best Answer

I have a request about adding new application at existing oracle 11gr2 database.

What questions should I raise with the vendor about there application and database setup requirements. Please give my answer at your earliest possible time, because my nagement waiting for the answers.

Thanks in advance.
Ibrahim

What are the ways tablespaces can be managed and how do they differ?

Affrayam

• Mar 8th, 2013

The difference between LMTS & DMTS is if the extent management is local(LMTS) the information about free extents and free blocks will be maintained in DATAFILE HEADER it self AND if the extent managem...

ashdba

 Profile Answers by ashdba Questions by ashdba

• Sep 5th, 2010

Tablespace can be managed by specifying Extent management local or Extent management dictionary, segment space management auto or manually by using the key words pctfree, pctused, pctincrease during tablepsace creation.

Answer Question  Select Best Answer

What is the role of Referential Integrity Constraint in Normalization?

surendra

• Jan 31st, 2013

Best examples of Referential Integrity constants Primary Key And Foreign key. Primary Key constraint allow a particular attribute to be not null and unique. Where as Foreign key will be used when ever there is a need to maintain the same attribute values in the multiple tables.

Answer Question  Select Best Answer

1) How to create login page in oracle 10g forms.

2) How to create an exe file of oracle 10g database

Sarat Teja

• Jan 5th, 2013

The login credentials will be requested at the time when you run a form on runtime of developer suit, that particular fmb/fmx is usually known as the login form or the master form from which a menu mo...

Answer Question  Select Best Answer

My query was running fine till last month. the query will run for each month end. suddenly it is taking more than 20 minutes for running. the data is increased by 1 million. the index are all working fine . There is no cpu utilization time and also no memory blocks. What may be the reason?The increase in data has happened previous months also

shams756

• Nov 2nd, 2012

1) Try collecting Statistics
2) Spilt your query based on incoming unique values

Avi

• Sep 25th, 2012

Check for the bottle necks starts from the source and continue till target

Answer Question  Select Best Answer

In which scenario we can use primary and unique key in same table???????

abinay

• Oct 6th, 2012

the combination of unique key and not null key is called primary key. In a table we use only one primary key.It is unique,it cant allow the null values. UNIQUE key ,in a table we use more than one un...

Answer Question  Select Best Answer

What happens when a query is submitted in oracle? Please give the complete flow as to which all processes act and how the data is submitted / retrieved to / from the database .

himanshu

• Sep 27th, 2012

1. RDBMS checks if a copy of the parsed SQL statement exists in the library cache. If parsed copy exists, then steps 2 to 6 are skipped. 2. RDBMS validates the syntax of the statement. 3. RDBMS ensure...

Chittaranjan Kotian

• May 16th, 2012

A query is first checked for semantics, and is then parsed. Parse can be hard parse or soft parse. Oracle will check if the parsed statement exists in the library cache. If it exists the existing stat...

Answer Question  Select Best Answer

lipika mishra

 Profile Answers by lipika mishra Questions by lipika mishra

• Aug 22nd, 2012

1.CHAR should be used for storing fix length character strings. String values will be space/blank padded before stored on disk. If this type is used to store varibale length strings, it will waste a l...

lina

• Aug 22nd, 2012

1.CHAR should be used for storing fix length character strings. String values will be space/blank padded before stored on disk. If this type is used to store varibale length strings, it will waste a l...

Answer Question  Select Best Answer

What is a collection of privileges?

hari kumar

• Aug 2nd, 2012

Its role .... we can assign a role like manager , etc , collection of privs is known as role

BBBB

• Apr 19th, 2012

Collecting the access

eg: insert,select,update

in this group the user can apply only the above operation on the tables.

Answer Question  Select Best Answer

Aaryan

• Jul 25th, 2012

Use ALTER TABLESPACE ADD DATAFILE statement to add one or more
files to the tablespace indicated.

Daid

• Aug 20th, 2007

Please Set the Undo Tablespace management auto and scope is memory and then try to do?Thanks?

Answer Question  Select Best Answer

Display list of jobs, number of employees of each job from departments 10 and 20. List only records if number of employees in each jobs are more than 1.

DURGAPRASAD

• Jul 23rd, 2012

SELECT JOB,COUNT(EMPNO) AS NOOFEMP FROM SCOTT.EMP WHERE DEPTNO IN (10,20)
GROUP BY JOB HAVING COUNT(EMPNO) > 1

Answer Question  Select Best Answer

What do you mean by Force View?

asit

• Jun 9th, 2012

Force view is the process to create a view forcefully without a base table. syntax:

Code
 

Answer Question  Select Best Answer

Which system tables contain information on privileges granted & privileges obtained?

asit

• Jun 9th, 2012

For users permissions : user_tab_privs table is used.
for viewing all permissions : all_tab_privs

Answer Question  Select Best Answer

How can we know the all tables and views that are given for the specific user(such as USER_VIEWS,USER_OBJECTS etc.)?

asit

• Jun 9th, 2012

Data dictionary is nothing but the place holder which contains all information of the object

like name,type,size,owner,permissions etc.

some data dictionaries : user_views,user_mviews, user_tabs, user_sequences, all_objects etc

harshljica

 Profile Answers by harshljica Questions by harshljica

• Sep 2nd, 2009

Open dba_objects in that open column name owner, in that mention user name?and it will display the list of tables and views of specific users.

Answer Question  Select Best Answer