Explain scalar functions in sql?
No Answer is Posted For this Question
Be the First to Post Answer
What are the modes of parameters that can be passed to a procedure ?
What is record data type?
Explain autonomous transaction.
What is the use of partition by in sql?
Explain how to use transactions efficiently : transact sql
What is parallel hint?
SELECT flavor, SUM (ice_cream_sales) FROM sales_detail GROUP BY flavor ORDER BY 2 DESC If the "sales_detail" table contains ten records with different values in the flavor column (two "vanilla," three "chocolate," four "strawberry," and one NULL), how many rows are returned by the sample code above? 1. 0 rows 2. 1 row 3. 3 rows 4. 4 rows 5. 10 rows
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?
How many parts of a pl sql block are optional?
how do you count the duplicate records in a table
What operators deal with null?
What is the cause of mutating table error and how can we solve it?