Interview Questions Answers in SQL PLSQL

parli jain

{ City } bangalore
< Country > india
* Profession *
User No # 89551

Total Questions Posted # 5
Total Answers Posted # 0

Total Answers Posted for My Questions # 13
Total Views for My Questions # 44534

Users Marked my Answers as Correct # 0
Users Marked my Answers as Wrong # 0

Questions / { parli jain }

Questions Answers Category Views Company eMail

Suppose There is a string A.B....C.......D.........E........F In this string dots (.) are not having fixed count in between of string. I want the output to have string with one dot between. I.e. A.B.C.D.E.F

IBM,

6 SQL PLSQL 10241

Interchange the value of a column Gender in a table where values are Male and Female. So, where the value is Male, it should changed to Female and Female to Male.

Cap Gemini, IBM,

4 SQL PLSQL 19691

What is materialised View?

IBM,

2 SQL PLSQL 5670

Give an example of Full Outer Join?

IBM,

1 SQL PLSQL 5414

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

IBM,

SQL PLSQL 3518

Answers / { parli jain }