Home » SQL & PL/SQL » SQL & PL/SQL » PLSQL Packages
PLSQL Packages [message #218934] Mon, 12 February 2007 03:02 Go to next message
flowera
Messages: 3
Registered: February 2007
Junior Member
SQL> SELECT * FROM ERP_PROFILE;

PROFILEID PROFILECODE PROFILENAME USERCODE
---------- ----------- ------------ -------------
1001 201 admin 11
1002 202 manager 12
1003 203 assistant 13
1004 204 clerk


SQL> DESC ERP_PROFILE;

Name Null? Type
--------------------- -------- -------------
PROFILEID NUMBER
PROFILECODE NOT NULL NUMBER
PROFILENAME VARCHAR2(50)
USERCODE NUMBER


Hi,
i want to create the package specification
and package body for the select statement using
procedure.how to create please help me. i am
novice to oracle database 10g.I want to these
statement....
SELECT * FROM ERP_PROFILE;
SELECT PROFILEID,PROFILECODE,PROFILENAME FROM ERP_PROFILE;

[Updated on: Mon, 12 February 2007 03:05]

Report message to a moderator

Re: PLSQL Packages [message #218936 is a reply to message #218934] Mon, 12 February 2007 03:05 Go to previous messageGo to next message
dhananjay
Messages: 635
Registered: March 2002
Location: Mumbai
Senior Member
hi,

can you explain more.what is that you are trying to achive?

regards,
Re: PLSQL Packages [message #218941 is a reply to message #218936] Mon, 12 February 2007 03:15 Go to previous messageGo to next message
flowera
Messages: 3
Registered: February 2007
Junior Member
Hi,

I want to get all datas in a table from database to PLSQL using SELECT command...
Re: PLSQL Packages [message #219081 is a reply to message #218934] Mon, 12 February 2007 19:27 Go to previous message
BlackSwan
Messages: 25041
Registered: January 2009
Location: SoCal
Senior Member
Trying to get others to do homework assignment with no success.
http://www.dbforums.com/showthread.php?t=1614939
Previous Topic: date function
Next Topic: How to overcome mutating table error.
Goto Forum:
  


Current Time: Tue Dec 06 12:06:46 CST 2016

Total time taken to generate the page: 0.08564 seconds