Before formulating the SELECT statement, you must first determine in which table the information is located.
The following SELECT statement provides a list of application_name from table fnd_application_tl. SQL does not require a new line for each clause, but using this formatting convention makes for easy readability.
SELECT APPLICATION_NAME from FND_APPLICATION_TL;
The SELECT list shows the single column called APPLICATION_NAME , which contains this information. The APPLICATION_NAME column is found on the FND_APPLICATION_TL table as specified in the FROM clause. When the statement is executed, the result set is a list of all the values found in the APPLICATION_NAME column of the FND_APPLICATION_TL table.
Retrieving Multiple Columns in SQL Developer
To retrieve a list of FND_APPLICATION_TL APPLICATION_NAME and the application_id of each FND_APPLICATION_TL, include the APPLICATION_ID column in the SELECT list.
SELECT APPLICATION_NAME, APPLICATION_ID FROM FND_APPLICATION_TL;
When you want to display more than one column in the SELECT list, separate the columns with commas. It is good practice to include a space after the comma for readability. The order of columns in a SELECT list determines the order in which the columns are displayed in the output.
Selecting All Columns
You can select all columns in a table with the asterisk (*) wildcard character. This is handy because it means you don’t have to type all columns in the SELECT list. The columns are displayed in the order in which they are defined in the table. This is the same order you see when you click the Columns tab in SQL Developer or issue the DESCRIBE command.
SELECT * FROM FND_APPLICATION_TL;