Whate is use of MOD function in pl/sql.

Answers were Sorted based on User's Feedback



Whate is use of MOD function in pl/sql...

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

Whate is use of MOD function in pl/sql...

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

Whate is use of MOD function in pl/sql...

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

Post New Answer

More SQL PLSQL Interview Questions

what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

0 Answers  


Why do we create stored procedures & functions in pl/sql and how are they different?

0 Answers  


What are the types pl/sql code blocks?

0 Answers  


what is the purpose of update command in oracle?

7 Answers   MBT,


Is join an inner join?

0 Answers  






What is sql not null constraint?

0 Answers  


What is difference between my sql and sql?

0 Answers  


Explain sql data types?

0 Answers  


How do I order by ascending in sql?

0 Answers  


Please let me know if UNION ALL and Natural Join does the same operation and are same...

7 Answers   iGate,


How can check sql version from command line?

0 Answers  


define sql update statement ? : Sql dba

0 Answers  


Categories