Substitution variables - PowerPoint PPT Presentation

Producing Readable Output with i SQL*Plus

Producing Readable Output with i SQL*Plus. Objectives. After completing this lesson, you should be able to do the following: Produce queries that require a substitution variable Customize the i SQL*Plus environment Produce more readable output Create and execute script files.

★ ★ ★ ★ ★

315 views • 29 slides

Data Manipulation Language (DML)

Data Manipulation Language (DML). Data Manipulation Language (DML). A DML statement is executed when you: Add new rows to a table Modify existing rows in a table Remove existing rows from a table A transaction consists of a collection of DML statements that form a logical unit of work.

★ ★ ★ ★ ★

573 views • 21 slides

Scripts and i SQL*Plus

Scripts and i SQL*Plus. SQL*Plus over the Internet. To connect to i SQL*Plus. NOTE!!!. The web page address is: The computer name (ferdia2.student.comp.dit.ie) A colon (:) The port number (5560) Followed by /isqlplus Logging on The Username is the schema name you have been given.

★ ★ ★ ★ ★

162 views • 8 slides

View Substitution variables PowerPoint (PPT) presentations online in SlideServe. SlideServe has a very huge collection of Substitution variables PowerPoint presentations. You can view or download Substitution variables presentations for your school assignment or business presentation. Browse for the presentations on every topic that you want.