| Other SQL PLSQL Interview Questions |
|| Asked @
|Which clause of an UPDATE statement allows you to affect
only certain rows of a table?
1. The WHERE clause
2. The SET clause
3. The ROWS AFFECTED clause
4. The ORDER BY clause
|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
|what is difference between decode and case function?
|i want insert 10 records from table a to table b.
if i m using statement level trigger how many record insert
?in row level trigger how many record inserted???
|Do view contain data?
|How to fetch the rows by dynamicaly passing table name
|what is meant by databases
|one of the column in my table contains the data like
So my requirement is i want output like
it mean i want to delete duplicate rows in the table
permanently and i want output in the above formatow should u
|How will you make performance better for application including
front end and back
|How One can easily select all even, odd, or Nth rows from a
table using SQL queries?
|write a query that returns first characters of each word in
Oracel/Sql pl sql
|if a string is there like s1,s2,s3,s4.How to find count of
commas in this.
|For more SQL PLSQL Interview Questions Click Here |