Assume that you have a product code that has the following format: XXXXNNN Where X is a character and N is a digit. Notice that the length of the character part is not fixed, it may range from 2 to 4 characters, while the length of the second part may range from 2 to 3 digits but the first digit from the left is always 0 (zero). Write a PL/SQL program to separate the code into its two parts as shown in the following example: if the input is ABC031, the output should be: Product Name is: ABC Serial Number is: 031 Hints: Use the following functions if needed: instr( string1, string2 [, start_position [, nth_appearance ] ] ) substr( string, start_position, [ length ] ) length( string ) DBMS_OUTPUT.PUT_LINE( )

Assume that you have a product code that has the following format: XXXXNNN Where X is a character and N is a digit. Notice that the length of the character part is not fixed, it may range from 2 to 4 characters, while the length of the second part may range from 2 to 3 digits but the first digit from the left is always 0 (zero). Write a PL/SQL program to separate the code into its two parts as shown in the following example: if the input is ABC031, the output should be: Product Name is: ABC Serial Number is: 031 Hints: Use the following functions if needed: instr( string1, string2 [, start_position [, nth_appearance ] ] ) substr( string, start_position, [ length ] ) length( string ) DBMS_OUTPUT.PUT_LINE( )

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter3: Performing Calculations With Formulas And Functions

Section: Chapter Questions

Problem 2.11CP

See similar textbooks

Similar questions

Write a p l SQL program to print the following series 2, 8,11....50
Please develop PL/SQL program that asks for a radius of a circle.After user enters a radius number, the program then calculates 1. Circumference and 2. Area of a circle, then prints both as follows: You entered radius as 5The circumference is 31.4159The area is 78.5398 If the area is less than 50 then print 'Please enter bigger radius'.Otherwise print 'Your radius is Ok'. Declare variables for circumference and area in such a way that the result would be rounded to 4 decimal places after the dot
In PL/SQL, Create a recursive store function called add_numbers to calculate the total of all consecutive positive integers from 1 to the number entered by the user. The number that will stop the function must be entered by the user when running the function and be passed to the function. If the user enters a zero or a negative number, display the total as 0. You can use the function in a SELECT statement to execute it. See sample outputs below. ADD_NUMBERS(5)---------------------------- 15 ADD_NUMBERS(3)----------------------------- 6
in sql ,create a program that prompts the user for a number. This number will be top (cap) number. And your program will find out all the even and odd numbers in between 1 to this max number. The program should continue to find odd and even numbers from 1 to maximum number given (entered) by user… If user input is less than or equal to zero Program should not even start doing its task and right away print ‘Sorry I can not calculate odd and even numbers for negative or zero’ … But when user entered any positive number then the program should display all numbers as either even or odd.
TAL Distributors would like to know the number of months between the current date and the order date of an order. Write an SQL statement in MySQL that displays the order number and the number of months between the current date and the order date. The number of months should display as an integer. (Hint: You can nest one function within another function.) This is the code I haveSELECT FLOOR(MONTHS_BETWEEN(CURRENT_DATE,To_date(ORDER_DATE, 'MM/DD/YYYY')))num_monthsFROM ORDERS;is giving me an errorError Code: 1305. FUNCTION tal.MONTHS_BETWEEN does not exist
Develop simple PL/SQL programs a) Create a while loop that print all ODD numbers (1,3,5,7, etc) in the range from 5 to 25. b) Find a sum of all these numbers, print the sum only once at the end.
Write the correct term that matches the description below. Performs arithmetic operations (+, –, *, /) as well as comparison or relational operations (<, >, =); the latter are used to compare numbers.
You are working with a database table that contains customer data. The table includes columns about customer location such as city, state, country, and postal_code. The state names are abbreviated. You want to check for state names that are greater than 2 characters long. You write the SQL query below. Add a LENGTH function that will return any state names that are greater than 2 characters long.
A(n) ___________________ is used within a simple condition to compare two values. A index B relational operator C data type D logical operator
SQL 2019 UTF-8 can encode these data types: a. varchar; b. simply a and b; c. char; d. nchar; or e. all of the above.
Oracle sql Task 2: Write a function that returns how old a book is Published before 2000 ->Book X by author Y is an old book Between 2000 and 2020 -> Book X by author Y is modern 2020 and later -> Book X by author Y is recently published X: book name Y: author name
A better design would be one with the following tables: Patient : | pid | name | dob | addr | tel | Exam : | acc | pid | eid | result | date | ExamDictionary : | eid | name | normal | Questions: Create SQL queries (select statements) that accomplish the following. 1. List all of the Exams for Ms. Jones (pid=12). 2. List all of the Patients that hail from jolly old London. 3. List all of the Exams with results that exceed their normal. 4. List the name of all Patients that had Exams with results that exceed their (the exam’s) normal. 5. List the name of all Patients that had Exams with results that exceed their (the exam’s) normal, but list names only once and in alphabetical order.