Can any one help me on FLASHBACK concept ? What is it?

Deepika S Verma

• Mar 13th, 2014

Its a feature introduced in oracle9i where oracle DB allows user to view the content of table quickly and easily the way it was at a particular time in the past, even when it is modified and committed...

NAVEEN

• Mar 2nd, 2014

Execute dbms_flashback.enable_at_time(sysdate-5/1440);(for 5 minutes flash back )

Answer Question  Select Best Answer

What is the main purpose of RETURN in functions when we can calculate a value and pass it through using OUT mode in procedure or functions?

Deepika S Verma

• Mar 14th, 2014

Its a myth that function returns value whereas procedure does not, actually procedure also return value (i.e. 0 or 1 ) at the time of exiting which indicates the success or error. Whereas Function ret...

shivigupta

 Profile Answers by shivigupta Questions by shivigupta

• Oct 9th, 2012

create or replace procedure proc1 as begin dbms_output.put_line(Before Return Clause); return; dbms_output.put_line(After Return Clause); end; set serveroutput on; begin proc1; dbms_output.put_line(I...

Answer Question  Select Best Answer

How can we debug stored procedures in PL/SQL?

prasadkrish

• Jun 10th, 2014

In procedure function can be able to use ?if yes means give example

ram

• Jul 31st, 2013

Can any one tell how to retrieve more than one table structure at a time?

Answer Question  Select Best Answer

Ashish

• Jun 12th, 2014

You can use MERGE statements in Oracle to avoid looping through Conventional cursors. It will save lot of time

KSPRADEEP

• Oct 17th, 2012

Yes we can ..
Instead of cursor we using bulk collection or bulk binding or using %type and %rowtype

Answer Question  Select Best Answer

When use Before and After Trigger? Please any help for this one

chaithanya

• Jul 1st, 2014

Before trigger is used while performing DML operations and whereas After Trigger is used for after performing DML operations Real time Example for before trigger: in banking systems: ...

Mrutyunjay Nayak

• Jul 1st, 2014

Before Trigger is used only when u want to restrict the invalid data entry in a table.After trigger is used when u perform the operation in one table that will effect on other table.

Answer Question  Select Best Answer

Procedure also written the values using out parameter than why we need functions?

Rakesh057

 Profile Answers by Rakesh057 Questions by Rakesh057

• Jul 1st, 2014

Because procedure is pre compiler and function is not pre compiler so that the reason we go for an calculation part in function

Madhav

• Jul 1st, 2014

Procedure also written in out parameter but we can not use procedure in Sql statement.

But if we wrote function and ita cant contain DML operation then we can access this function in SQL queries.

Answer Question  Select Best Answer

bhanu priya

• Jul 4th, 2014

1. function result cache : stores the retured value in a cache and can b used again n again instead of storing it in memory.
2. continue statement : passes controle from one iteration to other rather than exiting it.
3.regexp.count is introduced.
4.dbms_parallel_execute is introduced.

Answer Question  Select Best Answer

Rakesh057

 Profile Answers by Rakesh057 Questions by Rakesh057

• Jul 19th, 2014

NO.. triggers are auto commit no need of commit or rollback

Rpradeep

 Profile Answers by Rpradeep Questions by Rpradeep

• Jul 7th, 2014

Yes we can use commit or rollback statements in trigger by using AUTONOMOUS_TRANSACTION pragma.

Answer Question  Select Best Answer

Raviteja

 Profile Answers by Raviteja Questions by Raviteja

• Aug 23rd, 2014

Instead of cursor is not there,, instead of trigger is used incase of complex views. when we use views with joins

Kumar

• Jul 25th, 2014

Its instead of trigger not cursor and it is used to apply trigger on views.

Answer Question  Select Best Answer

How to call an external-procedure from a package?

manju_kambar

 Profile Answers by manju_kambar Questions by manju_kambar

• Sep 13th, 2014

Calling procedure from other package should have following format

package_name.procedure_name;

if you are calling package in other schema, you need to create synonyms for that particular

Answer Question  Select Best Answer

What is function purity level and why we need it in PL/SQL function?

chaitanya

• Sep 19th, 2014

Any function called from an sql query will have certain side effects on database state and package variables..these side effects are classified as purity levels. there are different purity levels like 1. read no database package state 2. write no database package state e.t.c

Answer Question  Select Best Answer

What is recursive function, explain with example?

Vishant Gupta

• Oct 11th, 2014

It is function that calls itself to implement some repetitive task

VIVEK

• Sep 24th, 2014

Function is calling the same function

Answer Question  Select Best Answer

While testing a website, an image that is supposed to appear on a page does not load (for example in IE, you would see an empty box with a small red cross icon). What type of investigation could you carry out to find out what the cause of the problem is? What information would you include when raising the defect

harmeet rehal

• Oct 13th, 2014

Web testing is the name given to software testing that focuses on web applications. Complete testing of a web-based system before going live can help address issues before the system is revealed to th...

Answer Question  Select Best Answer

I have 3 tables , same no of columns ,i want to insert whole the data from all these table into a single table,which also having same no of column and the same data type.

sateeshchandra

• Oct 14th, 2014

"sql INSERT ALL INTO suppliers (supplier_id, supplier_name) VALUES (1000, IBM) INTO suppliers (supplier_id, supplier_name) VALUES (2000, Microsoft) INTO customers (customer_i...

J. Ali (PL/Sql)

• Nov 29th, 2013

INSERT INTO DYMMY (VAL)
SELECT COLUMN_VALUE val FROM table (tab_contents_nt (1, 2, 3))
UNION ALL
SELECT COLUMN_VALUE val FROM table (tab_contents_nt (4, 5, 6))
UNION ALL
SELECT COLUMN_VALUE val FROM table (tab_contents_nt (7, 8, 9))

Answer Question  Select Best Answer

How can you move the entire data from one table to another? If in same instance and in different instances, both cases?

KARTHIKA

• Nov 7th, 2014

Use the below code to perform the task

Code
 

A MOHAN KUMAR

• Nov 7th, 2014

INSERT INTO < old table > SELECT * FROM < new table > Note the table should have same column name and their respective data types as old table

Code
 

Answer Question  Select Best Answer

Why we use cursor in plsql? in same case can we use cursor or procedure?? difference between cursor , procedure and package?? is any relation between 3??

parul priya

• Nov 20th, 2014

We use cursor when we need to handle multiple rows query in plsql.

Bhanuprasad

• Nov 15th, 2014

Cursor in Plsql: When we execute sql query. The records fetched from sql query, information about sql query is stored in context memory area in oracle. so in order to access each record row by row we ...

Answer Question  Select Best Answer

How to call a Procedure in Trigger and if any exception occurs in trigger then How do we rollback it?

Ayaz Uddin

• Nov 20th, 2014

Create or replace trigger trg
after insert on emp
for each row
begin
myproc(:new.empno, :new.ename);
end;

Answer Question  Select Best Answer

sandeep

• Nov 22nd, 2014

This was used when you are going to use the cursor in more than one place with different values for the same where clause.

Answer Question  Select Best Answer

In Emp table there is a column which consists of gender (Male or Female) ? How should one

Can update the Values of Male to Female and Female to Male with a single query ?

sandeep

• Nov 22nd, 2014

I need to update in the table not to select can u guys show me how to change directly in the database

NARSIMHA

• Nov 13th, 2014

SELECT DECODE(GENDER,M,F,F,M,NULL) FROM EMP

Answer Question  Select Best Answer

Hi ,can any one tel pls what is use ofprocedures and packages? why we use can anyone tell me with one real time example

HEMA NAGARAJU

• Dec 20th, 2014

Procedures are dataobjects which are stored in a database. We can define an operation in procedure and we call the procedure many times in the application. Packages are collection of subprograms, pro...

Answer Question  Select Best Answer