H.Tonguç YILMAZ Blog

Generate dynamic PDF documents from data stored in Oracle databases using the PL/PDF program package. PL/PDF is written exclusively in PL/SQL. It is able to either store the generated PDF document in the database or provide the results directly to a browser using MOD_PLSQL. No third-party software is needed; PL/PDF only uses tools provided by the installation package of an Oracle Database (PL/SQL, MOD_PLSQL). Use PL/PDF to quickly and easily develop applications with dynamic content but also quality presentation and printing capabilities.

http://plpdf.com/23-929.html

http://apex.oracle.com/pls/otn/f?p=45570:1:11182785506197957722::NO

SQL> SELECT ‘SQL IN trimmed trailing blanks!’
 2 FROM DUAL
 3 WHERE ‘CA ‘ IN ( ‘CA’, ‘US’ )
 4 /

‘TRIMMEDTRAILINGBLANKS!’
————————
SQL IN trimmed trailing blanks!

In fact, Oracle does document this behavior, from the SQL Reference:

Blank-Padded and Nonpadded Comparison Semantics

With blank-padded semantics, if the two values have different lengths, then Oracle first adds blanks to the end of the shorter one so their lengths are equal. Oracle then compares the values character by character up to the first character that differs. The value with the greater character in the first differing position is considered greater. If two values have no differing characters, then they are considered equal. This rule means that two values are equal if they differ only in the number of trailing blanks. Oracle uses blank-padded comparison semantics only when both values in the comparison are either expressions of datatype CHAR, NCHAR, text literals, or values returned by the USER function.

Steven Feuerstein
www.oracleplsqlprogramming.com

http://www.ss64.com/bash/index.html

http://news.ft.com/cms/s/7354696c-cd86-11da-afcd-0000779e2340.html

Oracle says may launch own Linux version
http://today.reuters.com/news/articlenews.aspx?type=technologyNews&storyid=2006-04-17T121729Z_01_L17720323_RTRUKOC_0_US-ORACLE.xml

Linux Muscling to the Top in Oracle Shops
http://www.eweek.com/article2/0,1759,1945810,00.asp?kc=EWRSS03119TX1K0000594

The Oracle Database XE Product Marketing Team would like to hear from you if you are using XE. If you are trying out Oracle Database XE or have some real applications running on it and would like to share your experiences – I’d encourage you to post them to the online forum (see this link for details on getting to the forum and downloading the software). http://tkyte.blogspot.com/

create or replace package Get_Precise_Time is

procedure TEnter;
procedure TEnd;

end Get_Precise_Time;
/
create or replace package body Get_Precise_Time is
initTime timestamp;

procedure TEnter is
begin
select localtimestamp into initTime from dual;
end;

procedure TEnd is
diff interval day to second;
begin
diff := localtimestamp – initTime;
dbms_output.put_line(diff);
end;

end Get_Precise_Time;
/
begin
Get_Precise_Time.TEnter;
for i in 1 .. 10 loop
null;
end loop;
Get_Precise_Time.TEnd;
end;
/

select systimestamp, localtimestamp from dual

– for nano seconds

SQL> select to_char(dt, ‘dd-mon-yyyy hh:mi:ss.ff6 AM’) from tstamp ;

TO_CHAR(DT,’DD-MON-YYYYHH:MI:SS.F
———————————
05-aug-2006 05:32:27.928000 PM

• Oracle BPEL Process Manager,
• Oracle Business Activity Monitoring (BAM),
• Oracle Business Rules Engine,
• Oracle Enterprise Service Bus,
• Oracle JDeveloper and
• Oracle Web Services Manager

http://www.oracle.com/corporate/press/2006_mar/ofm-soa-momentum.html