which operation is used if we are interested in only certain columns of a
table?

Posted Date: 5/11/2015 11:24:01 AM | Location :

Ask an Expert

Related Discussions:- introduction to SQl and DQL, Assignment Help, Ask Question on introduction to SQl and DQL, Get Answer, Expert's Help, introduction to SQl and DQL Discussions

Write discussion on introduction to SQl and DQL
Your posts are moderated

Write your message here..

Related Questions

Running the pl/sql wrapper, Running the PL/SQL Wrapper To run the PL/SQ... Running the PL/SQL Wrapper To run the PL/SQL Wrapper, go through the wrap command at your operating system prompt by using the syntax as shown: wrap iname=input_file [oname=

Using %rowtype-declarations in sql, Using %ROWTYPE The %ROWTYPE attribut... Using %ROWTYPE The %ROWTYPE attribute gives a record type which represents a row in a table (or view). The record can store the whole row of data selected from the table or fetc

Database values-assignments in pl/sql, Database Values You can use the S... Database Values You can use the SELECT statement to have the Oracle assign values to a variable. For Each and every item in the select list, there must be a matching, type-compa

Multiple assignment - sql, Multiple Assignment- SQL SQL supports mult... Multiple Assignment- SQL SQL supports multiple assignment to local variables and also applies multiple assignment semantics in SET clauses of UPDATE statements, but does not

Components of an object type - attributes in pl/sql, Attributes: Just ... Attributes: Just similar to variable, an attribute is declared with a name and datatype. The name should be exclusive within the object type. The datatype can be any Oracle ty

Seeking a programmer to design a legal document, Seeking a programmer to de... Seeking a programmer to design a legal document with pre-existing fields that could allow the auto-population of client(s) information (i.e. Name, Account Number, Address etc.) int

How transactions guard your database, How Transactions Guard Your Database ... How Transactions Guard Your Database The transaction is a sequence of SQL data manipulation statements which does a logical unit of work. The Oracle treats the sequence of SQL

Triggers, At times, customers make mistakes in submitting their orders and ... At times, customers make mistakes in submitting their orders and call to cancel the order. Brewbean’s wants to create a trigger that automatically updates the stock level of all pr

Theory of biogenesis, THEORY OF BIOGENESIS - This theory explains th... THEORY OF BIOGENESIS - This theory explains that the existing living organisms originated from pre-existing living beings not from non living entities. This concept of or

%notfound - explicit cursor attributes, %NOTFOUND The %NOTFOUND is log... %NOTFOUND The %NOTFOUND is logical, opposite of the %FOUND. The %NOTFOUND yields FALSE if the last fetch returned a row, or TRUE when the final fetch failed to return a row. I