About DBMS_output.Put_line( ) package
What is the maximum size of the message that we can give in DBMS_output.Putline();
How do you set table for read only access ?
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
GRANT SELECT ON table_name TO user_name
There are couple of ways 1) If there are user other than owner accessing this table then you can "grant select on TABLE_NAME" 2) Otherwise you DBA can create a role which will have only the privillege...
What is the use of nocopy parameter in Oracle procedure
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
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 ...
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.
How do you find which procedures are being used in database?
select * from all_objects where object_type= 'PROCEDURE';
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 ...
What are the advantages and disadvantages of view?
Read Best Answer
Editorial / Best Answer
Answered by: Mohan
Answered On : Jun 2nd, 2006Hi,
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
View when called always contacts the base table, on which it is built to get the data .so it always goes to the server thats why it degrades the performance of the server.
DML operation can performed on views.
User Panel
Categories
Interview Coaching
Interview Question
Career Counselling
NH
The maximum size of package is 32k
We can't give more than that
255 bytes was the size limits of earlier version of oracle..ie prior to 10 g ..in 10g 32767 byte is the limit..