Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Bitwise right (or Left) shift functions in PL/SQL

Status
Not open for further replies.

tekmilind

Programmer
May 22, 2002
6
US
Hi,
I have to right (or left) shift binary numbers in Oracle PL/SQL. Is there any function that will achieve this?


Thanks in advance for the help.
- Milind
 
I'm sure you know that a shift operation on a binary number correspondsponds to a multiplication or division by a power of two. Is there any reason you can't just do the appropriate arithmetic?

As far as I know there is no actual register shift operation in PL/SQL. That's the sort of thing better done in machine language, or maybe with a external procedure call.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top