Databases Reporting with SQL Working with Text Single vs Double Quotes

Maryam Naz
Maryam Naz
2,959 Points

can someone define "string literal" and identifier"? I tried the web, and still unclear. Thanks in advance.

can someone define "string literal" and identifier"? I tried the web, and still unclear. Thanks in advance.

1 Answer

Steven Parker
Steven Parker
182,341 Points

A "literal" is something that represents itself. Like the number 42 or the word "test". The latter is an example of a string literal since is composed of text instead of a number.

On the other hand, an identifier is a name that represents something else. An example common identifier used with SQL is a column name or table name.

Maryam Naz
Maryam Naz
2,959 Points

Copy that. Perfect! Many thanks Steven :).