Recent content by Ruby

  1. R

    PIVOT

    Apparently there are new PIVOT/UNPIVOT functions in Oracle 11g. Can someone please give me a working example? Thanks, Ruby
  2. R

    System Security

    Good afternoon, We have been having some discussions around the use of the apps user name and password as well as change control . Our auditors are not very comfortable with our current set-up where all parties involved (about 11 of us) all use the same user name and password (username apps)...
  3. R

    Calculate Net Present Value

    Hi, We have managed to write our own code for this.
  4. R

    Calculate Net Present Value

    Hi There, Has anyone got teh solution to performing the Excel Net Present Value Calculation in SQL? Would really appreciate some guidelines. Thanks
  5. R

    Multiple log-in profiles

    Hi There, Please help. I access a 9i and a 10g database via PL/SQL. Everytime I switch between the two, I have to go Tools/Preferences/customise - make my change to the relevant home directory/apply/ log out/ log back in and off I go again. Is there no way I can set up a shortcut for each...
  6. R

    Table usage

    Thank you - this really helped!
  7. R

    Table usage

    Hi There, Not only are we new to PL/SQL Developer, but also new to Oracle. Can anyone tell me an easy way of extracting all tables, with their current sizes in one report? I am trying to establish exactly which tables are in use. Thank you Ruby Bosch
See more
Back
Top