what is the maximum size of the message that we can give in dbms_output.putline();

kantri

 Profile Answers by kantri Questions by kantri

• Dec 16th, 2008

The maximum size of package is 32kWe can't give  more than that

jp_valapad

 Profile Answers by jp_valapad Questions by jp_valapad

• Aug 5th, 2008

255 bytes was the size limits of earlier version of oracle..ie prior to 10 g ..in 10g 32767 byte is the limit..

Answer Question  Select Best Answer

if i am updating one record in a table at that time no other user can't able insert ,update the record in same table How is it possible

Aditya

• Feb 28th, 2018

Lock table < table name > in exclusive mode;

Smruti R Das

• Sep 26th, 2012

GRANT SELECT ON table_name TO user_name

Answer Question  Select Best Answer

Hi, What is nocopy parameter in oracle procedure. what is the use of it. In which situation,we can use the nocopy parameter.Thanks,Saravanan.P

Himansu

• Nov 6th, 2012

In procedure,Function there are three types of parameter is there. eg-IN, OUT, INOUT. IN parameter is call by reference and OUT & INOUT are call by value. Always call by reference is faster than call ...

Saket

• Apr 3rd, 2012

Pass by reference: "IN" Case
Pass by value : "Out" or "IN OUT" Case which have the overhead of copying the value to new procedure parameter.
In order to make to Pass by reference we will use NOCOPY
Pass by reference: "OUT NOCOPY" or "IN OUT NOCOPY" which deals which the actual reference value.

Answer Question  Select Best Answer

suneesece

 Profile Answers by suneesece Questions by suneesece

• May 19th, 2010

Select * from all_objects where object_type= 'PROCEDURE';

Shafik Ismail

 Profile Answers by Shafik Ismail Questions by Shafik Ismail

• Feb 27th, 2010

I am not too sure if I understand our question properly. If you wanted to find all the stored procedures defined to the database with a CREATE PROCEDURE command (let's say DB2), then run a query from ...

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

Answered by: Mohan

• Jun 2nd, 2006

---

Hi,

Advantages of views:

1. View the data without storing the data into the object.

2. Restict the view of a table i.e. can hide some of columns in the tables.

3. Join two or more tables and show it as one object to user.

4. Restict the access of a table so that nobody can insert the rows into the table.

Disadvatages:

1. Can not use DML operations on this.

2. When table is dropped view becomes inactive.. it depends on the table objects.

3. It is an object, so it occupies space.

Pls. add , if I miss any of them.

Thanks,

Mohan

Raj

• Mar 7th, 2019

These are following some advantages
1. Performance
2. Security
3. Easy and Reusable
4. Consistency and independent

Marcus

• Apr 6th, 2018

The view uses virtual space when in use, this is a temporary space on the server that goes away when not in use.

Improve Answer