May 2000
Intermediate to advanced
594 pages
11h 32m
English
Content preview from Oracle PL/SQL Programming: A Developer's Workbook
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Intermediate
28-26. | Given what you know about how procedures are called from the Web, what calling notation (positional or named) do you think the PL/SQL gateway uses to actually perform the call? Discuss the implications the calling format has on your web development effort. |
28-27. | Under what circumstances can you call a procedure from the Web using just its name and parameters (i.e., when can you omit the server, port, and virtual schema mappings)? |
28-28. | A developer has written the following program: PROCEDURE val_test (i_val in number default 0) IS
BEGIN
HTP.PRINT('The value is: ' || i_val );
EXCEPTION
WHEN OTHERS THEN
HTP.PRINT ('Invalid number');
END;What happens when the following hyperlink is used to call the procedure? http://myserver/virtual_schema_mapping/val_test?i_val=four |
28-29. | Discuss three ways to maintain state in a PL/SQL web application. |
28-30. | A consulting company is developing a simple system to help its employees prepare for visits to client sites. The basic idea is that each consultant gets an online schedule of all the clients they are going to see. The schedule also contains a hyperlink to each company’s home page so that the consultant can easily do some basic research. You have been asked to write an HTML interface based on a view named onsite_schedule. It has the following columns: Name Null? Type ------------------------------- -------- ---- SALESMAN_ID NUMBER VISIT_DATE DATE COMPANY_NAME VARCHAR2(50) COMPANY_URL VARCHAR2(200) What single PL/SQL toolkit procedure ... |
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.