Prepare for your Next Interview
This is a discussion on Set columns as not null within the SQL forums, part of the Databases category; To add a who column to the existing tab;e I have created a form on the table which has the two who columns last_updat_date and creation_date. I want to ...
|
|||
|
Set columns as not null
To add a who column to the existing tab;e
I have created a form on the table which has the two who columns last_updat_date and creation_date. I want to add created_by and last_updated_by and fill the values when i insert the data in the form. I used fnd_standard.set_who to set the who columns but the values are entered only in the last_updat_date and creation_date which was available already and the data is not getting entered into the columns created_by and last_updated_by (which i have created) I was unable to set the columns as not null. Please advice me in filling the who columns when i insert data into the table from the form. Thanks , Jency |
| Sponsored Links |
![]() |
|
| Thread Tools | |
| Display Modes | |
|
|
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How to add values to other columns | Mohamed_Rafi | Oracle | 10 | 03-27-2008 12:35 AM |
| In my source table I have two columns | Geek_Guest | Data Warehousing | 3 | 03-26-2008 04:20 AM |
| Pivot columns | Sant_parkash | Oracle | 3 | 10-24-2007 10:35 AM |
| How do I transpose Rows into Columns? | Anasuya1031 | SQL | 2 | 07-09-2007 05:37 AM |
| Built-in and plugin stages, Chaning Null to Not Null and Types of lookup | Geek_Guest | Data Warehousing | 0 | 04-06-2007 04:48 AM |