-
Hi,Can somebody please answer couple of my questions ASAP?1) How do you call a trigger on a table?2) What is the maximum number of data strings that can be returned through DBMS_OUTPUT?Much thanks!!
madhuk17
- Feb 8th, 2007
Hi,I think trigger is not called.The code in the trigger defines the action the database needs to perform whenever some database manipulation (INSERT, UPDATE, DELETE) takes place.I think maximum number of data strings that can be returned through DBMS_OUTPUT is 255 bytes.
gchandra_sekar
- Feb 7th, 2007
Hi!) Trigger cannot be called as it automatically gets activated once u touch the table.2) Prior 10g user SQL> set serveroutput on size 1000000 or if it is 10gORA10GR2> set serveroutput on size unlimited
-
1.what is difference between pl/sql table and records?2. what is the advantages of pl/sql table?3. what is ref cursor? what is the advantages of ref cursor
srini
- Feb 6th, 2007
Actually explicit cursor refers only one work area in memory,incase of ref cursor refers different work areas in memory.
ranjeetapegu
- Jan 12th, 2007
Difference between Pl/sql tables and record is that in pl/sql tables we can store more than one row whereas in record we store only one row.TYPE rec_emp is RECORD( ename varchar2(10), empn...
-
row level,statement level,before,after,insert,update,delete 3*2*2 total 12 types.
and can i even mention instead of triggers,database trigger and schema triggers">If anyone asks in interviews, about "what are the types of triggers" then my ans is likerow level,statement level,before,after,insert,update,delete 3*2*2 total 12 types.and can i even mention instead of triggers,database trigger and schema triggers
-
-
-
Hi all if i can assign any value to the out parameter in procedures .... like i had created this procedure ...CREATE ORE REPLACE PROCEDURE MODETEST ( PARAMETER OUT NUMBER)ISJUSTTEST NUMBER :=20;BEGINPARAMETER :=JUSTTEST ; *HERE I ASSIGN VALUE TO OUT PARAMETER *JUSTTEST := PARAMETER;dBMS_OUTPUT.PUT_LINE(JUSTTEST);END; AND THE PROCEDURE IS CREATED WITHOUT ANY ERROR BUT I THAUGHT THE OUT PARAMETERS ARE WRITE ONLY AND WE CANT ASSIGN ANY VALUE TO IT ....
Brajesh Singh Bhadoriya
- Jan 15th, 2007
hi...actually the IN parameters are the read only parameters hence we can't assign any value to them but for out parameters its not true, as we can assign value to OUT parameters. so the procedur...
-
Can we create a table using with Procedure or Function?wat is the Mutating trigger error?
sankari
- Jan 9th, 2007
We can do as shown below... in the same way we can drop the table..
DECLARE
BEGIN
EXECUTE IMMEDIATE 'create table employee(empno number(3),ename varchar2(10))';
END;
gangadharam.p
- Dec 26th, 2006
HI, table can be created by using either dbms_sql or EXECUTE_IMMEDIATE in procedure or function.
-
table is also there "phone" with phoneno as a field but table is empty.now i want the result into table2.
got it, Right!
Let me know if u have any questions.
thanks.
dev
">Hi all,thank u for ur answers.and i have an adjustment in this question.actually data is not present in a table, it's there in some file.For eg. "Data" is the file, it contains information: 2489078905,2345678909 and so on...table is also there "phone" with phoneno as a field but table is empty.now i want the result into table2.got it, Right!Let me know if u have any questions.thanks.dev
gangadharam.p
- Jan 6th, 2007
Hi, write a control file to dump the data from file to table using SQL*LOADER or use UTL_FILE to do the same.
-
Dear friend, my question is assume that we have created on table,on that table we are creating one view and one synonym know i have drop the table then status of view is invalid but status of synonym is not invalid pls give me the answer
gangadharam.p
- Jan 6th, 2007
hi, when u do so the view gets error and synonym becomes invalid. If u create a table again with same name but with different cols the synonym will work but view wont.bcz view is the stored...
raghgu
- Nov 16th, 2006
Hi friend, As per RDBMS rule we cannot have invalid synoym, but we can have a invalid view.
-
Example:
declare
cursor CSRtest is
select *
from emp
for update of lastname;
begin
for i in CSRtest loop
...do something
...call procfedure with "commit"
update emp set lastname = "..."
where current of CSRtest;
endloop;
Results in "ORA-01002: fetch out of sequence" because curser is closed after "Commit"
How to "save state of curser" ?
Any workaround?">How to run a curser for update "with hold2 in PL/SQL ?Example:declarecursor CSRtest is select * from emp for update of lastname;beginfor i in CSRtest loop...do something...call procfedure with "commit"update emp set lastname = "..." where current of CSRtest;endloop;Results in "ORA-01002: fetch out of sequence" because curser is closed after "Commit"How to "save state of curser" ?Any workaround?
gangadharam.p
- Jan 5th, 2007
Hi, It is very good query u asked.The work around is, it is not advisable to use a COMMIT inside the loop as it invalidates the cursor which is declared for update.If u want to use commit then d...
-
-
-
-
We have on delete cascade in Oracle but we don’t have on update cascade. If you compare Oracle with SQL Server in SQL Server we have the option called on update cascade but In Oracle we don’t have this option why? Please can you just clarify my doubt?
jamesravid
- Dec 12th, 2006
There is no "update cascade" functionality in oracle. But you can develop your own code to achieve this. The source code is also available in this urlhttp://asktom.oracle.com/tkyte/update_cascade/index.html
-
How can I create a new table by using other two table's values.
rampratap409
- Dec 9th, 2006
create table new_employeesas (select e.employee_id, e.first_name, e.last_name, d.department_name, d.department_id,c.location_id, c.city from employees e, departments d, locations cwhere e.department_id = d.department_idand d.location_id = c.location_id);
Shree
- Oct 12th, 2006
Create table table_name as( select tab1.column1,tab1.column2,tab2.column3 from table_name tab1,table_name2 tab2 where tab1.colum1=tab2.column4);
-
-
-
-
-
PL/SQL Interview Questions
Ans