Answer / agrawal_vivek

easiest way is to use the condition-

for(i=0;s[i]!='';i++)
{
if(s[i]>=65 && s[i]<=90) //Caps ASCII-65-90(60+32=97-----90+32=122)
s[i]=s[i]+32;

if(s[i]>=97 && s[i]<=122) // Small ASCII-97-122(97-32=65-----122-32=90)
s[i]=s[i]-32;
}

Answer / kunal

SELECT listagg(newstr) within GROUP (
ORDER BY rm)
FROM
(SELECT
CASE
WHEN SUBSTR('AbcdEfG',level,1)=upper(SUBSTR('AbcdEfG',level,1))
THEN lower(SUBSTR('AbcdEfG',level,1))
ELSE upper(SUBSTR('AbcdEfG',level,1))
END newstr,
rownum rm
FROM dual
CONNECT BY level <=LENGTH('AbcdEfG')
)

Answer / debashis mohanty

Select 'AbcdEfG',LOWER(SUBSTR('AbcdEfG',1,1))||UPPER(SUBSTR('AbcdEfG',2,3))||LOWER(SUBSTR('AbcdEfG',5,1))||UPPER(SUBSTR('AbcdEfG',6,1))||LOWER(SUBSTR('AbcdEfG',7,1)) From Dual

function can return value ,procedure also return value through out parameter then what is the difference?

3 Answers   3i Infotech,

---

What are inner outer left and right joins in sql?

0 Answers  

---

Can we use commit inside a trigger?

0 Answers  

---

difference between cursor and procedure in a package

3 Answers   PCS,

---

What are the different dml commands in sql?

0 Answers  

---

What is Pragma EXECPTION_INIT ? Explain the usage ?

2 Answers  

---

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

0 Answers  

---

What is foreign key sql?

0 Answers  

---

write an sql query to find names of employee start with 'a'? : Sql dba

0 Answers  

---

What is the difference between sql and t sql?

0 Answers  

---

Can i use Commit inside the Trigger? Suppose i use commit what will be happy (it's complied /executed/work)

6 Answers  

---

How can one get sql*loader to commit only at the end of the load file? : aql loader

0 Answers  

---