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 derfloh 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. oracleraj

    CASE or DECODE with ORDER BY

    ----- Sorry i tryied your solution but it doesn't work ---- Look at following code ----- Also see the output declare v_var char(4) := 'Col1'; begin declare cursor c1 is select uomid,tomsrid,uomdesc from bduommst order by to_number(decode(v_var,'Col1',1,'Col2',2,3),'0')...
  2. oracleraj

    CASE or DECODE with ORDER BY

    declare v_var char(4) := 'Col1'; begin declare cursor c1 is select uomid,tomsrid,uomdesc from bduommst order by to_number(decode(v_var,'Col1',1,'Col2',2,3),'0') desc; begin for r1 in c1 loop dbms_output.put_line(r1.uomid); end loop...
  3. oracleraj

    run command hourly

    use crontab -e it will open u the editor like vi update it #minute hour day month dayof the script to be # week executed #0-59) (0-23) (1-31) (1-12) (0-6 with # 0=Sunday) 49 8 * *...
  4. oracleraj

    Basic SQL question

    but if the data in the column is bigger in length. this will happen when u reduce the size of the column so in such cases first make the columns blank or alteast those rows blanks which are having bigger data. by using update clause. update <table_name> set <field_name> = value (normally NULL)...
  5. oracleraj

    Insert Trigger Help

    hi The solution for handling mutating trigger is given in oracle press's pl/sql book fo r7.x/8/8i (of any version). try it out mortonsa all the best
  6. oracleraj

    Recommendation for good OCP study guide

    I am too using sybex publicaton book. I think its good book.
  7. oracleraj

    How can I find product of a column

    This is not possible as i know? but if u want to use sql only then you can create a function returning a number and u can call this function in ur query. Eg. Create or replace function prd_emp return number as v_prd_sal number := 1; Cursor c1 is select sal from emp; begin for...

Part and Inventory Search

Back
Top