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: *

  • Users: HereistheAnswer
  • Order by date
  1. HereistheAnswer

    row-driven tables

    the relational database beauty will not be there. obtaining parent-child relationship is tough. It's totally not recommended to use such design. however, if you need to add columns in future, any time, then only u can use such design. for example, you want to keep one xml data in a table, each...
  2. HereistheAnswer

    ORA-01830: date format picture problem with a Procedure

    pleae send the table structure of table 'RENTAL'
  3. HereistheAnswer

    Help required with insert statement

    Moreover u can use trim only in place of ltrim rtrim
  4. HereistheAnswer

    Where to find the last login time for an oracle user ver. 8.1.7

    jee could you please give an example of a logon trigger. i want to know the syntax actually. the system user should create the trigger right?
  5. HereistheAnswer

    Deleting records with either null or zero.

    yeah that's right Santa....I thought after writing that, if all the column value contains null, then my code will fail. Thank u Santa.
  6. HereistheAnswer

    Deleting records with either null or zero.

    SantaMufasa, I think it is more appropriate: delete FROM table WHERE to_number(Jan||Feb||Mar||Apr||May||Jun||Jul||Aug||Sep||Oct|| Nov||Dec,0) = 0; What do you say?
  7. HereistheAnswer

    DLL's registration+MQSeries samples

    As all the dlls you have mentioned are part of mqseries, it should come with your installation. Ideally you need not do anything manually. It is not a problem of your COMPUTER, rather it may possible that the dlls are searching for other components, which are not available. That's why you are...

Part and Inventory Search

Back
Top