TAILIEUCHUNG - Oracle PL/SQL by Example- P12

Tham khảo tài liệu 'oracle pl/sql by example- p12', công nghệ thông tin, cơ sở dữ liệu phục vụ nhu cầu học tập, nghiên cứu và làm việc hiệu quả | LAB Lab Exercises 522 Next take a closer look at the second SELECT INTO statement. This statement uses CAST and TABLE functions which essentially enable you to query a nested table of objects as if it were a regular table. When run this example produces the following output Zip 00914 City Santurce State PR PL SQL procedure successfully completed. LAB EXERCISES This section provides exercises and suggested answers with discussion related to how those answers most important thing to realize is whether your answer should figure out the implications of the answers and what the effects are of any different answers you may come up with. Use Object Types In this exercise you continue exploring object types. Complete the following tasks A Create object type ENROLLMENT_OBJ_TYPE which has the following attributes ATTRIBUTE NAME DATA TYPE PRECISION student_id NUMBER 8 first_name VARCHAR2 25 last_name VARCHAR2 25 course_no NUMBER 8 section_no NUMBER 3 enroll_date DATE final_grade NUMBER 3 ANSWER The creation script should look similar to the following -- version CREATE OR REPLACE TYPE ENROLLMENT_OBJ_TYPE AS OBJECT student_id NUMBER 8 first_name VARCHAR2 25 last_name VARCHAR2 25 course_no NUMBER 8 section_no NUMBER 3 enroll_date DATE final_grade NUMBER 3 B The following script uses the newly created object type. Execute it and explain the output produced. -- version SET SERVEROUTPUT ON DECLARE v_enrollment_obj enrollment_obj_type Please purchase PDF Split-Merge on to remove this watermark. Lab Exercises LAB 523 BEGIN END 102 Fred Crocitto 25 ANSWER The output of the script should look similar to the following DECLARE ERROR at line 1 ORA-06530 Reference to uninitialized composite ORA-06512 at line 6 This version of the script causes an ORA-06530 error because it .

TỪ KHÓA LIÊN QUAN
Đã phát hiện trình chặn quảng cáo AdBlock
Trang web này phụ thuộc vào doanh thu từ số lần hiển thị quảng cáo để tồn tại. Vui lòng tắt trình chặn quảng cáo của bạn hoặc tạm dừng tính năng chặn quảng cáo cho trang web này.