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

how to remove records from table? no name 1 a 2 b 1 a 2 b 3 c

8 Answers   Oracle,


How to select random rows from a table?

0 Answers  


I have 2 table A and B. In A 1 lakh record is present. In b 20 thousand data is present. To get the unique data from table A and B which join we should prefer left inner join or right outer join. Please answer.

4 Answers   GE,


What is sql deadlock?

0 Answers  


what is a trigger? : Sql dba

0 Answers  






How long does it take to learn pl sql?

0 Answers  


what are the nonstandard string types? : Sql dba

0 Answers  


what is view? : Sql dba

0 Answers  


What are the uses of merge?

0 Answers  


What are the Diff B/W Cursor and REF Cursor

3 Answers   CTS,


I have the table like this S.No Name ID 01 Xyz 123 I want the result as 01Xyz123 How to write the query to retrieve the entire row data in a single column?

1 Answers  


Why do we need pl sql?

0 Answers  


Categories