GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Oracle
Go To First  |  Previous Question  |  Next Question 
 Oracle  |  Question 10 of 81    Print  
What are the advantages and disadvantages, compared to the standard SQL and SQL*plus ?

  
Total Answers and Comments: 4 Last Update: August 24, 2007     Asked by: Sushanta K. Mishra 
  
 Sponsored Links

 
February 26, 2006 03:49:46   #1  
M. RAVI SANKAR        

RE: What are the advantages and disadvantages, compare...

Q.1 What are the advantages and disadvantages compared to the standard SQL and SQL*plus ?
Q.2 when i type 'ed' or 'edit' in oracle i did n't presented by any editor what is the problem?
Q.3 what is the difference between 11.5.7 and 11.5.10 versions of oracle applications

.


 
Is this answer useful? Yes | NoAnswer is useful 1   Answer is not useful 0Overall Rating: +1    
March 09, 2006 03:24:52   #2  
KAWOOYA JANAT        

RE: What are the advantages and disadvantages of data warehouse
fine
 
Is this answer useful? Yes | No
April 13, 2006 02:05:05   #3  
Asim Jamal        

RE: What are the advantages and disadvantages, compare...

Standard SQL:

SQL is a very simple and powerful database access language. It is a nonprocedural language and the user describe in SQL what he wants to do and the SQL language compiler automatically generates a procedure to navigate the database and perform the desired and reqired task.

IBM Research developed and defined SQL and ANSI/ISO has defined SQL as the standard language for relational database management systems. The SQL implemented by Oracle Corporation for Oracle is fully compliant with the ANSI/ISO 1992 standard SQL data language.

Oracle SQL includes many versions to the ANSI/ISO standard SQL language and Oracle tools and applications provide additional commands. The Oracle tool SQL*Plus allow you to execute ANSI/ISO standard SQL statement against an Oracle database as well as additional commands or functions .

So using SQL*Plus is more advantageous than Standard SQL becuase we have got more facilities while using Standard SQL is core language.


 
Is this answer useful? Yes | No
August 24, 2007 13:20:10   #4  
Jeremy        

RE: What are the advantages and disadvantages, compare...
SQL*Plus is a client program and interactive interpreter designed for interacting with Oracle databases. SQL is a standard data access language used to describe data access to a variety of databases. They have nothing to do with each other.

SQL*Plus is *not* the term for Oracle's SQL extensions or interpretations of the standard. It's *not* a synonym for PL/SQL. This would be the sort of trick question I might ask (if I asked trick questions) to see if someone can be taken seriously. It's a troll in other words.

 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape