Across
- 3. , , condition allows you to perform pattern matching.
- 4. , , function allows you to concatenate two strings together.
- 8. , , clause to determine which records to select
- 9. , , function pads the right-side of a string with a specific set of characters
- 11. , , function returns a number rounded to a certain number of decimal places.
- 15. , , function sets the first character in each word to uppercase and the rest to lowercase.
- 18. , , function returns the summed value of an expression.
- 19. , , function pads the left-side of a string with a specific set of characters
- 23. , , statement is used to insert a single record or multiple records into a table in Oracle.
- 24. , , statement is used to set a transaction
- 25. , , statement allows you to create and define a table.
- 26. , , constraint is a single field or combination of fields that uniquely defines a record.
- 27. , , condition (also called the NOT Operator) is used to negate a condition in a select, insert, update, or delete statement.
- 28. , , function returns the maximum value of an expression.
- 29. , , statement is used to undo the work performed by the current transaction or a transaction that is in doubt.
- 31. , , clause is used in combination with the group by clause
- 33. , , clause is used in a select statement to collect data across multiple records and group the results by one or more columns.
- 35. , , clause is used to list the tables and any join information required for the Oracle query.
- 36. , , condition is used to help reduce the need to use multiple or conditions in a select, insert, update, or delete statement.
- 37. , , function returns the count of an expression.
Down
- 1. , , statement is used to add, modify, or drop , ,delete columns in a table.
- 2. , , function converts all letters in the specified string to lowercase.
- 5. , , statement commits all changes for the current transaction. Once a commit is issued, other users will be able to see your changes.
- 6. , , constraint allows you to specify a condition on each row in a table.
- 7. , , function returns the square root of n.
- 10. , , function returns the average value of an expression.
- 12. , , statement is used to update existing records in a table in an Oracle database.
- 13. , , means Variable-length string.
- 14. , , clause is used to remove duplicates from the result set.
- 16. , ,statement is used to retrieve records from one or more tables in an Oracle database.
- 17. , , means that values in one table must also appear in another table.
- 19. , , function returns the length of the specified string.
- 20. , , condition is used to retrieve values within a range in a select, insert, update, or delete statement.
- 21. , , function returns the absolute value of a number.
- 22. , , function removes all specified characters from the right-hand side of a string.
- 30. , , function removes all specified characters from the left-hand side of a string.
- 32. , , condition is used to test for two or more conditions in a select, insert, update, or delete statement.
- 34. , , operator is used to combine the result sets of 2 or more oracle select statements.