Delete command - sql, PL-SQL Programming

DELETE Command - SQL

Loosely speaking, DELETE removes some existing rows from its target table. Suppose the university decides that course C3 is to be withdrawn. Example shows how.

Example: Withdrawing course C3, using DELETE

DELETE FROM COURSE WHERE CourseId = 'C3';

Every row that satisfies the given WHERE condition is deleted; rows that do not satisfy it remain in place.

Posted Date: 1/18/2013 11:38:47 PM | Location : United States







Related Discussions:- Delete command - sql, Assignment Help, Ask Question on Delete command - sql, Get Answer, Expert's Help, Delete command - sql Discussions

Write discussion on Delete command - sql
Your posts are moderated
Related Questions
heap sort program in pl/sql

Methods: In normal, a method is a subprogram declared in an object type specification using the keyword MEMBER or STATIC. The method cannot have similar name as the object typ

Overview of control structures According to the structure theorem, any computer program can be written by using the basic control structures as shown in figure below. They can b

Project Description: I want a database for large governmental and private data sets on one country that will be easily extended to other countries in the future. Also, the datab

PL SQL Code Review HEADER ELEMENTS File Name Clear, meaningful and descriptive about main objective of the file. Multiple words are joined using underscores which adh

Create a view named CustomerAddresses that shows the shipping and billing addresses for each customer in the MyGuitarShop database. This view should return these columns from the

Manipulating Local Collections Within PL/SQL, to manipulate the local collection, by using theĀ  TABLE and CAST operators . The operands of CAST are a collection declared locally

Primary Key - SQL A PRIMARY KEY specification carries an implicit NOT NULL constraint on each column of the specified key. When more than one key constraint is required, the k

Logical Operators The logical operators AND, NOT, and OR follow the tri-state logic shown in table below. The AND and OR are binary operators; NOT is a unary operator.

How Bulk Binds Improve Performance The assigning of values to the PL/SQL variables in SQL statements is known as binding. The binding of the whole collection at once is know