Regarding Sql Query

[Former Member]

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.

[former_member204746 · Accepted solution]

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

[Former Member]

answered

[Former Member]

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