SERPland Oracle, PL/SQL, PHP, Autos, Bungalow-Hotels and more …

16Oct/060

The speediest and most secure pl/sql program


You can't be faster

begin
null;
exception
when others then null;
end;

Seen my perfect exception handling?

Tagged as: , No Comments
16Oct/06Off

SQL: Remove Strings or Letters


Remove:

select TRANSLATE('12A3','0123456789', ' ') FROM dual

or

 

select
 LTRIM(RTRIM(TRANSLATE(UPPER('12a'), ABCDEFGHIJKLMNOPQRSTUVWXYZ', ' '))) as nr
, LTRIM(RTRIM(TRANSLATE(UPPER('12a'),'0123456789', ' '))) as nr_add
from dual

 

 

Tagged as: , , , , , , , , , , Continue reading
   
Custom Search

Recent Posts

Tags

Abstract Als Amp Carpal Tunnel Syndrome Cast Application Chf Compendium Computer Mouse Der Schweiz Ein Fiat Fiat Ulysse Google Google Maps Hotels Ins Kriterien legoland Legoland Park Lt Mail Medical History Mit Nun oracle Oracle 7 Oracle Database Oracle Forms Oracle Sql Oracle Toad Peugeot Php Pl Sql Repetitive Strain Injury RSI Schweiz Solution Number Sql Code Sql Oracle Sql Statement Switzerland Toad Toad Oracle Wikipedia Wrist Pain

Recent Comments

Categories

Blogroll