Interview Questions Answers in SQL PLSQL, Oracle General

srk_sqlplsql

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

Total Questions Posted # 5
Total Answers Posted # 0

Total Answers Posted for My Questions # 4
Total Views for My Questions # 14280

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

Questions / { srk_sqlplsql }

Questions Answers Category Views Company eMail

How to convert lowercase letters to uppercase and uppercase letters to lowercase in a string. (ex, AbcdEfG should convert as aBCDeFg)

TCS,

3 SQL PLSQL 6846

Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.

TCS,

Oracle General 1697

What the is the diff between local index and global index. give some example.

TCS,

Oracle General 1589

What is snapshot is too old? Give and example for better understand.

TCS,

Oracle General 1546

Can u make a synonym for deptno=10 only from emp table.

TCS,

1 Oracle General 2602

Answers / { srk_sqlplsql }