Basic SQL
SQL Symbols
SQL Operators
SQL Functions 1
SQL Functions 2
100

This word starts a SQL query.

What is Select?

100
These symbols mean greater than or equal to?
What is >= ?
100

This word joins two or more tables in the join condition

What is on?

100
This function lists the current date.
What is sysdate?
100

This function extends the functionality of the INSTR function by letting you search a string for a regular expression pattern 

What is REGEXP_INSTR?

200
This word references a table name.
What is From?
200
This symbol means a wildcard.
What is %?
200
This operator stands for equal to.
What is =?
200
This function brings back the value in capital letters.
What is upper?
200

This function returns the date date plus integer months 

What is ADD_MONTHS?

300
This symbol brings back all the rows and columns.
What is *?
300
This symbol means less than.
What is < ?
300

This operator returns the remainder of an equation

What is modulus %

300
This function brings back the final day of the month.
What is last day?
300
This function makes the first letter of each word capitalized.
What is initcap?
400
This word limits the data brought back.
What is Where?
400
These symbols go around a list of values with the in operator.
What is ( ) parantheses?
400
This operator searches for a pattern of letters.
What is like?
400
This function brings back a certain number of characters for each value.
What is substr?
400
This function bring back the value in small letters.
What is lower?
500
This symbol ends a SQL statement.
What is ; ?
500

These symbols mean not equal.

What is != or <> ?

500
This operator gives a list of values.
What is in?
500

This function gives a value if nothing is listed in that column.

What is NVL?

500
This function joins two columns together with the || symbol.
What is concatenation?
M
e
n
u