Not Just Databases

Reverse function in oracle December 9, 2009 - (0)

SQL> select reverse(‘sriram oracle DBA’) from dual; REVERSE(‘SRIRAMOR —————– ABD elcaro marirs As this reverse funcction is undocumented we can achive the same using a procedure…….. SQL> create or replace procedure rev(x in varchar2) as 2 c char(1); 3 i number; 4 begin 5 for i in 1..length(x) loop 6 select substr(x,length(x)-i+1,1) into c from […]
SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled December 4, 2009 - (1)

Mobile Site | Full Site