0
it's exactly the same as in Microsoft, as it's standard SQL
Delete from X
where Y=Z
X = table name
Y = field name
Z = value
Wiki User
∙ 14y ago
Add your answer:
Earn +20 pts
What query will delete all the records satisfying the criteria enter in the query?
A delete query.A delete query.A delete query.A delete query.A delete query.A delete query.A delete query.A delete query.A delete query.A delete query.A delete query.
What is mean by distinct in oracle?
the distinct in oracle is there is no repetition of data in a query
If you delete query does it delete the original information in the table?
Your question is unclear. If you mean if you delete a query, then it does not affect the data in the table. Deleting any kind of query does not affect the data in any table it uses. If you mean if you run a Delete query, then yes the data in the table will be deleted. That is what Delete queries are for.
What kind of query can change the contents of a table A selection query cannot?
There are several types that can do it. A Delete Query, an Update Query and an Append Query can. You can also create and delete entire tables with queries.
How do you delete row in oracle table from vb?
you right click it and you scole down to delete row in oracle table that should work
What is meant by the term merge SQL with the Oracle software?
SQL - Structured Query Language - is a standardised query language for requesting information from a database. It was first introduced as a commercial database system by Oracle Corporation.
How do you view users permissions in oracle database via sql query?
ask the DBA
What are the differences between Oracle and SQL?
Oracle is an RDBMS aka Relational Database Management System and SQL (Structured Query Language) is a programming language.
How do you delete a field in Design view?
Whether you are designing a table or a query, select the field by clicking beside it in a table or above it in a query, so that it is highlighted. Then press the delete key.
What adds deletes or changes data in a table?
delete query
Definition of llist of value in oracle forms?
List of Values (LOV) is a small pop up window that allows user to select a single or a multiple column in an oracle form. Lov can be created based on SELECT query, non-select query or static values
How do you remove oracleserviceXE present in our system?
We remove this service from command prompt.. type sc delete oracleserviceXE eg. C:\ sc delete oracle serviceXE
