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 Rhinorhino 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. speial

    Oracle DB Object Search

    Yes. This is what I was looking for. Let me give it a try. Many thanks.
  2. speial

    Oracle DB Object Search

    I am reverse engineering an application process. The application is on Oracle 10G DB. I want to search all DB Objects for a particular text string. I am using SQL Navigator as the development tool. Example > I am looking for the string: "insert into his_call". There are over 2,000 db...
  3. speial

    Access / VB Error when changing SQL

    I took screen shots and they would not paste into the forum window. I wanted to show the steps and the code. Here is the code ++++ SELECT [Expr2] & "," & [Expr1] & ",ABC,state,Data_StateExtended,,,,,,,,&tsid:" & Int([Expr3]/500) AS Expr4 FROM [SELECT [OMS_ID] as Expr1, [ICCP Export point]...
  4. speial

    Access / VB Error when changing SQL

    I am unable to post / attach documents.
  5. speial

    Access / VB Error when changing SQL

    Hello, I am modifying an existing Access / VB application and need to make a simple change to an SQL Query. I open the query and select SQL. I see the SQL. I make the change and save. No issues so far.... When I run the applicaion I get an SQL error that does not reflect my change. So.. I...
  6. speial

    Inline Functions

    Thanks for your response. The SQL (function) was originally part of the entire SQL. The results with the "group by" did not sum the data as expected. Thinking that using a function (which I can verify independently) would help me check the results. With the information provided, I will give...
  7. speial

    Inline Functions

    Hello, I tried using the Declare but I received lots of errors. Perhaps I was not using the correct syntax for 'functions' in an anonymous block? I have attached the Calling SQL and the Funciton I want to embed. Thanks for taking the time to assist. Please let me know what you find...
  8. speial

    Inline Functions

    Anyone have an idea how to embed a function with an SQL statement ? I would like to embed ( define, declare and execute) functions within an SQL query. I don not want to 'store'(create a function object within the DB schema).
  9. speial

    transpose rows to columns Oracle SQL

    Thanks for the info. I will give it a try.
  10. speial

    transpose rows to columns Oracle SQL

    I am creating a view that requires rows from a table. The rows in the table need to correspond to columns in the view. Table Items: Select isr_no, badge_nbr, model, serial_nbr, manu_cd from items where isr_no = 'mtr-10'; Result: (3 rows found in table, items) isr_no badge_nbr model...
  11. speial

    Exact fetch ERROR on an INSERT statement ???

    Hello, This is not the entire procedure. There are no triggers on the table. my p_stuff_record shows the resolved variables just before the Oracle Error Message is posted. Hence why I am puzzled as well. I am inserting dbms_out statements to see if there are any cursors being execuited at...
  12. speial

    Exact fetch ERROR on an INSERT statement ???

    Hello, In an SQL procedure I am getting an SQL error >>> ORA-01422: 'exact fetch returns more than requested number of rows' on an table insert statement. I am puzzled to say the least. Anyone seen this before ? ============== BEGIN INSERT INTO sysadm.ps_cu_sp_eq_stg (...
  13. speial

    Initializing Table Space - Force default column widths

    I have a table that contains several columns defined between VARCHAR2(100) to VARCHAR@(254). As the table gets updates, ORACLE begins to chain the rows. My understanding is the chaining occurrs becasue when the table was created, ORACLE initialized the VARCHAR2 columns with 'one' character...
  14. speial

    How can I increment the minute component of a date column (Oracle 8.i)

    Stefanhei, Works great. Why ?
  15. speial

    How can I increment the minute component of a date column (Oracle 8.i)

    I have ben asked to increment the minute component of a date column by one. Does anyone have a suggestion on how to accomplish this ? We are using Oracle 8i.

Part and Inventory Search

Back
Top