Skip to Content
avatar image
Former Member

Regarding Sql Query

Hi all,

I would like to know the SQL QUERY, by which i would be able to insert values to the fields at "RUNTIME" into a oracle database table.

Example : - If a field has got different values, the value selected by the user at runtime, should be entered into the database by an sql query.

Could you please let me know the syntax of that sql query?

Regards,

Divya.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    Oct 09, 2007 at 05:58 PM

    I<m not sure this is what you want, but investigate usage of TRIGGERS. Google this out to find your answer.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 09, 2007 at 10:33 PM

    Divya,

    I am not sure if SAP supports making changes at DB level for a standard SAP object. You also have the option of getting developer to make the changes at application level.

    In case, its a custom object, then Oracle provides database triggers, they can be executed on event, on a DML operation and allows database developer add PL/SQL code to it when a object is changed. You can get more information on it on Oracle documentation.

    cheers,

    Nisch

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 20, 2011 at 08:54 AM

    answered

    Add comment
    10|10000 characters needed characters exceeded