Transcription of Writing Basic SQL Statements - baskent.edu.tr
{{id}} {{{paragraph}}}
Example: bankruptcy
Writing Basic SQL Statements - baskent.edu.tr
Chapter 1 Writing Basic SQL Statements1 ObjectivesAfter completing this lesson, you should be able to do the following: List the capabilities of SQL SELECT Statements Execute a Basic SELECT statement Differentiate between SQL Statements and SQL*Plus commands Lesson AimTo extract data from the database. you need to use the structured query language (SQL) SELECT statement You may need to restrict the columns that are displayed. This lesson describes all Ihe SQL Statements that you need to perform these may want to create SELECT Statements that can be used time and time again. Tins lesson also covers the use of SQL*Plus commands to execute SQL statements2 Capabilities of SQL SELECT Statements SelectionProjectionTable 1 Table 2 Capabilities of SQL SELECT StatementsA SELECT statement retrieves information from the database. Using a SELECT statement, you can do the following:Selection: You can use the selection capability in SQL to choose the rows in a table that you want returned by a query.
Objectives After completing this lesson, you should be able to do the following: •List the capabilities of SQL SELECT statements •Execute a basic SELECT statement •Differentiate between SQL statements and SQL*Plus commands Lesson Aim To extract data from the database. you need to use the structured query
Loading..
Tags:
Information
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document: