SQL Snippets ™: Tutorials for Oracle Developers

Custom Search

Home SQL Features SQL Techniques Miscellany About Blog Site Map Search

Home

SQL Techniques
Custom Feedback Messages
	Changing the Footer
	Changing the Header and Footer
	Other Techniques
	Setup
	Cleanup

< Previous

Next >

Read Using SQL Snippets ™ before using any of this site's sample code or techniques on your own systems.

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;

Other Techniques

Cleanup

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

Ads by NSC Cards

Terms and Conditions of Use Disclaimer Privacy Policy

This page was first published on March 8, 2007.

The views expressed on this site are my own and do not necessarily reflect the views of Oracle.