Using a regular expression function to determine how many times 'E' or 'e' appear in the string: 'Oracle SQL by Example by Alice Rischert'

Enter all of the various kinds of numerical information. In SQL

ISBN Title Author 12345678 The Hobbit J.R.R. Tolkien 45678912 DaVinci Code Dan Brown Your student ID DBS311 Your Name use the following statement to Write the PL/SQL code to create a procedure that accepts a product price and increases it by 10%

Is this statement true or false: Oracle SQL allows full expression-based use of both provided (built-in) and user-definable functions.

Database: https://www.w3schools.com/sql/trysql.asp?filename=trysql_select_all

In what situations might the SOUNDEX function be useful in SQL when querying text data?

Database: https://www.w3schools.com/sql/trysql.asp?filename=trysql_select_all

Using DML SQL, write the appropriate SQL query for each of the following:a) Insert A new customer with the following information:(Name: Ali, SSN: 1111, Address: Riyadh, Phone: 05555)b) Delete all the loans for customer with SSN: 2222c) Select all customer who got loans more than 250000 SAR, print the customers SSN, named) Print all the Accounts in Bank: ALBILAD and in branch no: 5

How can you dynamically execute a SQL query in PL/SQL? a. Using EXECUTE IMMEDIATE statement b. Using DBMS_SQL package c. Using FETCH statement d. Using OPEN-FOR statement