• calling trigger in oracle db 10g

    hi all! I do have a table called customers. I want to delete and update rows in this table. But I want to keep rows' history before operations into another table. I know this will be performed with help of a trigger. How I could do this? I'm waiting for your help.                  ...

    Girma30 pointsBadges:
  • SQL Developer: missing expression on insert into with select rownum

    insert into TEMPLE_BDMS.TEMP_QSP values ( select rownum as uniqrownum, doc_id, doc_type, barcode2, barcode3, barcode4, routing_status, scan_date, assignee, scanner, scan_station, pfile_name, new_doc_id, new_doc_type, new_doc_type2 from TEMPLE_BDMS.QSP_SOURCE where pfile_name not like '%_0001.%' ) I...

    APB10 pointsBadges:
  • IN PL/SQL how to declare and use ‘STATIC DATA TYPE like C’

    Hi All, Can anybody help me to declare a variable having the similar propery of 'STATIC DATA TYPE IN C'. Means declare a variable and initialize it inside the procedure and called the procedure recursively but each time it is initializing the variable. I want any mechanism in PL/SQL that will make...

    Oracle10g4developers5 pointsBadges:
  • to calculate last business day for each month for corresponding to any given date for last five years

    Hi , i have created a function to calculate last business date for each month for 1 year . Now, I want to modify code to find out last business day for last 5 years. Please suggest me what changes i need to made in code . CREATE OR REPLACE FUNCTION LAST_MONTHLY_BUS_DATE_FOR_YEAR (P_DATE in date )...

    Ashu15 pointsBadges:
  • how to config report server to run report by oracle developer 9i ?

    oracle report

    Rkon725 pointsBadges:
  • Oracle SQL question

    I want to create a SQL script in Oracle that will run one of two possible SQL scripts based on what the user enters in the Parameter request. Since I'm unable to use IIF and If Then like I can in SQL Server, is there another way to do this? I have tried using case statements but Oracle doesn't like...

    Wanderer95775 pointsBadges:
  • Oracle Reports 9i

    I am new to Oracle reports, I am working on 9.0.4 version, I have configured OC4J, but when I run forms its shows Oracle application services installed successfully, and once I click ok it comes with a blank screen and status bar of the IE says its still loading. Please help me out.

    OracleRep5 pointsBadges:
  • SQL Query

    Hello everyone, I have the following table: CREATE TABLE MKW ( ID NUMBER, UREN NUMBER, DATUM DATE ); It has the following records: SQL> select * from mkw order by datum,id; ID UREN DATUM ---------- ---------- -------- 1 3 01-12-08 1 2 01-12-08 2 3 01-12-08 2 2 01-12-08 3 6 05-12-08 4 10 05-12-08...

    Mariane10 pointsBadges:
  • Insert superscript text into Oracle database

    how can i insert superscript or subscript text to the data base i have colomn called measuments Units and i want to insert quadratic meter M2 or Cubing meter M3 am using oracle 9i pleeez help

    Rosealzubi115 pointsBadges:
  • how can i update ?

    when update in form (master_details) in details block i found error frm-40735 when button pressed trigger raised unhandled exception ora-00001

    Camba5 pointsBadges:
  • Oracle Lock Query

    Is it possible to determine who is locking (not blocking) a row in an Oracle database? This relates to a problem I have with a COBOL program that needs to determine who is locking a requested record. I can determine the rowid of the requested record (after Oracle has informed the program that the...

    RichardReynolds5 pointsBadges:
  • Join clause vs. nonequi join

    pls help, can using clause is simmilar to non equi join,if yes how is it

    Muktioracle50 pointsBadges:
  • Nonequi join and self join as inner join

    pls Help, can we call non-equi join and self join as inner join ,if yes pls give some resion

    Muktioracle50 pointsBadges:
  • 3 tier character report printing not possible in 10g

    i made a character report in 10g , if i run in report builder then its printing is fine. but when i print report using 3 tier (using pdf format) then all setting are disturbed.

    Yogender dba5 pointsBadges:
  • Oracle 9i to 10g conversion

    have anybody done this type of conversion and what are the problem is can expect, we are using a lot of stored proc and triggers, is there any problem regarding the meta data?

    Sepere5 pointsBadges:
  • Pl/sql code for queries

    Hi , I have written 4 sql queries.2 select commands and 2 delete commands.now I want to write a pl/sql block for this.i.e after 2 select statements if the given condition satisfies then 1st delete command applicable. same way for 2nd delete command.I want to write cusor for those 2 select...

    User714085 pointsBadges:
  • Oracle / EADH

    Can someone please explain to me what EADH (Enterprise Agent Data Hub) works?

    Tim B5 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following