Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

SQL PLSQL Interview Questions
Questions Answers Views Company eMail

What is AUTH_ID and AUTH_USER in pl/sql ?

INDUS,

2193

----> There is a table T with two columns C1 and C2. The data is as below: C1 C2 1 4 2 5 3 6

ICICI,

4 4860

Easy way to convert tableau "IF - ELSEIF" statements to Netezza "CASE" statements.

CTS,

1 2683

Write a sql to print only character form the below string. @So&*CIE%$TE@GEN!@RAL

Societe Generale,

1 3619

1. Which is an aggregate function? a. Union b. like c. max d. Rank

Fintellix,

1 3036

2. Select A.A from ( select 1 as from dual Union select 1 as from dual)A Full outer join ( select 1 B from dual Union select 2 B from dual)B On A.A=B.B

Fintellix,

2 8691

3. Select sum(a) sum_1,max(a) max_1 ,count(a) count_1 from ( ( select 1 a from dual union all Select to_number(‘2011’) a from dual union all select 1 a from dual) union select 2 b from dual);

Fintellix,

1 3134

4. Select sum(A.salary) +sum(B.salary) as TOT_SAL from ( select LEVEL emp_id,level*100 salary,case when mod (level,2)=0then 2 else null end dept_id from dual connect by level<6 )A right outer join (select level emp_id ,level*200 salary ,case when mod (level,3)=0 then 2 else null end dept_id from dual connect by level<6)B On A.dept_id=B.dept_id And A.emp_id=B.emp-id;

Fintellix,

1 2715

7. Where would you look for errors from the database design?

Fintellix,

1 3030

Whis is not false in primary key?

Fintellix,

1455

What is Histogram?

NIIT,

1558

I have following column in the table. col1 1 a b c 2 3 d and I want to display it as num chars 1 a 2 b 3 c 4 d numbers in one column and letters in another column.

IBM, Saama Tech,

1 3084

How we get all_group_function's(Sum,avg,count,max and min_value of a column(Sal) Using pl/sql anonymous block, with out using group function's. You shouldn't use more than one select statement in entire the program. Like cursor c is select * from ; except this you can't use another select statement. You can use no of variables as per requirement.

1 2507

i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

1582

What are local and global Indexes and where they are useful.

1442


Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is equi join in sql?

1073


What are the types of join in sql?

1103


What is package in pl sql?

1025


How do I make sql search faster?

995


What is nvarchar in sql?

924


how to convert character strings to dates? : Sql dba

1060


Can there be more than one function with a similar name in a pl/sql block?

985


Explain the uses of database trigger.

1115


What found sql?

944


what is offset-fetch filter in tsql? : Transact sql

947


What is rank function in sql?

1026


Can we alter stored procedure?

987


how many triggers are allowed in mysql table? : Sql dba

1071


How many columns should be in an index?

963


Why is sql*loader direct path so fast?

1103