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!

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

Search results for query: *

  1. Anto318

    VB PING Function

    Hi all, I'm new to VB and I hope you can help me with this VB script. Here is the background of what I need to do. I have created 9 VB scripts that pull information from a database and display these results into a table. That is pretty much all that the VB script is doing. What I am having...
  2. Anto318

    Rounding Script

    The problem I am having is trying to transfer the technique used into my script There is one thing though. The script that I need has to round to the next highest number at a defined number of significant numbers Each of the examples I put down are rounded to 2 significant figures: e.g...
  3. Anto318

    Rounding Script

    I modified the code you gave me yesterday to work with my stuff and it came out like this Select Case when round(3.14159, 3) < 3.14159 then round(3.14159, 3) + (1/power(10,3)) else round(3.14159, 3) end from dual; Sorry to be annoying you but I am still completely lost, I can't modify the...
  4. Anto318

    Rounding Script

    Hi all, I need to write a script that will round a figure to the next highest number at a defined number of significant figures examples of what I am looking for are: 0.0215 gives .022 0.215 gives 0.22 2.15 gives 2.2 21.5 gives 22 215.00 gives 220 2150.0 gives 2200 2149.0 gives 2200 21500.00...
  5. Anto318

    RoundUp sqlplus script

    Works perfectly, thank you. I have one more that I can't get my head around if you have time would you be able to have a look at it carp?! I don't want to be greedy but if you have time i'd really appreciate it. Just leave a message if you have time
  6. Anto318

    RoundUp sqlplus script

    thank you very much i'll try that and report back. Thank you again
  7. Anto318

    RoundUp sqlplus script

    thank you very much carp, thats exactly what im looking for I hope you can help I have a very very basic knowledge of this stuff and this is way out of my range. I hope you can help
  8. Anto318

    RoundUp sqlplus script

    No sorry it needs to round UP to so from your example (10.456,2) the result will be 10.46 the script needs to round up the value not just round another example is (3.14159,3) would be 3.142 I hope that clears it up thats why its driving me mad if it was just a round it would br fine...
  9. Anto318

    RoundUp sqlplus script

    Hi all, I am new to this site and oracle sqlplus in general. I need some help, I need to write a script that will round a figure to the next highest number at a defined number of decimal places e.g. (3.2,0) gives 4 (76.9,0) gives 77 (3.14159,3) gives 3.142 (-3.14159,1) gives -3.2...

Part and Inventory Search

Back
Top