Suoritettu

Oracle 8i PL/SQL

1. Write a PL/SQL program in Oracle 8i that uses and implicit cursor to display the project name, client name, and project manager first and last name for P_ID 5 in the Software Experts database. Include the WHEN OTHERS exception handler. Format the program output as shown in [url removed, login to view] Use variable values rather then hard-coded values wherever possible in the DBMS_OUTPUT function. Spool to text file and save as [url removed, login to view] 2. Write a PL/SQL program in Oracle 8i that displays the full name and address of Clearwater Traders customer Alissa Chang and then summarizes the details of all of her orders, as shown in [url removed, login to view] Use and implicit cursor to retrieve and display the order information. Spool to text file and save as [url removed, login to view]

## Deliverables

1. Two text files with completed assignment

## Platform

Oracle8i for Windows

## Deadline information

Must b

Taidot: tekniikka, MySQL, Oracle, PHP, tietojärjestelmäarkkitehtuuri, Ohjelmistojen testaus, SQL

Näytä lisää: sql to oracle, sql oracle pl sql, sql in pl sql, sql function in oracle, project handler, pl sql software, pl sql in oracle, pl/sql format, pl sql format, pl sql files, pl sql and oracle, pl sql and, oracle sql pl, oracle com, gif to txt, function oracle pl sql, function in oracle pl sql, for in pl sql, for all in pl sql, exception pl sql oracle

Tietoa työnantajasta:
( 22 arvostelua ) United States

Projektin tunnus: #2884140

Myönnetty käyttäjälle:

stmpeters

See private message.

$12 USD 14 päivässä
(21 Arvostelua)
2.7