Mostly Making oracle easy, mostly:
Search for:

Reading List

I spend a lot of time on-line. Most of my news and editorial content is found via Twitter posts, but there are a few outlets that I check out on a regular basis. If you enjoyed my writing at all, I think you’ll love reading what these folks have to say!

Oracle and SQL Developer Stuff

  • Kris Rice – my boss and creator of SQL Developer. Insight to how stuff ‘really works’
  • Barry McGillin – SQL Developer, developer!
  • Dermot O’Neill – another developer who blogs SQL Developer
  • berxblog – A DBA who is willing to share his time and expertise
  • ORACLENERD – OBIEE and other things that make my head hurt
  • Laurent Schneider – prolific and EXCELLENT content
  • DBAKevlar – DBA rants and lots of great tuning advice
  • ODTUG Blog – The Oracle user group dedicated to developers and the tools they use, does it get any better than this?
  • KelloggsDBA – I learn just as much about parenting and being a good person as I do Oracle stuff

Data and Databases

  • Brent Ozar – Yes, he does SQL Server, but his insight in consulting, server technology, and humor is top notch. I learn A LOT from this guy.
  • InfoAdvisors – Karen Lopez knows her data, she loves it, and it really shows
  • Erin Stellato – She lives in an evil parallel universe, but she’s a great writer and I enjoy seeing how the other half lives

Folks that Blog About Blogging

13 Comments

  1. Manny Reply

    Hi Jeff,

    Sorry to bother you with another silly question.

    I am creating a CV.040 Conversion Data Mapping for a Oracle Quality collection plan.
    This solution needs to bring daily Quality results from a testing machine on the factory floor in the form of a textile to a Windows folder
    My original idea was to use a batch file in Windows and launch the SQL*loader and populate Q_IMPORT_IV On the eBS side
    I would then schedule the Collection Import Manager upload data into Oracle Quality Results table.

    But now I see that in the “Oracle Manufacturing APis and Open Interfaces Manual” page 11-14 that Oracle is using PL/SQL code to move data
    and not SQL*Loader.

    Can I do daily SQL*Load into a Oracle eBS interface table??
    Will SQL*Loader erase existing data?

    I guess the questions is SQL* Loader the right tool to move daily text data into a Oracle table and not lose previously loader data.

    Thanks,
    -Manny

  2. Manny Reply

    Jeff:

    I could not find Oracle client but if found this zip file:
    instantclient-basic-windows.x64-11.2.0.3.0.zip
    does this file have SQL*Loader??

    Thanks,
    -Manny

    • Manny

      Jeff,
      Thank for your help.
      Here is the 2 zip files I downloaded:
      win64_11gR2_database_1of2.zip
      win64_11gR2_database_2of2.zip

      My network at is wireless and I also have TOAD installed on me notebook.
      =======================
      ORA-00119: invalid specification for system parameter
      LOCAL-LISTENER
      ORA-00132:syntax error or unresolved network name
      LISTENER-ORCL
      =========================================
      Any ideas??
      Thank you in advance.
      Best Reagards,
      -Manny

  3. Manny Reply

    Hi Jeff,

    Where do I download SQL*Loader from to run on my Windows/7?
    Thanks,
    -Manny

    • thatjeffsmith Post Author

      Go to Oracle.com and download the Oracle Client for Windows. That contains the sql loader program.

  4. Manny Reply

    Hi Jeff,

    I have a text file of Quality Results that I need to populate a Oracle Quality Interface table with.

    When ever a new plan is created, Oracle Applications creates two views automatically with names
    Q__V and Q__IV. View Q__V is based on QA_RESULTS table while Q__IV is based on QA_RESULTS_INTERFACE table which is used for importing huge data in Quality

    Below is a sample of a Pl/SQL for placing one record on this table. But daily
    I need to place between 100 to 200 records from a Text File for a machine that is collecting these test results.

    SQL> INSERT INTO Q_IMPORT_IV(
    PROCESS_STATUS,
    ORGANIZATION_CODE,
    PLAN_NAME,
    ITEM,
    REVISON,
    LOT NUMBER,
    JOB_NAME,
    FROM_OP_SQ_NUM,
    TO_OP_SEQ_NUM,
    DEPARTMENT,
    OPERATOR,
    DEFECTS,
    THICKNESS,
    OFF_LOCATION
    )
    VALUE(
    1,
    ‘MAS’,
    ‘IMPORT’,
    ‘ITEM8’,
    ‘0,
    ‘A’,
    ‘DJ1’,
    10,
    20,
    ‘D1’,
    ‘jus’,
    ‘br’,
    40,
    0
    );

    I hope I copied the above scripted correctly from Oracle eBS Oracle Qualty interface.
    The resources that I have on my machine are:

    I have eBS R12.1 running on my notebook as a Linux guest on VMware on
    Windows/7.

    I have Oracle SQL Developer and MS Office on my notebook.
    So I could experiment with your feedback.

    Greatly appreciate your help.

    Best Regards,
    -Manny

    • thatjeffsmith Post Author

      What is an Oracle Quality Interface table?

      Text file on machine > daily loads to Oracle?

      I would setup a local job to kick of a sql*loader session to load that data for you. You can use SQL Developer to help you define your SQL*Loader job/files. Do a search on my blog for excel and sql loader for more information.

  5. Neha Reply

    At my work we are replacing our old PL/SQL Developer tool with SQL Developer and I took lead to help my colleges during this transition. I am glad that I found this blog, i am sure this will help lot to me and my team.

    Thanks

  6. Sabahat Reply

    randomly I landed on this site. Wow. For past two hours I am reading tips and applying to my Oracle SQL Developer environment. Thank you for posting all these wonderful tips. Now I dont’ see any reason to stick with my old PL/SQL Developer tool.

    Thanks a lot.

    • thatjeffsmith Post Author

      Thanks Sabahat! If you find anything lacking or ‘missing’ based on your previous tool, be sure to let us know!

  7. Sandy Reply

    when i execute the script as below:
    SELECT SYS_CONTEXT(‘USERENV’,’TERMINAL’) FROM dual;
    it always return ‘unkown’
    Does any setting should to adjust?

    but when i used other tools(ex. PL/SQL developer)，then same script can return correct data for me.
    thanks.

Write A Comment