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 packages are available to pl/sql developers?
Can a foreign key have a different name?
What is trigger price?
select 1,col1,col2 from table1. output?
Is merge a dml statement?
Why do we need cursors in pl sql?
What is an oracle stored procedure?
A table was given with 3 columns like Manager id,Manager Name and Employee name. Question was to create hierarchy.
What is a trigger word?
What is multiple partition?
What is rename in sql?
how do you restrict number of rows for a particular value in a column.For example:there is a table called fruits,having apples,bananas ,papayas.I dont want to have more than 100 apples in that table ,so how can u restrict number of rows for apple to hundred?
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)