in pl /sql the commend is like this  create table bb_basketstatus (idstatus number, idbasket number, idstage number, dtstage date, shipper varchar(200),shippingnum varchar(299)); create  sequence bb_status_seq start with 1 increment by 1; create or replace procedure   STATUS_SHIP_SP   ( p_basketID Number,p_datestage DATE, p_shipper varchar, p_shippingnum varchar) as begin  INSERT INTO bb_basketstatus (idstatus, idbasket, idstage, dtstage,  shipper, shippingnum)   values  (bb_status_seq.NEXTVAL,p_basketID,3,p_datestage,p_shipper,p_shippingnum);  commit; end; / select From bb_ basketstatus;  Execute  status_ship_sp(3,'20-FEB-12','UPS','ZW2384YXK4957')  ---- why it only shows " PL/SQL procedure successfully completed."without showing the result  of database ?

Q: Create a PL/SQL function to increment the salary of all employees of an organization by 20%, and for…

A: The queries are given in the below step

Q: create table emp ( eid number(7), fname char(20), lname char(20), salary   number, primary key…

A: Since you have not provided the database name to write the SQL code so I am using MySQL database to…

Q: in pl/sql ,use Cursor to get all the records from table  job_history for employee_id 121

A: pl/sql code for the above question is solved in step 2:- assume table job_history has columns…

Q: What are the considerations for using the CAST and CONVERT functions for data type conversions in…

A: In the world of SQL (Structured Query Language), data type conversions are a fundamental aspect of…

Q: How does the CONCAT_WS function provide advantages over the traditional CONCAT function in SQL?

A: CONCAT_WS function is an SQL function that is used to add two or more strings together with the…

Q: How does the COALESCE function compare with the ISNULL function when handling NULL values in SQL

A: The COALESCE and ISNULL functions are both used to handle NULL values in SQL. However, they have…

Q: In SQL, write the appropriate statements to insert default values for these three tables, each table…

A: Prescription table: INSERT INTO prescription (pre_no,pre_date,pre_amount)VALUES (10,12,1200); INSERT…

Q: pls help me SQL Instructions: Answers ALL the questions. This test contributes 5% to your…

A: Here is query of the above alll problem. See below steps.

Q: PL/SQL Create a simple loop that prints instructor names, where instructor IDs are in the range…

A: Required:   PL/SQL Create a simple loop that prints instructor names, where instructor IDs are in…

Q: Please write SQL codes to create a sequence and name it member_seq and use it to populate below data…

A: Given: Write SQL codes to create a sequence and name it member_seq and use it to populate below data…

Q: Create a PL/SQL function to increment the salary of all employees of an organization by 15%, and for…

A: Creating a PL/SQL function to increment the salary of all employees of an organization by 15%, and…

Q: Write PL/SQL or T-SQL procedures to accomplish the following tasks: A: obtain the name and credit…

A: Actually, SQL stands for Structured Query Language.

Q: Write the syntax for AUTO_INCREMENT in sql databases.

A: Question. Write the syntax for AUTO_INCREMENT in SQL databases. Answer. AUTO_INCREMENT:…

Q: What is the significance of the ROW_NUMBER function when dealing with duplicate rows in SQL?

A: SQL stands for Structured Query Language which is used to communicate with a database. It is the…

Q: Create a PL/SQL query to display the combined customer name, coin purchased, coin price andthe…

A: THE GIVEN SQL QUERRY FOR THE QUESTION