Oracle does not allow a user to specifically locate tables, since that is a part of the function of the RDBMS. However, for the purpose of increasing performance, oracle allows a developer to create a
Latest Answer: Clustering is a method of storing tables that are intimately related and often joined together into the same area on disk. For example, instead of the BOOKSHELF table being in one section of the disk and the BOOKSHELF_AUTHOR table being somewhere else, ...
A view is stored procedure based on one or more tables, it’s a virtual table.
Latest Answer: View
View is logical table based on one are more table join and named as viewname
View is not stored in database View is used to perform complex query, View Object,
View support, LOB, varray, Nested Tables Should have CREATE ...
delete from table_name where rowid not in (select max(rowid) from table group by duplicate_values_field_name); ordelete duplicate_values_field_name dv from table_name ta where rowid
Latest Answer: Delete table_name t1where rowid>(select rowid from table_name t2)and t1.column1=t2.column1 ...
Rename is a permanent name given to a table or column whereas Alias is a temporary name given to a table or column which do not exist once the SQL statement is executed.
Latest Answer: Rename means give the new name to existed objects alise is use to refrence to objects ...
SELECTCONNECTRESOURCES
Latest Answer: objectes privileges such asselect,delete,update,connect ...
A table can have only one PRIMARY KEY whereas there can be any number of UNIQUE keys. The columns that compose PK are automatically define NOT NULL, whereas a column that compose a UNIQUE is not automatically
Latest Answer: Primay Key Unique key----------- ...
By using DISTINCT
Latest Answer: SELECT cons_no, COUNT(cons_no) FROM master HAVING COUNT(cons_no)>1GROUP BY cons_no; ...
SQL*PLUS is a command line tool where as SQL and PL/SQL language interface and reporting tool. Its a command line tool that allows user to type SQL commands to be executed directly against an Oracle database.
Latest Answer: SQL keywords cannot be abbrevated but SQL*PLUS keywords can be abbrevated. ...
LONG RAW data type is used for storing BLOB's (binary large objects).
Latest Answer: Hi,BLOB is generally used to store pictures. It stands for Binary Large Object. The maximum storage limit is 4GB. There is also one limitation using BLOB, you can have only one column of type BLOB.Cheers,Tarun ...
HAVING clause is used when you want to specify a condition for a group function and it is written after GROUP BY clause. The WHERE clause is used when you want to specify a condition for columns, single
Latest Answer: when query is based on condition we use where clause & there is no any aggregate functionwhen query is base on contion & aggregate function has to be use then we can usehaving clause. ...
View page << Previous 10 11 12 13 [14] 15 16 17 18 Next >>
Go Top
