Whate is use of MOD function in pl/sql.
- 3 Answers
- 6191 Views
- Oracle, I also Faced
- E-Mail Answers
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 are tables and fields?
What does data normalization mean?
what is the difference between sql and t-sql? : Transact sql
What are pl sql data types?
if table named a is there and 4 records are there then how to swap (1 and 3) and (2 and 4) records at a time
Which language is used in sql?
Can we use commit or rollback in trigger? If yes, then how. Please explain with a suitable example?
How can I tell if sql is running?
How can we make an if statement within a select statement?
What is a parameter query?
How do you modify a column in sql?
What is a natural join?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
