Across
- 2. Type of trigger in which :OLD and :NEW qualifiers can be referenced
- 4. Database object used for creating alias names for tables
- 6. Function used to replace NULL value with any given value provided by the user
- 7. Used to generate series of unique numbers for a numeric column
- 8. SQL command used to modify existing data in a database table
- 10. Keyword used to return unique values in a column
- 12. ________ clause can be used with aggregate functions like sum, etc in a sql query
- 13. A stored subprogram that is executed automatically and fired based on some database events
- 15. Group functions can be nested upto these many levels only
- 16. Dummy table with one column and one row present by default in oracle
- 17. Unique physical address for each row in every table
- 19. A cursor attribute that returns true when cursor is open and returns false when cursor is closed
Down
- 1. This join displays the cartesian product of records from the tables present in the join
- 3. Rules enforced on data columns in a table
- 5. Default parameter mode set for formal parameters in an oracle subprogram
- 6. Pseudo column used to get the next value generated by a sequence
- 9. Logical table that can be created based on one or more views or tables
- 10. Optional part of a plsql block
- 11. Function that can be used to return a specified portion of a character string
- 14. Clause that groups a result into subsets that have matching values for one or more columns
- 18. Keyword used for specifying ALIAS names for columns in an oracle table