 Related Questions SELECT REPLACE(TRANSLATE(LTRIM(RTRIM('!! ATHEN !!','!'), '!'), 'AN', '**'),'*','TROUBLE') FROM DUAL;TROUBLETHETROUBLE Latest Answer : The rtrim function requires 1 argument(s). ... SELECT SAL + NVL(COMM,0) FROM EMP;This displays the total salary of all employees. The null values in the commission column will be replaced by 0 and added to salary. Latest Answer : Insted of NVL use SELECT SAL + isnull(COMM,0) FROM EMP which will convert null values to 0 of the field COMM ... What is the value of comm and sal after executing the following query if the initial value of ‘sal’ is 10000? UPDATE EMP SET SAL = SAL + 1000, COMM = SAL*0.1;sal = 11000, comm = 1000 Answer :DESC has two purposes. It is used to describe a schema as well as to retrieve rows from table in descending order.Explanation : The query SELECT * FROM EMP ORDER BY ENAME DESC will display the Latest Answer : DESC[RIBE] is a SQL*Plus command It is used to describe an Oracle Table, View, Synonym, package or Function.Note that because this is a SQL*Plus command you don't need to terminate it with a semicolon.Syntax: DESC table DESC view DESC synonym ... SELECT TRUNC(1234.5678,-2) FROM DUAL;1200 Latest Answer : if the -ive parameter is passed under TRUNC function truncation will be used to below decimal place i.e-1 means Trunc to 10th (1234 becomes 1230)-2 means trunc to 100th (1234 becomes 1200)-3 means trunc to 1000th (1234 becomes 1000)These parameters can ... Latest Answer : Single row subqueries returns only one row of results.A single row sub query uses a single row operator; the common operator is the equality operator(=). A Scalar subquery returns exactly one column value from one row.Scalar subqueris can be ysed ... I have a table with duplicate names in it. Write me a query which returns only duplicate rows with number of times they are repeated? Latest Answer : Use DBMS_JOB for scheduling a cron job and DBMS_MAIL to send the results throught email. ... Is there any query which is use to find the case sensitivity in each records in database through visual basic? Co-related sub query is one in which inner query is evaluated only once and from that result outer query is evaluated.Nested query is one in which Inner query is evaluated for multiple times for gatting Latest Answer : If the evaluation of an inner querry(a sub querry) depends on a variable which gets its value in an outer querry,such a subquerry has to be evaluated for each value of the variable.Such a querry is a correlated subquerry.If no such variable is used,the ... Read Answers (4) | Asked by : Chirag
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
