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
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.
the distinct in oracle is there is no repetition of data in a query
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.
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.
you right click it and you scole down to delete row in oracle table that should work
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.
ask the DBA
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.
Oracle is an RDBMS aka Relational Database Management System and SQL (Structured Query Language) is a programming language.
delete query
Right click the column heading. Then click delete field from the shortcut menu.
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