All Topics
Topic10 questions
Function - Scalar & AggregateQuestions & Answers
Practice 10 Function - Scalar & Aggregate questions with detailed answers and explanations. Tap any question below to study the full solution.
Function - Scalar & Aggregate question list
select substr("Oracle World",1,6) from dual;ABC company wants to give each employee a $100 salary increment. You need to evaluate the results from the EMP table prior to the …To display the names of all promos done after January 1, 2001 starting with the latest promo. Which query would give the required …Which statement is true regarding the default behavior of the ORDER BY clause?To calculate the number of days from 1st Jan 2007 till date: Dates are stored in the default format of dd-mm-rr. Which SQL stateme…To generate a report that shows an increase in the credit limit by 15% for all customers. Customers whose credit limit has not be…The CUSTOMERS table has these columns: CUSTOMER_ID NUMBER(4) NOT NULL; CUSTOMER_NAME VARCHAR2(100) NOT NULL; CUSTOMER_ADDRESS VARC…Generate a list of all customer last names with their credit limits from the CUSTOMERS table. Customers who do not have a credit l…To display the names of employees that are not assigned to a department. Evaluate this SQL statement: SELECT last_name, first_name…To update the CUST_CREDIT_LIMIT column to NULL for all the customers, where CUST_INCOME_LEVEL has NULL in the CUSTOMERS table. Whi…Practice more topics
PrimerPrep has independently reviewed practice questions and coding exercises — all free.