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 strongm 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. JigarMD

    not equals

    is ur field of varchar/char datatype , if yes try adding sqingle quotes in where clause
  2. JigarMD

    Oracle & MP3s

    i think the audio/video cartridge is a paid product and doesnt install by default
  3. JigarMD

    data selection based on primary key/foreign key constraints

    do u want to extract to flat files. U can use sqlplus and spool the output to file. If u wnat to export the data using exp then u can specify the where clause in exp command. hope this helps
  4. JigarMD

    archive log recovery error

    try giving recover database command at svrmgr prompt and when promted for file names mention 'AUTO'. See if it works.
  5. JigarMD

    advanced queueing support

    Try to recompile the package as user sys or recreate after login as sys.
  6. JigarMD

    Create Table error driving me mad!

    try changing colum name title to something like titles. it works on my machine
  7. JigarMD

    Querying Oracle from Sybase?

    What exactly is ur purpose of trying to access oracle from sybase. if u just need to transfer data to and from oracle/sybase u can create a vb app. which has 2 ADO Controls 1 connecting to oracle and another to sybase and then copy data as u like. if u need more info maile me at...
  8. JigarMD

    Method for Using a Reserved Word

    Try creating the view in this fashion create view viewname as select "value" value or create view viewname as select "value" hope it works

Part and Inventory Search

Back
Top