0
yes....
example:
select *from employee;
dml command in sql language
Wiki User
∙ 12y ago
Add your answer:
Earn +20 pts
Difference between sql and sql plus?
SQL*PLUS is a interface between user and Oracle database. It Provide an environment to use the SQL which is a query language to communicate with oracle database
What is the function of an SQL Loader?
SQL Loader is a utility used to load data from external files into an Oracle database. It can handle loading large volumes of data quickly and efficiently, and provides flexibility in mapping data from files to database tables. It is commonly used for bulk data loading tasks.
What is teradata in data warehousing?
Teradata is a RDBMS system like Oracle or SQL Server but designed specifically for use in data warehousing. Data Warehouses contain extremely large amounts of data that normal RDBMS systems like oracle or sql server cannot handle comfortably. They may eventually be able handle the data but their performance may not be the best. Teradata is a system that is specifically designed for handling such extremely high volumnes of data.
Why do people actually use an Oracle SQL?
People actually use an Oracle SQL because the program helps to navigate and complete the task one has. This helps to get work done faster and more efficiently.
What is the difference between sql and pl-sql?
Platform dependency-The primary difference is with respect to platform dependency, SQL is basically limited to the Windows platform where as Oracle is operable on multiple platforms such as Windows, UNIX and Linux etc. This multi-platform compatibility of Oracle makes it a universal enterprise solution, which makes it mandatory for the Oracle DBA to be acquainted with the different platforms where as the Sql DBA just needs to be familiar with the windows platform..Clustering technology-Oracle is significantly ahead of its opponent when it comes to clustering technology, Oracle makes use of RAC technology which enables two instances to act on the same data in active-active configurations.Locking and concurrency -Oracle had a multi-version consistency model which means that "readers don't block writers and writers don't block readers." Sql on the other hand has a very simple locking mechanism which follows the rule that "writers block readers and readers block writers."File system-Oracle includes IFS (Internet File System), Java integration, SQL is more of a pure database.Replication -SQL Server provides a far more simple and flexible system for replication and synchronizing of data when compared to Oracle, it involves a set of technologies for copying and distributing data and database objects from one database to another and then synchronizing between databases to maintain consistency.Administration-SQL server GUI is simple and easy to work with where as the Oracle server is not very user friendly as most of it command line is based.by....... Sankar
What has the author Jonathan Sayles written?
Jonathan Sayles has written: 'Oracle Sql*Plus for Application Developers' 'QMF' -- subject(s): Database management, IBM Database 2., QMF, SQL/DS 'SQL as a second language' 'SQL for dBASE IV' -- subject(s): DBase IV (Computer file), Database management, SQL (Computer program language) 'How to use Oracle SQL*Plus' -- subject(s): Oracle (Computer file), SQL (Computer program language)
What are the similarities between oracle dbms and access dbms?
Oracle and Access are both RDBMS's (Relational Database Management Systems). Consequently they both use tables which have 'keys' to retrieve rows, and use 'foreign keys' to other tables to 'relate' those rows together. Oracle and Access also both use SQL (Structured Query Language) to allow you to use the database (for example: "select * from customer_table where customer_number = '12345'"), although you can use tools which provide a more graphical environment to produce the underlying SQL. The real difference between the two is that Oracle is an industrial strength RDBMS.
What should you learn to query a data base?
To query databases, one should learn the Structured Query Language (SQL). While most versions of databases havedifferentsyntaxes (usually by way of adding "extensions" to the SQL standard), learning SQL will provide most of what one would need to know to learn how to use a specific database product, such as MySQL, Access (T-SQL), and Oracle (PL/SQL).
What can I do to make a webpage using only HTML which is related to social networking sites?
You need to use backend tools also to save the data. A DB like SQL or Oracle could work with it.
How is Oracle connected with C or C plus plus?
Need to find out the Oracle Connecting driver's that work for C or C++. e.g. Java uses JDBC-ODBC driver to connect to Oracle data base ..... (4 different types of JDBC drivers are available) There should be such drivers for C or C++ language as well ..... Google on C++ Oracle driver .... You can use the Oracle precompiler (Pro*C) or the Oracle Call Interface (OCI). OCILIB is an open source and cross platform Oracle Driver that delivers really fast and reliable access to Oracle databases.
What are SQL data types used for?
There are many purposes behind 'SQL' data types. The most common use of 'SQL' is with website programming and hosting services, as well as HTML coding.
What is the use of the SQL sort?
The use of sorting information in SQL is to organize database query results. Typically the data can be sorted in either ascending or descending order. The "Order By" command can be used to sort data in SQL by multiple columns.
