select trunc(round(156.00,-1),-1) from dual;
Answers were Sorted based on User's Feedback
Answer / rakesh anand
TRUNC(ROUND(156.00,-1),-1)
----------------------------
160
Is This Answer Correct ? | 32 Yes | 2 No |
I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.
find the second highest salary of the emp table
Hi how Can I Add A Foreign key that references a table that has composit primary key ? example i had costumer table that has C_Id and SSN Both as PK and another table has C_Id that must refernece C_Id in Customers i done the usual way and got oracle error message about uniqeness any ideas plz
Table1- have two column filename data AFGDFD-20112011 hi how r u bsdasd-23042011 name shoud be in bold Now i want output like filename data AFGDFD hi how r u bsdasd name shoud be in bold Kindly answer this
What is a trigger and what are its types?
The table has 3 columns 4 rows. The output is which column has least null values( A COL SHOULD BE THE OUTPUT) Write the query plz. A B C ================ 1 NULL 2 NULL 3 4 NULL 5 6 7 NULL NULL O/P C = 2 4 6
What are advantages of dateset in datastage?
What are joins, explain all types of joins?
write a query to count number of alphabets in given string for example "APPLE" write a query to generate sequence from 50 to 100 write a query to display in single string "ABCD,EFGH,IJKL,PQRS"
How to convert csv to table in oracle?
1.how to extract the second highest salary from emp table having sal as a column which contains the salary of all employee of an organisation.
how do u know the total no of rows in a table?