Geeks Talk

Prepare for your Next Interview




Set columns as not null

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


Go Back   Geeks Talk > Databases > SQL

Register FAQ Members List Calendar Mark Forums Read
  #1 (permalink)  
Old 12-03-2007
Junior Member
 
Join Date: Nov 2007
Location: chennai
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
jency is on a distinguished road
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
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 12-06-2007
Moderator
 
Join Date: Jun 2007
Location: Bangalore,India
Posts: 1,426
Thanks: 8
Thanked 125 Times in 112 Posts
debasisdas will become famous soon enoughdebasisdas will become famous soon enough
Re: Set columns as not null

Can you kindly post your code for reference of our experts please.
Reply With Quote
  #3 (permalink)  
Old 12-06-2007
Junior Member
 
Join Date: Sep 2007
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
ajith007 is on a distinguished road
Re: Set columns as not null

dear

ur question seems to be very obscure.Pls be more specific.
Reply With Quote
Reply

  Geeks Talk > Databases > SQL


Thread Tools
Display Modes


Similar Threads

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


All times are GMT -4. The time now is 01:39 PM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0
Copyright © 2008 GeekInterview.com. All Rights Reserved