Query:

SELECT * FROM EMPLOYEE1;

Select 5 columns and all rows from one table

Query:

SELECT C_ID, COMPANY, BUILDING, DEPARTMENT, BRANCH FROM CONTRACT;

 

Posted Date: 3/14/2013 1:58:42 AM | Location : United States

Ask an Expert

Related Discussions:- Select query, Assignment Help, Ask Question on Select query, Get Answer, Expert's Help, Select query Discussions

Write discussion on Select query
Your posts are moderated

Write your message here..

Related Questions

Keyword and parameter description - goto statement, Keyword and Parameter D... Keyword and Parameter Description: label_name: This is an undeclared identifier which labels an executable statement or the PL/SQL block. You can use a GOTO statement to

Defining records, Defining and Declaring Records To create records, yo... Defining and Declaring Records To create records, you have to define a RECORD type, and then declare records of that type. You may also define RECORD types in the declarative

Operators on tables and rows, Operators on Tables and Rows Row Extrac... Operators on Tables and Rows Row Extraction TUPLE FROM r, SQL has row subqueries. These are just like scalar subqueries except that they may specify more than one column.

Naming conventions-pl/sql, Naming Conventions The similar naming conventi... Naming Conventions The similar naming conventions apply to all PL/SQL program items and units including the variables, cursors, constants, cursor variables, procedures, exception

Use triggers to maintain referential integrity, At times, Brewbean's has ch... At times, Brewbean's has changed the id number for existing products. In the past, they have had to add a new product row with the new id to the BB_PRODUCT table, modify all the co

Deriving predicates from predicates in sql, Deriving Predicates from Predic... Deriving Predicates from Predicates in SQL The corresponding section in the theory book describes how predicates can be derived from predicates using (a) the logical connectiv

When or then key constraints, WHEN or THEN Key Constraints Suppose a t... WHEN or THEN Key Constraints Suppose a table has two columns representing a period of time throughout which the information conveyed by the other columns is recorded as having

Return statement, RETURN Statement The RETURN statement instantly compl... RETURN Statement The RETURN statement instantly completes the execution of a subprogram and returns control to the caller. The Execution then resumes with the statement below t

Literals in pl/sql, Literals A literal is an explicit numeric, string... Literals A literal is an explicit numeric, string, character, or Boolean value not represented by an identifier. Numeric literal 147 and the Boolean literal FALSE are some of

Implicit rollbacks, Implicit Rollbacks Before execute the INSERT, UPDA... Implicit Rollbacks Before execute the INSERT, UPDATE, or DELETE statement, the Oracle marks an implicit savepoint . When the statement fails, the Oracle rolls back to the save