Whate is use of MOD function in pl/sql.
Answers were Sorted based on User's Feedback
Answer / prabu t
Same as other languages, returns remainder.
eg. select mod(5,3) as remainder from dual;
output
remainder
---------
2
| Is This Answer Correct ? | 11 Yes | 0 No |
Answer / dipti
it returns the reminder.
eg:-select mod(10,5) as modulus from dual;
o/p-:
modulus
------------
0
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / srinivas
It Displays the remainder.
Ex:
select mod(10,5),mod(5,2) from dual;
O/P: mod(10,5) mod(5,2)
0 1
| Is This Answer Correct ? | 2 Yes | 0 No |
What is the meaning of disabling a trigger?
Can triggers stop a dml statement from executing on a table?
Can you have a foreign key without a primary key?
How do I clear the screen in sql plus?
How to find only %th Highest Sal
What are the components of a PL/SQL block ?
What is case function?
What view means?
Source is Sales Table: Sno Prod Sales Sales_Amount 1 A 10 2000 2 A 20 1000 3 C 10 3000 4 D 30 4000 5 A 20 1000 Target : Sales_Count T_Sales_Amt Sales_Count(A) T_Sales_Amt(A) 90 11000 50 4000 In single query, pls tell me.
Difference between aggregate function and analytical function?
how tsql statements can be written and submitted to the database engine? : Transact sql
Find out the 3rd highest salary?
51 Answers BirlaSoft, DAC, Silvia Infotech, Sutra Infotech,
Oracle (3253)
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)