ace1234567

 Profile Answers by ace1234567 Questions by ace1234567

• Mar 4th, 2015

Please find the template. Using out type parameter we can return more than one value from a function.

Code
 

shyam

• Mar 2nd, 2015

Yes, we return more than one value in function using package. Example::

Code
create package pack
is
type mul_val is record
(emp_id employees.employee_id%type,
emp_name employees.last_name%type);
end pack;

and the return type of function is that pack type.....

Answer Question  Select Best Answer

How to access cursor output from web application and present the record set in tabular form?

ace1234567

 Profile Answers by ace1234567 Questions by ace1234567

• Mar 4th, 2015

Using ref cursor and returning output in the plsql table we can return the result in tabular format.

Answer Question  Select Best Answer

What are indexes used for ? What are the different types of Indexes?

lakshmi

• Feb 20th, 2015

Index is schema object.which is an entry for each value that are appear index column.index used to give a direct access and also increase the performance .

types of indexes:

simple,composite,function based,bitmap,bit treeindex

Abhijit Musale

• Feb 18th, 2015

It is not necessary that adding an index will always help. When u have less no. of records then there is no need to add index. An index is an additional database object to improve the data i/o operations.

Answer Question  Select Best Answer

Can we give COMMIT or ROLLBACK within a trigger?

Abhijit Musale

• Feb 19th, 2015

Using PRAGMA AUTONOMOUS_TRANSACTION we can treat the child transaction as a separate transaction, committing which wont affect the parent transaction.

Tushar

• Feb 17th, 2015

No we cant used it.because it affected on logical processing. It is possible using Pragma

Answer Question  Select Best Answer

Guys can you please help me in realtime scenario?

Abhijit Musale

• Feb 18th, 2015

Whenever you want to perform some operation on a set of result of rows , then we use the cursor.Cursor is nothing but a work space allocated on the memory. When u fire a query that set of rows is stored in the cursor temporarily.

Answer Question  Select Best Answer

Abhijit Musale

• Feb 18th, 2015

To make the operations faster. When we need to do any operation on data like some calculations and when u need to fetch the data repetitively , in that case we can use the collections like PLSQL table.

Answer Question  Select Best Answer

suvijyo

• Feb 2nd, 2015

"c declare s1 char(10):=name; s2 varchar2(10):=name; begin if s1=s2 then dbms_output.put_line(both are equal); else dbms_output.put_line(both are equal); end if; dbms_ou...

chinnu

• Jan 27th, 2015

Char datatype is fixed,but it cant be reused. eq: char(10) -- elena,first 5 characters will be filled remaining field are padded.
varchar2 datatype fixed,but it can be reused. eq: varchar2(10) -- elena, first 5 characters will be filled and remaining fields are reused.

Answer Question  Select Best Answer

Eltonclardy

 Profile Answers by Eltonclardy Questions by Eltonclardy

• Jan 9th, 2015

Yes PL/SQL have different data types compared to C and C++. These two datatypes in SQL i.e scalar and composite are very mush useful in SQL.

Hema nagaraju

• Dec 20th, 2014

Scallar,composite datatypes.
scllar datatypes are varchar2,number
composite datatypes are records,tables,collections which can store multiple values at a time

Answer Question  Select Best Answer

Write a query to retrieve one entire column data of multiple rows into one single column of single row?

hema nagaraju

• Dec 20th, 2014

SELECT listagg (ename, ,) within group( order by ename) FROM emp

Geet

• Dec 4th, 2014

Code
span style="color: #F00;">"EMPLOYEE NAME"

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

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

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

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

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 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

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

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

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

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

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