Search results for query: *

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

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

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

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

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.