Search results for query: *

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

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

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]...

I am unable to post / attach documents.

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

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

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

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).

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

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

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

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 (...

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

Stefanhei, Works great. Why ?

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.