PL/SQL (MOSC)

MOSC Banner

Newbie: migrating a .sql file to a procedure

edited Feb 26, 2014 12:00PM in PL/SQL (MOSC) 15 commentsAnswered

Hi,

Im trying to migrate a report which runs on a local server.

This is the beginning of the report:

set termout off
alter session set nls_date_format = 'YYYY-MM-DD';
set pagesize 5000
set feed off
set markup HTML ON HEAD " -
<style type='text/css'> -
  body {font:10pt Arial,Helvetica,sans-serif; color:black; background:White;} -
  p {   font:10pt Arial,Helvetica,sans-serif; color:black; background:White;} -
        table,tr,td {font:10pt Arial,Helvetica,sans-serif; color:Black; background:#f7f7e7; -
        padding:0px 0px 0px 0px; margin:0px 0px 0px 0px; white-space:nowrap;} -
  th {  font:bold 10pt Arial,Helvetica,sans-serif; color:#336699; background:#cccc99; -

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center