Package Specification dept_pack was created by the following…
Package Specification dept_pack was created by the following code: CREATE OR REPLACE PACKAGE dept_pack IS PROCEDURE ins_dept(p_deptno IN NUMBER); FUNCTION get_dept(p_deptno IN NUMBER) RETURN VARCHAR2;END dept_pack; Which of the following is incorrect syntax for invoking the package subprograms?
Read DetailsThe following PL/SQL block will correctly return the last na…
The following PL/SQL block will correctly return the last name of the employee whose employee id is 100. True or False? DECLARE v_last_name employees.last_name%TYPE; employee_id employees.employee_id%TYPE := 100; BEGIN SELECT last_name INTO v_last_name FROM employees WHERE employee_id = employee_id; END;
Read DetailsConsider the following data files: digits-en.txtThis file c…
Consider the following data files: digits-en.txtThis file contains digits (0 to 9) and their lower-case spelling in English.Example of contents: nine 9two 2one 1four 4 digits-fr.txtThis file contains similar information, but the digit comes first and the words are in French (without accentuated letters, to make things easier).Example of contents: 8 huit3 trois4 quatre1 un digits.txtThis file contains only numbers.Example of contents: 354298 Please note the following: Our files may not all feature the same numbers. We will therefore have the spelling for some numbers in only one language, in both, or in none. None of the files are to be assumed to be already sorted by numbers. A single space is used as separator in all files. We want you to use join in order to display the following sorted lists of numbers (only numbers, not any words): All numbers that are found in digits.txt, that also have an English spelling in digits-en.txt. All numbers, that are found in digits-en.txt and digits-fr.txt, that have only a French spelling, but no English spelling. All numbers, that are found in digits-en.txt and digits-fr.txt, that have a spelling in only one of the two languages. Provide the Linux command lines to achieve these three separate objectives.
Read Details