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
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
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
Hi Guys,i have an interview question. can anyone help me reg this.i have a table called "phone" and filed as "phone number" and table have values like 2489078905,2345678909now i want the result as (248)9078905,(234)5678909 into another table called phone2.
What is pragma autonomous transaction? Plz can u let me know it in a simple understandable way.Thanks in advance.Byee
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?
Latest Answer: FOR- Sql ServerCreate trigger TestTriggeron tableaNameinstead of insertasbegin transactiondeclare @aid intset @aid=0select @aid = max([columnName]) from tableNameif @aid 0--do operationcommit transaction ...
Hiii have a table which consists of 2 lakh records and numbering is not there for these records.now i want to implement numbering for those records and also to the records which are going to be inserted in future..will it be possible with sequence.if so how???
What would be the o/p for this ....declarecursor c1 is select * from employees;emp_rec c1%rowtype;beginopen c1;delete from employees;loopfetch c1 into emp_rec;exit when c1%notfound;end loop;close c1;end;tell me what is active set ?why you need cursors?and what is going to happen when you use for update clause in cursor declarationwhy use nowait clause what is its use
Hi,We have to select some rows from a table using many conditions in the where clause. Then we have to write those selected rows to one flat file. I know that we can use UTL_FILE package to do this. Is there any better approach to do this??
View page << Previous 7 8 9 10 [11] 12 13 14 15 16 Next >>
Go Top
