Home » SQL & PL/SQL » SQL & PL/SQL » Equivalent of set commands in oracle.....?
Equivalent of set commands in oracle.....? [message #241944] Thu, 31 May 2007 02:42 Go to next message
lokhande.dinesh29
Messages: 36
Registered: May 2007
Member

Hi all,

i want to know the equivalent in oracle for all these set commands(in Teradata):

1. set footing
/*Footing Specifies the footer text string that appears at the bottom of each page of a
report.*/

2. set formchar on
/*Provides format control and to specify form feed characters for printing reports. OFF is default for network-attached operating systems.*/

3. set PAGEBREAK
/*Ejects a page whenever the value for one or more specified columns changes.
SET PAGEBREAK ON 1;*/

thanks & regards,
dinesh

Re: Equivalent of set commands in oracle.....? [message #241949 is a reply to message #241944] Thu, 31 May 2007 02:57 Go to previous messageGo to next message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Take a look at the SQL*Plus reference manual. You are looking for:

BTITLE
SET PAGESIZE
SET NEWPAGE
BREAK

Ross Leishman
Re: Equivalent of set commands in oracle.....? [message #241952 is a reply to message #241944] Thu, 31 May 2007 03:02 Go to previous message
Michel Cadot
Messages: 64098
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Have a look at SQL*PlusŪ User's Guide and Reference and especially chapter 12 SQL*Plus Command Reference.

1. BTITLE
2/3. No equivalent, but "clear screen" jump to the top of next page.

Commands are different but you surely can do the same thing in another way.
You'll never find a one to one correspondance when you switch from a system/software to another one.

Regards
Michel
Previous Topic: teradata rollback functionality in oracle
Next Topic: problem in enabling and disabling constraints
Goto Forum:
  


Current Time: Fri Dec 02 12:43:16 CST 2016

Total time taken to generate the page: 0.09885 seconds