Retrieving data using the SQL SELECT statement and using single row functions to customize the output

  • /*…*/ and — are used to put comments in an Oracle program.
  • The CREATE TABLE does not end immediately with a semicolon, and a column name cannot start with a numeric value. However, a numeric value can be used in between a column name.
  • Name of a table cannot start with @ special character.
  • Knowing about the GROUP BY clause.

Using sub queries and set operators to solve queries, as well as DDL statements to create and manage tables

  • + (unary), – (unary), *, /, ||, =, !=, <, >, <=, >=, IS NULL, LIKE, BETWEEN, IN, NOT, AND, OR is the correct order of operators precedence.
  • Continue reading

muhanad-younis
muhanad-younis

Muhanad is a Microsoft.NET purist and an MCP,MCAD,MCSD and he is working as a Senior Developer and Technical Leader at TurkSat Turkey.In the Past Muhanad has worked as a Senior Developer at Sentim.He had also worked as an Export Expert at Motali. In addition to this He had been associated with REEM Network and worked there as a CEO of the company.

He has specialized in E-Government and Entreprise projects,specialized in framework development and projects infrastructure preparation to give developers more stable and consistent platform.

Out of his interest and curiosity in learning more and more about latest technologies, Muhanad writes about various new technologies and certifications. His articles can be read on http://weblogs.asp.net/muhanadyounis/

After reviwing the uCertify PrepKit 70-553, Muhanad said “I did not think that studying for IT exams could come that much easy, but after I saw the uCertify package, I believed that there is no way to FAIL!”

Continue reading