-
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.
-
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.
-
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.
-
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...
-
-
-
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
-
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...
-
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
-
How can we call a function from an anonyms block?
madhuk17
- Feb 9th, 2007
We can call a function from anonymous block as a part of sql statement written in that block.eg: create or replace function fn_emp(v_empno in number)return varchar2 isbeginselect ename into v_ename fr...
rajnish123
- Dec 30th, 2006
hi,suppose a function add two number and you desire to call it from anonyms block.create or replace function f_add(a in number,b in number) return number asc number;beginc:= a+b;return (c);end;t...
-
What are the Limitations of Packages,views,procedures?What is the maximum number of subprograms inside a package?
geetha24
- Feb 9th, 2007
There is no limitation on the number of Subprograms in the package, but there is a limitation on the compiled file size in the database.
-
How to display the contents of a current record fetched in a reference cursor?
Vishakha
- Feb 17th, 2007
declare cursor v_cursor is select empno, empnm, empdept from emp where empdept = 10;begin open v_cursor; ...
geetha24
- Feb 13th, 2007
To display the cursorOPEN v_cursor FOR SELECT ename, empno, deptno FROM emp WHERE deptno = p_deptno ORDER BY ename;LOOP FETCH v_cursor INTO v_ename, v_empno,...
-
-
How to insert a music file into the database
Innila
- Mar 2nd, 2007
LOB datatypes can be used to store blocks of unstructured data like graphic images, video, audio, etc
-
Is it possible create table in procedure or function? If Not Why?
-
If there is an index including three columns A, B and C. And if we issue a query in which where clause uses only column B....will the index be useful??and what if the where clause only has coulmn A..will the index b useful??
madhaviguthula
- Mar 8th, 2007
Hi Hemant, Please go through the following code for better understanding.First, create and populate a test table with a concatenated index.CREATE TABLE test_objects ASSELECT * FROM all_objects;CREATE...
hemant.agarwal03
- Mar 8th, 2007
Hi Madhvi..How we will use that one special feature?Regards,Hemant
-
Hi all,Could anyone let me know the equivalent code in pl/sql for this java code? I really appreciate that.for (int i = 0; i < 10; i++) {if (i == 5){continue;}} thanks,kamalnayan.M
ravikumarzee@gmail.com
- Mar 8th, 2007
begin for i in 1..10 loopif i 5 then -- do stuff.end if;end loop
madhu
- Feb 9th, 2007
I hope this will work..
declare
i number(2);
Begin
for i in 1.. 10
loop
if (i ==5) then
else
exit;
end loop;
end; -
-
Suppose one table contain many identical records. Then how to delete only identical Records.
Nikhil_4_Oracle
- Mar 12th, 2007
Hey,Above?Soln is not working with tables where data is like,COL1?----------1511 *708111 *5511 *78--Here 11 Repeats 3 times fine...--Check d rowidselect rowid,col1 from nodup;ROWID?????????...
suni123
- Mar 5th, 2007
Hi,To delete duplicate rows from table EMPDELETE FROM EMP WHERE ROWID NOT IN (SELECT MAX(ROW...
-
Explain how Nested loops gets executed?
Instrument
- Mar 18th, 2007
A nested loop is a loop within a lop, an inner loop within the body of an outer one. How this workds is that the first pass of the outer loop triggers the innter which executes to completion. Then the...
PL/SQL Interview Questions
Ans