 Related Questions TABLESVIEWSINDEXESSYNONYMSSEQUENCESTABLESPACES etc Latest Answer : The different Oracle Database objects are: Table View Index Synonym TableSpace ... 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: ALTER TABLE table_name RENAME TO table_name1 (here the table_name is changed to table_name1 and table_name1 is stored in database.)Alias: SELECT column_name "Col1" FROM table_name(here Col1 is not stored in database.) ... SELECTCONNECTRESOURCES Latest Answer : objectes privileges such asselect,delete,update,connect ... 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 ... 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 FROM table_name a WHERE rowid > (SELECT min(rowid) FROM table_name b WHERE a.column_name=b.column_name) ... 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 : Avoid using HAVING clause in SELECT statement as it filters selected rows only after all rows have been fetched. Instead use WHERE clause to reduce overheads.select empno, ename from emp group by deptno having deptno=10;In the above case first grouping ... SELECT * FROM empWhere emp_no+' '=12345;i.e you have to concatenate the column name with space within codes in the where condition.SELECT /*+ FULL(a) */ ename, emp_no from empwhere emp_no=1234;i.e Latest Answer : One way is to diable the index on the column using syntaxAlter index indexname on table_name disable.One way is to apply /*+no_index */ hint to the query For eg: select ename /*+no_index */from empwhere ename ='smith' ... It is a column that is not an actual column in the table.eg USER, UID, SYSDATE, ROWNUM, ROWID, NULL, AND LEVEL. Latest Answer : Pseudo columns is not actula column in the table. it behaves like table columnwe can retivesv values of pseduo column but can not insert,update or delete value in that.has two data type 1. rowid 2. urowidrow id uniqely identify row in databaseEXM ... Suppose a customer table is having different columns like customer no, payments.What will be the query to select top three max payments? SELECT customer_no, payments from customer C1WHERE 3
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
