Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: MartialArtist
- Order by date
-
Probably fairly basic PL/SQL question from a PL newbie.
Mufasa, I have created a temporary table using the following SQL: CREATE TABLE prinport_90 AS SELECT DISTINCT vf.year, vf.agid, vf.drvid, cg.vname, apr.description AS port_name, COUNT(apr.description) as landings, ROUND(SUM(lwt_lbs)) AS lbs, ROUND(SUM(rev)) AS dols FROM apr, vdrfd vf...- MartialArtist
- Post #3
- Forum: Oracle: All versions
-
Probably fairly basic PL/SQL question from a PL newbie.
Being new to PL/SQL, I am having some difficulty in determining how to use PL/SQL to automate a data-cleaning problem. I have written the appropriate SQL to extract recordsets for 21 years of data that contains the year, harvester ID, harvester name, delivery location, total quantity, and total...- MartialArtist
- Thread
- Replies: 3
- Forum: Oracle: All versions
