In the following PL/SQL block, determine the values and data types for each of the following cases: DECLARE   v_customer VARCHAR2(50) := 'Womansport2';     v_credit_rating VARCHAR2(50) := 'VERY_GOOD'; BEGIN   DECLARE   v_customer NUMBER(7) := 201;    v_nmae VARCHAR2(25) := 'Unisports';      BEGIN      V_credit_rating := 'GOOD';   END;   END;   The value of v customer in the nested block is:   The value ofv name in the nested block is:   The value of v _credit_rating in the nested block is:   The value of v customer in the main block is:   The value of v name in the main block is:   The value of v_credit_rating in the main block is:

Q: in pl /sql the commend is like this  create table bb_basketstatus (idstatus number, idbasket…

A: The answer for the given question is as follows.

Q: Use the following table to find the OUTPUT of the following SQL queries: Table Name: Patients…

A: Answer :--  Jan-12-01

Q: Create a function name BALANCE that returns the status of outstanding amount for each customer. Use…

A: Required : Function name : BALANCE It returns the status of outstanding amount for each customer. IF…

Q: Use CASE statement in PL SQL block, where take a character as input from the user and print…

A:

Q: Imagine a student table with following columns:      Student(Stuid, Name , Age, Major) Write a…

A: given table Student Stuid Name Age Major

Q: Use SQL Developer or Oracle Live SQL to write the appropriate SQL commands as follows: A) FUNCTION:…

A: Answer: Oracle: CREATE FUNCTION Return_region_name(region_id IN NUMBER)RETURN NUMBERIS region_name…

Q: Resort that charges the highest You have to only develop a SQL query Write a query to display the…

A: Required: Write a query to display the resort name, rate of all the resorts that charge the highest.…

Q: In Sql Oracle Apex application, Using GROUPING SETS, write a query to show the following groupings:…

A: First query performs a grouping on two columns Department_Id and Job_Id Group By X, Y means put all…

Q: SELECT MAX(datediff(minute,start_time,end_time)) as "Longest_ride",…

A: Your SQL code contains error related to function datediff.

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: Write PL/SQL cursor to find the commission amount for all the employees whose job_id is SA_MAN Use…

A: The SQL SELECT statement returns a result set of records, from one or more tables. The FROM clause…

Q: Write a SQL code that returns the Name of ALL Customers (based on CUS_FNAME and CUS_LNAME in…

A: The question is solved in step2

Q: Using DML SQL, write the appropriate SQL query for each of the following: Insert A new customer…

A: SQL:- Big data SQL or structured query language can be regarded as the base or medium of…

Q: Question 11. Write the SQL statement that will implement the relational algebra expressions in the…

A: The queries are given below

Q: How does the STUFF function help in manipulating string data in SQL?

A: The STUFF function in SQL is used to manipulate string data by inserting, replacing, or deleting…

Q: In SQL Server, specify the differences between the two character data types as follows: NVARCHAR…

A: Data formats: When building a table in the database, each column will have its own data type, and…

Q: Write three functions in SQL which does the following: The first function should take an integer…

A: In MYSQL function Syntax to convert number from one base to another follows:- CONV(<num to…

Q: What are the advantages of using table-valued parameters in SQL functions

A: Table-valued parameters (TVPs) in SQL are a powerful feature that allows developers to send multiple…

Q: True or FalseString comparisons in SQL are case sensitive.

A: Explanation: The data in DBMS is stored and retrieved by using a specific language called SQL. DBMS…

Q: Why might one use the SPLIT function in SQL for string manipulations, and what are its limitations?

A: Depending on the given delimiter, the divide function in SQL can be used to split text into multiple…

Q: IN SQL ** 1- Write a query clause to display the internal structure of the departments table, then…

A: As per our guidelines, we are supposed to answer only one question. Kindly repost the remaining…

Q: Use the following table to find the OUTPUT of the following SQL queries: Table Name: Patients…

A: Answer: 98877445

Q: 5. Add a column to the query described in exercise 2 that uses the RANK() function to return a…

A: The above question is solved in step 2 :-

Q: Use the following table to find the OUTPUT of the following SQL queries: Table Name: Patients…

A: TO_CHAR function is used to typecast date input to character type with a format model. Syntax:…

Q: *Query in SQL required* Write a query to display student's Id and First Name whose from Coimbatore…

A: As per the given question we have to develop a SQL query to display student's Id and First Name…

Q: Complete PL/SQL function below, which will return last name of employee whose id is equals to 2…

A: The above question is solved in step 2:-

Q: Use the following table to find the OUTPUT of the following SQL queries: Table Name: Patients…

A:

Q: Use SQL Developer or Oracle Live SQL to write the appropriate SQL commands as follows: A) FUNCTION:…

A: A) : create function Return_region_name { @region_id num, } returns varchar as begin  (select name…

Q: Use the following table to find the OUTPUT of the following SQL queries: Table Name: Patients…

A: The LPAD function left pads the given argument, here in the patients table the first_name of the…

Q: You are given the following data tables: Employees(Employeel D, LastName, FirstName, BirthDate,…

A: To find all orders where the shipper ID of the order is greater than or equal to 1000, we can use a…

Q: 1. Prepare a list of orders by Shipper showing the Shipper ID, Order ID, Product ID and Quantity.…

A: In this question we have to understand about given SQL database and prepare the list of queries…

Q: Use the following table to find the OUTPUT of the following SQL queries: Table Name: Patients…

A: While executing sql command firstly it performs where condition,here we have per_test='positive' In…

Q: Using DML SQL, write the appropriate SQL query for each of the following: Insert A new customer…

A: In SQL, DML stands for Data manipulation language which contains Select, Insert, Delete and Update…

Q: Question 11 Write SQL statements to answer the following question based on the ERD below. Note:…

A: The objective of the question is to write a SQL query that will list the course name, section ID,…

Q: In SQL Server, specify the differences between the two character data types as follows: NVARCHAR…

A: According to the information given:- We ahev to define the differences between the two character…

Q: Create a PL/SQL database programming block with DECLARE BEGIN   END; In Declare section define…

A: Below is the PLSQL block code:

Q: Instructor (Instructor_Id, Instructor_Name, specialization, Address, #Department_Id) Write in…

A: First we have to create a table Instructor with details such as Instructor_name, Specialization,…

Q: In SQL  This sample database consists of the following tables(see image for tables and there is one…

A: 1. orderNumber is the primary key in the orders table, so it is always unique.This query selects…

Q: Write a query to display maximum bus tickets fare and give an alias name as MAXIMUM_AMOUNT BUSES…

A: Required:   We have to write an SQL query that displays the maximum bus tickets fare and print it…

Fundamentals of Datawarehouse

A data warehouse is a data repository which is used to store large quantities of historical data that are mostly used for creating reports that help businesses to identify their weaknesses and strengths. For example, demographics data about people of a region can help businesses identify the needs and preferences of the region’s population. A data warehouse acts as a central storage for storing data that comes from one or more heterogenous sources. It also consists of data which can be old and of historical value. One of the most important applications of this type of system is that it is used for supporting business intelligence and data analytics applications.