Branch ID Bank Name Loan Loan Account no Client address status name William New York Phoenix 201 MBL 80000 Ассеpted 101 Michael Anthony Chicago Houston Matthew Fresno 202 UBL 90000 pending 102 203 JS 77000 оpen 103 204 Metro 68000 Ассеpted 104 Aiden 205 Al Habib 75000 close 105 1. Write sgl query to create a stored procedure name "SelectAllBank" that select client name, address and bank. 2. Write sgl query to create a stored procedure that display details of those clients whose loan status is 'accepted'. 3. Write sgl query to create a stored procedure list all clients who either have applied for loan or not. 4. Write sgl query to create a stored procedure list all clients who have applied for loan. 5. Write sgl query to create a stored procedure list all those clients who have not applied for loan.

Branch ID Bank Name Loan Loan Account no Client address status name William New York Phoenix 201 MBL 80000 Ассеpted 101 Michael Anthony Chicago Houston Matthew Fresno 202 UBL 90000 pending 102 203 JS 77000 оpen 103 204 Metro 68000 Ассеpted 104 Aiden 205 Al Habib 75000 close 105 1. Write sgl query to create a stored procedure name "SelectAllBank" that select client name, address and bank. 2. Write sgl query to create a stored procedure that display details of those clients whose loan status is 'accepted'. 3. Write sgl query to create a stored procedure list all clients who either have applied for loan or not. 4. Write sgl query to create a stored procedure list all clients who have applied for loan. 5. Write sgl query to create a stored procedure list all those clients who have not applied for loan.

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter6: Additional Database Objects

Section: Chapter Questions

Problem 8MC

See similar textbooks

Similar questions

Which of the following has no partial dependencies but can contain transitive dependencies? a. unnormalized data b. 1NF c. 2NF d. 3NF
Which of the following is a correct statement? a. A commit is issued implicitly when a user exits SQL Developer or SQLPlus. b. A commit is issued implicitly when a DDL command is executed. c. A commit is issued automatically when a DML command is executed. d. All of the above are correct. e. Both a and b are correct. f. Both a and c are correct.
Which of the following has no partial or transitive dependencies? unnormalized data 1NF 2NF 3NF
Which of the following has no repeating groups but can contain partial or transitive dependencies? unnormalized data 1NF 2NF 3NF
Which of the following is a valid SQL statement? SELECT * WHERE amid = ‘J100’ FOR UPDATE; INSERT INTO homeworkl0 VALUES (SELECT * FROM acctmanager); DELETE amid FROM acctmanager; rollback; all of the above
I need the output of the queries create table Accounts (account_no number primary key, client_name varchar2(200),Gender varchar2(20),address Varchar2(200)); create table loans (branch_id number, bank_name varchar2(200),Loan number, loan_Status varchar2(200),account_no number references Accounts(account_no) ON DELETE CASCADE); 1. delete from accounts where account_no= 101; 2. select * from accounts a where exists (select 1 from loans l where l.account_no= a.account_no) 3. select * from accounts a where exists (select 1 from loans l where l.account_no= a.account_no and status = 'accepted') 4. create or replace view view1 as select client_name , address,l.bank_name,l.loan_Status from accounts a, loans l where a.account_no = l.account_no Step 2 5.create or replace view view2 as select client_name , address,l.bank_name,l.loan_Status from accounts a, loans l where a.account_no = l.account_no and address = 'Karachi' 6. create or replace view view3 as select client_name ,…
In Kali, login to DVWA, set security level to low , then click SQL Injection on left pane .Write sqlmap commands to answer the following questions, and paste the result underneath each of your sqlmap commands. 1 . Find all database names 2. Find the current database name 3.find all table names under a database named DVWA 4.find column named in the table named users in database dvwa 5. find all values in the table users in database dvwa (when your command runs and prompts questions, you just enter n for no)
Write a trigger to update the CUST_BALANCE when an invoice is deleted. Name the trigger trg_updatecustbalance2. (You should delete INV_NUM 9006 from INV_MYSQL to ensure your code is correct.)
Assuming the HOMEWORK10 table has three columns (Col1, Col2, and Col3, in this order), which of the following commands stores a NULL value in Col3 of the HOMEWORK10 table?a. INSERT INTO homework10 VALUES (‘A’, ‘B’, ‘C’);b. INSERT INTO homework10 (col3, col1, col2) VALUES (NULL, ‘A’, ‘B’);c. INSERT INTO homework10 VALUES (NULL, ‘A’, ‘B’);d. UPDATE homework10 SET col1 = col3;
Which of the following statements represents a correctly structured transaction? a.) BEGIN;COMMIT;insert into album (artist_id, title, album_id) values (1, 'My Album', 348);insert into playlist (playlist_id, name) values (30, 'New Age Playlist'), (31, 'Oldies'), (32, 'Road Trip');UPDATE albumSET title = 'Out of Exile [Disc 1]'WHERE album_id = 11; b.) BEGINinsert into album (artist_id, title, album_id) values (1, 'My Album', 348);insert into playlist (playlist_id, name) values (30, 'New Age Playlist'), (31, 'Oldies'), (32, 'Road Trip');UPDATE albumSET title = 'Out of Exile [Disc 1]'WHERE album_id = 11;COMMIT; c.) BEGINinsert into album (artist_id, title, album_id) values (1, 'My Album', 348)insert into playlist (playlist_id, name) values (30, 'New Age Playlist'), (31, 'Oldies'), (32, 'Road Trip')UPDATE albumSET title = 'Out of Exile [Disc 1]'WHERE album_id = 11COMMIT d.) BEGIN;insert into album (artist_id, title, album_id) values (1, 'My Album', 348);insert…
Use the "uniq -c" command to sort and summarize the total occurrences of sudo access by month and user. Submit - Screen shot of your syntax and output showing total occurrences by month and user of sudo access, for example: 112 Apr msmith 101 Mar admin What command should we use??
134. EMPDET is an external table containing the columns EMPNO and ENAME. Which command would work in relation to the EMPDET table? a. UPDATE empdetSET ename = 'Amit'WHERE empno = 1234; b. DELETE FROM empdetWHERE ename LIKE 'J%'; c. CREATE VIEW empvuASSELECT * FROM empdept; d. CREATE INDEXempdet_idxON empdet(empno);