25.67,-1
Trunc = 20
Round= 30
HOW????
Answers were Sorted based on User's Feedback
Answer / chandu
select trunc(25.67,-1),round(30) from dual;
TRUNC(25.67,-1) ROUND(30)
--------------- ----------
20 30
| Is This Answer Correct ? | 3 Yes | 3 No |
Answer / gaurav
The TRUNC (n1, n2) function returns n1 truncated to n2 decimal places. If n2 is omitted, then n1 is truncated to 0 places. n2 can be negative to truncate (make zero) n2 digits left of the decimal point.
if you do it -2. answer will be zero in this case.
similar thing goes for round.It will become zero.
| Is This Answer Correct ? | 0 Yes | 1 No |
Why use truncate instead of delete?
What is having clause in sql?
How to fetch the rows by dynamicaly passing table name through cursor?
Which is the correct statement about truncate and delete?
Explain the methods used to protect source code of pl/sql.
Explain alias in sql?
there are .......different types of serializability
What is the command used to fetch first 5 characters of the string?
What is sql character function?
Let us suppose we have a table with structure in order empno empname empdesig empcountry and now i want to re-organize the columns of this table to empno empdesig empname empcountry how can i do this with queries ? assume that table contains the data.
what is a trigger? : Sql dba
Hi Everyone, How to get fist and last record from a table in oracle? Thanks in advance
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)