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 Mike Lewis 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. irvina

    test questions for oracle OCP test

    Here are two sites. http://www.selftestsoftware.com/shop/dept.asp?dept_id=600 http://www.cert21.com The first is recommended by Oracle and is similar in format to the exams (downloadable file). There are more sites out there with practice questions...you can find them with a google search. I...
  2. irvina

    group by CUBE precision problem

    I have a problem with the CUBE functionality. Is there a way of specifying the precision of the end result? Below is my query and the results. It all looks good until the last line which is the grand total line. The value reads xxx.04 but should in fact be xxx.035 ! Can anyone help me...
  3. irvina

    SQLPLUS Logon Question Please

    Try getting the user and host name (or instance_name) from the db and make a prompt with the information. Therefore, same script, different prompt. column uname new_value un select User || '@'|| upper(host_name) uname from v$instance; set sqlprompt "&un.> "
  4. irvina

    12 Digit DataBase key for CD included with Couchman's book

    The 12 digit key is in the book itself. I think it is in the back of the book, there's a section about the CD and the key is in there. Sorry I can't be more specific... Happy hunting!
  5. irvina

    Prepending fields

    You can also use LPAD(your_value, 10, '0'). LPAD is an Oracle built in function and is used to Left PAD your_value to a length of 10 using '0' as its filler. So, LPAD(19, 10, '0') will give you 0000000019. You can use LPAD in any of your insert (or other) statements.

Part and Inventory Search

Back
Top