What are the capabilities of a SELECT statement?

July 2nd, 2009 by uCertify Leave a reply »

Following are the capabilities of a SELECT statement:

  • Projection: This capability is used to choose the columns of a table, which a user wants a SELECT statement to return.

  • Selection: This capability is used to choose the rows of a table, which a user wants a SELECT statement to return.

  • Joining: This capability is used to retrieve data from multiple tables by creating a link between them.
    • Like this article? Share it with others
    If you like this article, please leave a comment or subscribe this blog via RSS or via e-mail, Bookmark and share through your network. Click the AddThis button below. Thanks.
    • Share/Bookmark

    Posted in Junior Level Linux Professional (LPIC-1), Linux Professional, OCA DBA 10g, OCA DBA 11g, OCA DBA 9i, OCA DBA 9i PL/SQL, OCA PL/SQL Developer, OCP DBA 10g, OCP DBA 11g, OCP DBA 9i, OCP PL/SQL Developer, Oracle Certified Master 10g, Oracle PL/SQL Developer, Performance Tuning Expert 11g, RAC Certified Expert 10g, SQL Certified Expert 10g, SQL Certified Expert 11g, UCP

    Tags:

    You can follow any responses to this entry through the RSS 2.0 Feed. You can leave a response , or trackback from your own site.

    Advertisement

    Leave a Reply

    uCertify.com | Our Company | Articles | Contact Us | News and Press Release | uCertify India | Entries (RSS)
    MCSE: MCSA, MCTS, MCITP    JAVA Certification: SCJP, SCWCD    Cisco Certification: CCNA, CCENT    A+, Network+, Security+ Project+
    Oracle Certification: OCP 11g, OCP 10g, OCA 11g, OCA 10g    CIW foundation    EC-212-32,    CISSP    Photoshop ACE CS4    Adobe Flash ACE, PMP, CAPM
    © 2008 uCertify.com. All rights reserved. All trademarks are the property of their respective owners.