PL/SQL (MOSC)

MOSC Banner

Stored Procedure Possibility

edited Sep 14, 2011 3:00AM in PL/SQL (MOSC) 8 commentsAnswered
I am relative novice when it comes to PL/SQL. Right now, I have a case; however, I am not sure if it is possible for a stored procedure to achieve my desired display results.

I have two tables:

SQL> desc triton.ttcdrg100100
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 T$ITEM                                    NOT NULL CHAR(16)
 T$CPRJ                                    NOT NULL CHAR(6)
 T$DRGP                                    NOT NULL CHAR(2)
 T$SEQN                                    NOT NULL NUMBER
 T$NAME                                    NOT NULL CHAR(35)
 T$VERS                                    NOT NULL CHAR(4)
 T$ENTD                                    NOT NULL DATE
 T$USER                                    NOT NULL CHAR(16)
 T$REFCNTD                                 NOT NULL NUMBER
 T$REFCNTU                                 NOT NULL NUMBER

(t$item, t$cprj, and t$drgp together makes it unique.)

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