Oracle Interview Q

Replies to This Discussion

Permalink Reply by Suma K on October 12, 2011 at 10:27pm

Hi,

 

Try with below code.

 

Dim str

str = "Oracle Information System"

Arrstr = split(str, " ")

for i = ubound(Arrstr) to lbound(Arrstr) step -1

    strrev = strrev & Arrstr(i) & " "

next

msgbox strrev

 

Regards,

Suma

• ▶ Reply

Permalink Reply by Rajashekar Nallapati on October 13, 2011 at 9:47am

Thank You Suma.

Without using String functions.

• ▶ Reply

Permalink Reply by Suresh S on October 13, 2011 at 9:49am

Hi Suma,

   His question is with out using any string functions.you used split(),I think its a string function.As per query we should not use any string function rt?Can u give some clarity on this?

 

Thanks,

Suresh

• ▶ Reply

Permalink Reply by Rajashekar Nallapati on October 13, 2011 at 9:51am

Yes Suresh, you are right

• ▶ Reply

Permalink Reply by Venky Maguloori on October 15, 2011 at 4:34pm

y = Len(MyStr)
For x = y To 1 Step -1
     char = Mid(MyStr,x,1)  ' ths statement will take the one character from the string from last character                                                     to first character
     NewStr = NewStr & char  ' add above separated character to string 
Next

 

msgbox newStr

• ▶ Reply

Permalink Reply by k.vijay on October 13, 2011 at 11:54am

Hi,

 

Suma has given correct answer, split is not string function, split is array function.

 

Here i attached string functions and array functions. pls find out attachments

Attachments:

• String Functions.doc, 48 KB

• ▶ Reply

Permalink Reply by Suresh S on October 13, 2011 at 9:25pm

Hi Vijay,

  As per my knowledge split is a string function.It returns a 1-dimensional array of sub strings, does not mean its a array function.we will pass string as an argument and it returns substrings also referred as 1-dimensional arrays.In some portals I found it as array function too and in some as string function,so still looking for more clarification.

 

Thanks,

Suresh

• ▶ Reply

Permalink Reply by Rajashekar Nallapati on October 17, 2011 at 9:20am

Thank you Raghuraman

• ▶ Reply

Permalink Reply by lalit on October 17, 2011 at 12:43pm

USING PERL :

 

$str="Oracle Information System";
@arr=split(" ",$str);
foreach(@arr){
  unshift(@myNames, $_);

}

$str=join(" ",@myNames);

print $str;

• ▶ Reply

Permalink Reply by Rajashekar Nallapati on October 17, 2011 at 1:22pm

Thank you Lalit.

 

 

• ▶ Reply