Basic SQL
SQL Symbols
SQL Operators
SQL Functions 1
SQL Functions 2
100
This word starts a SQL statement.
What is Select?
100
These symbols mean greater than or equal to?
What is >= ?
100
This word joins two conditions in the where line.
What is and?
100
This function lists the current date.
What is sysdate?
100
The function sysdate does this.
What is lists the current date?
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
The function upper does this.
What is lists the value in capital letters?
300
This symbol brings back all the rows and columns.
What is *?
300
This symbol means less than.
What is < ?
300
These operators bring back a range of values.
What is between and?
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 != ?
500
This operator gives a list of values.
What is in?
500
This function gives a value if nothing is listed.
What is NVL?
500
This function joins two columns together with the || symbol.
What is concatenation?
M
e
n
u