Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kandy
Starting Member
15 Posts |
 Posted - 2006-10-26 : 15:54:26
|
| i am new to pl/sql.I need to Retrieve and display the part number, part description, warehouse number, and unit price of every part whose item class is ‘HW’. here is the part table. CREATE TABLE PART(PART_NUM CHAR(4) PRIMARY KEY,DESCRIPTION CHAR(15),ON_HAND NUMBER(4,0),CLASS CHAR(2),WAREHOUSE CHAR(1),PRICE NUMBER(6,2) );are explicit corsors needed to generate all rows with class 'hw'.there are 4 rows with class='hw' |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-10-26 : 16:07:37
|
| SELECT PART_NUM, DESCRIPTION, WAREHOUSE, PRICEFROM PartWHERE CLASS = 'HW'This is a very basic query. If you aren't familiar with the most basic statements, you really should get a book, attend some training, etc...Tara Kizer |
 |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-10-26 : 16:27:37
|
| pl/sql is ORACLE and this site is for Microsoft SQL Server questions. You should post this question on a site that answers ORACLE questions.CODO ERGO SUM |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-10-26 : 21:13:32
|
| www.DBForums.comwww.ORAFAQ.comMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
|
|
pl/sql