About DBMS_output.Put_line( ) package
What is the maximum size of the message that we can give in DBMS_output.Putline();
The maximum size of package is 32kWe 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..
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?
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.
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.
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.
Give me good reasons why should I choose you over others.
How do you handle pressure and stress?
Has anyone asked you for help? What did you do?
BPO Career for BTech Graduates
What are my options when I do not get a job after graduation?
Provide an example of a goal that you successfully attained.
Have you gone above and beyond your job description?
What are the career opportunities available for MCA Graduates?
What is your way of building rapport with a person you just met?
How do you handle difficult situations?
Ask Interview Question?
Have Career Question?
Ask Only Career questions.