ORACLE Activity 2
Across
- 3. Loop used when number of iterations is known.
- 5. Command used to disable trigger.
- 8. Section where variables are declared.
- 11. Operator used to compare range of values.
- 12. Current system date function.
- 14. A virtual table in SQL.
- 17. Command to remove view.
- 18. Cursor attribute to check end of records.
Down
- 1. Used to count number of rows.
- 2. SQL function used to convert text into uppercase.
- 3. Used to fetch records from cursor.
- 4. SQL function to find maximum value.
- 6. Block section used to handle errors.
- 7. data type is used for variable declaration dynamically.
- 9. Used to extract part of string.
- 10. _PROCEDUREStatement used to create procedure.
- 12. A query written inside another query.
- 13. A function used to find total value of a column.
- 15. Join that returns matching records from both tables.
- 16. Logical operator used to combine conditions.