Custom Feedback Messages

Setup

Run the code on this page in SQL*Plus to create the sample tables, data, etc. used by the examples in this section.

Be sure to read Using SQL Snippets ™ before executing any of these setup steps.

create table t
( 
  key number(5)    ,
  c1  varchar2(6)  ,
  c2  varchar2(10) ,
  c3  date         ,
  c4  number
);

insert into t values ( 1, 'X', 'AAA'  , date '2005-04-03', 3000 );
insert into t values ( 2, 'Y', 'BB'   , date '2006-05-04', 2000 );
insert into t values ( 3, 'Y', 'CCCC' , date '2007-06-05', 4000 );
insert into t values ( 4, 'Y', null   , date '2008-07-06', 0    );
insert into t values ( 5, 'Y', 'DDDDD', null             , 5000 );
insert into t values ( 6, 'Y', null   , null             , null );

commit;

 



Linking to SQL Snippets ™

To link to this page in Oracle Technology Network Forums or OraFAQ Forums cut and paste this code.

  • [url=http://www.sqlsnippets.com/en/topic-11846.html]SQL Snippets: Custom Feedback Messages - Setup[/url]

To link to this page in HTML documents or Blogger comments cut and paste this code.

  • <a href="http://www.sqlsnippets.com/en/topic-11846.html">SQL Snippets: Custom Feedback Messages - Setup</a>

To link to this page in other web sites use the following values.

  • Link Text : SQL Snippets: Custom Feedback Messages - Setup
  • URL (href): http://www.sqlsnippets.com/en/topic-11846.html