 Related Questions Self join-Its a join foreign key of a table references the same table. Outer Join--Its a join condition used where One can query all the rows of one of the tables in the join condition even though they Latest Answer : Please let me know various joins available and description for every joinRegards,sireesha ... 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 ... 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. ... SUBSTR returns a specified portion of a string eg SUBSTR('BCDEF',4) output BCDEINSTR provides character position in which a pattern is found in a string. eg INSTR('ABC-DC-F','-',2) Latest Answer : hi Buddy, Substr only give the sub part of the stringSubstr(String,'start postion','length')Substr('ABCDEFAG',3,7); /*out put is =cdefag */Instr to give only possion of letter in use in a stringInstr(String,'letter',possition ... '' Should be used before '%'. Latest Answer : select * from emp where instr('ename','%')!=0 ... Outer Join--Its a join condition used where you can query all the rows of one of the tables in the join condition even though they don’t satisfy the join condition. Latest Answer : outer join is that type of jon which retrives the matach & alson unmatached recores also from the tables ... 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' ... 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
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2 
0