SQL Language (MOSC)

MOSC Banner

Assistance with piece of code please

edited Jun 24, 2015 9:24AM in SQL Language (MOSC) 7 commentsAnswered ✓

Hi, I don't do much coding and borrow much of what I need from what's already out on the net.   No sense in re-inventing the wheel every time.

I'm testing this piece of code that allow me to use segment advisor when OEM is not available.  I borrowed from this from the net and there are a couple of issues with it, I hope someone could resolve.

SET serveroutput ON

SET pagesize 10000

SET linesize 120

SET verify OFF

SET define off

-- Declare all the required variables.

ACCEPT t_name prompt 'Enter a unique Task Name : '

PROMPT * * * Object Type can be one of the following * * *

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