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 |
how to remove records from table? no name 1 a 2 b 1 a 2 b 3 c
How to select random rows from a table?
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.
What is sql deadlock?
what is a trigger? : Sql dba
How long does it take to learn pl sql?
what are the nonstandard string types? : Sql dba
what is view? : Sql dba
What are the uses of merge?
What are the Diff B/W Cursor and REF Cursor
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?
Why do we need pl sql?