ename empno deptno amar 1 10 akbar 2

Advertise your Business Here

Refer this Site

Login | Sign Up


	Ask Questions on ANYTHING, that arise in your Daily Life at FORUM9.COM

Categories >> Software >> Databases >> SQL PLSQL

Oracle Interview Questions

SQL Server Interview Questions

MS Access Interview Questions

MySQL Interview Questions

Postgre Interview Questions

Sybase Interview Questions

DB Architecture Interview Questions

DB Administration Interview Questions

DB Development Interview Questions

SQL PLSQL Interview Questions

Databases AllOther Interview Questions

Question

ename   empno   deptno
   amar         1          10
   akbar         2          20
   anthonny    3          30
   jonathan     4          40

write a procedure to dispaly the column values ina row 
separated by a
deleimiter
eg - input - select ename from emp    '|'   output - 
amar|akbar|anthony|jonathan
     input - select empno from emp     '@'  o/p - 1@2@3@4
     input - select deptno from emp    '/'     o/p  - 
10/20/30/40

Pls answer this questn.

Question Submitted By :: Lizamishra15

I also faced this Question!!

Rank

Answer Posted By

Re: ename empno deptno amar 1 10 akbar 2 20 anthonny 3 30 jonathan 4 40 write a procedure to dispaly the column values ina row separated by a deleimiter eg - input - select ename from emp '|' output - amar|akbar|anthony|jonathan input - select empno from emp '@' o/p - 1@2@3@4 input - select deptno from emp '/' o/p - 10/20/30/40 Pls answer this questn.

Answer
# 1

create a function

--concat column values

create or replace function conactfunc (query_1 in varchar2)
return varchar2
is
v_return varchar2(4000);
v_query_concat varchar2(4000);
cur sys_refcursor;
begin
open cur for query_1;

loop
fetch cur into v_query_concat;
EXIT WHEN cur%NOTFOUND;
if v_return is null then
v_return := v_query_concat;
else
v_return := v_return || '@' || v_query_concat;
end if;
end loop;
return v_return;
end;

show_err;

and then call it

select hr.conactfunc('select region_name from regions') from dual;

O/P

Europe@Americas@Asia@Middle East and Africa

Is This Answer Correct ?

1 Yes

0 No

Tina

Question	Asked @	Answers
Other SQL PLSQL Interview Questions


Can we relate two different tables from two different users in ORACLE,PL/SQL?		4
if we give update table_name set column_name= default. what will happen? its given in pl sql block.what will hapen?	iFlex	5
Which one of the following pairs of aggregate functions do you use with character fields? 1. COUNT(field) and MAX(field) 2. AVG(field) and COUNT(field) 3. MIN(field) and SUM(field) 4. AVG(field) and MAX(field) 5. COUNT(field) and SUM(field)	HCL	6
what is autonomouse transaction?	Oracle	3
Types of optimization?	Microsoft	6
Types of joins?	Microsoft	4
What cursor type do you use to retrieve multiple recordsets?	Microsoft	15
declare v_count number(8,3); v_sal scott.emp.sal%type := '&P_sal'; cursor cur_name is select sal from scott.emp where sal between (v_sal-100) and (v_sal +1000); begin v_count :=nvl(sql%rowcount ,0); if v_count = 0 then dbms_output.put_line('no records are fetch in the given sal range'); else dbms_output.put_line('There is/are '\|\|to_char(v_count)\|\| ' salaries are selected in the given range '); end if; end; in the above programm .....for any sal range ....always it shows the following message.. no records are fetch in the given sal range please find the mistake and share with me...with thansk and regards..sarao....	Satyam	3
what is the difference between implicit conversions and explicit conversions?		2
What is the difference between SQL and PLSQL	IBM	4
How to get the 3rd column(i.e all the data along with the column name)in a table?	Logica-CMG	2
What is the difference between sql/pl-sql/embeded sql?		3

For more SQL PLSQL Interview Questions Click Here


Copyright Policy \| Terms of Service \| Help \| Site Map 1 \| Articles \| Site Map \| Site Map \| Contact Us \|

Copyright © 2012 ALLInterview.com. All Rights Reserved.

ALLInterview.com :: Forum9.com :: KalAajKal.com