how to show description in data base column like Description

Question

hi frnds how to show description in data base column like Description Column Record updated successfully by Ritesh here i display on column like Ritesh but i want full sentence like Record updated successfully by Ritesh

Rafnas T P · Answer

hi Anjali Khan if you are using Oracle databas then you have to use || instead of + try this NSERT INTO RECORD_EVENT_LOG(USER_ID EVENT_DESC CRT_BYCRT_DT) VALUES(P_INCIDENT_ID 'INSERTED NAME SUCCESSFULLY' || P_NAME SYSDATE);

Anjali Khan · Answer

hi frnds my procedure like create or replace PROCEDURE PROC_INSERT_RECORDS ( P_USER_ID NUMBER P_NAME_DESC VARCHAR2 P_CRT_DT DATE ) AS BEGIN -- Insert-- INSERT INTO INSERT_DATA(USER_IDNAME_DESCCRT_DT) VALUES(P_USER_IDP_NAME_DESC SYSDATE) RETURNING USER_ID INTO P_USER_ID ; INSERT INTO RECORD_EVENT_LOG(USER_ID EVENT_DESC CRT_BYCRT_DT) VALUES(P_INCIDENT_ID 'INSERTED NAME SUCCESSFULLY'+ P_NAME SYSDATE); END PROC_INSERT_RECORDS; in RECORD_EVENT_LOG i want to use becz for the report table i need it

Nitin Sontakke · Answer

If possible please try to understand what I have to add here... Please DO NOT confused between database storage and reporting or business requirements. These two are DISTINCTLY SEPARATE things. Your data should always be stored in a properly normalized way which means you should NEVER store strings like Record inserted by in database. Such strings are part of your view or select query and that's where they should be. For example: select Record  + case operation when 1 then inserted when 2 then updated when 3 then deleted end +  by  + userId from ... Hope you get the point.

Anjali Khan · Answer

I USED LIKE INSERT INTO RECORD_EVENT_LOG(USER_ID EVENT_DESCCRT_DT) VALUES(P_USER_ID  'INSERTED RECORD SUCCESSFULLY ' + P_NAME SYSDATE); BUT NOT INSERTED RECORDS IN TABLE HERE I USED OPRACLE DB

Ramesh Palanivel · Answer

Hi ANjali Can you post your error?

Anjali Khan · Answer

hi i tried this like INSERT INTO RECORD_EVENT_LOG(USER_ID LOG_DESCCREATED_BY) VALUES(P_USER_ID  'INSERTED RECORD BY- ' + P_MOVE_TO P_LOGINUSER); but getting error

Ramesh Barik · Answer

As per your query you want to nsert the record in LOG_DESC as 'INSERTED RECORD BY- RITESH' For this you need to concartinate the your static string  INSERTED RECORD  with user name which can be retrived from the passed @userid. Declare @P_USER_ID int @P_LOGINUSER int @LogDesc varchar(200) set @LogDesc=' INSERTED RECORD BY- '+ (select username from yourUsersTable where P_USER_ID=@P_USER_ID) INSERT INTO RECORD_EVENT_LOG(USER_ID LOG_DESCCREATED_BY) VALUES(@P_USER_ID @LogDesc @P_LOGINUSER ); Check this query it may help you.

Bikesh Srivastava · Answer

create trigger and update row with adding discription in coulmn .

Ramesh Palanivel · Answer

Hi Anjali Try Rafnas Query For this one you have to concatenate the string with your value to store. Just try his query what he shared!.. Feel free to post still you have any issue in that!...

Rafnas T P · Answer

try this below code INSERT INTO RECORD_EVENT_LOG(USER_ID LOG_DESCCREATED_BY) VALUES (P_USER_ID  'INSERTED RECORD BY- ' + P_MOVE_TO P_LOGINUSER);

Anjali Khan · Answer

Hi ramesh THIS IS MY QUERY INSERT INTO RECORD_EVENT_LOG(USER_ID LOG_DESCCREATED_BY) VALUES(P_USER_ID  P_MOVE_TO P_LOGINUSER); HERE I WANT IN lOG_DESC COLUMN IF I CHANGED THE DATA LIKE MOVE TO OTHER LOCATION LIKE HYDERABAD IT IS HAPPENING BUT I WANT CHANGED CITY SUCCESSFULLY HYDERABAD HOW TO DO THIS how it will come because my column value is ritesh ----------------------------------- USER_ID LOG_DESC CREATED_BY ----------------------------------- 1 RITESH ADMIN 2 ANKUR ADMIN BUT I WANT LIKE ------------------------------------------------------------- USER_ID LOG_DESC CREATED_BY ------------------------------------------------------------- 1 INSERTED RECORD BY- RITESH ADMIN 2 INSERTED RECORD BY-ANKUR ADMIN

Ramesh Palanivel · Answer

Hi Anjali Your question make sense!.. Just insert the text value in Description. Records Updated Succssfully by Ritesh

Manish Kumar · Answer

For this while creating a table you need to set default value (SUSER_NAME) in your description column and if any body will do modification (insert/update) in table that user can be traced. Below is sample code. -------------------------------------- IF NOT EXISTS (SELECT 1 FROM SYS.TABLES WHERE NAME='tblComments') BEGIN CREATE TABLE [dbo].[tblComments]( [id] [int] NOT NULL [name] [varchar](50) NULL [comments] [varchar](50) NULL CONSTRAINT [DF_tblComments_comments] DEFAULT ('Records Modified by '+SUSER_NAME()) ) ON [PRIMARY] END GO INSERT INTO [tblComments] (IDNAME) SELECT 1'DELHI' UNION ALL SELECT 2'NOIDA' UNION ALL SELECT 3'GURGAON' UNION ALL SELECT 4'PUNE' GO SELECT * FROM [tblComments] GO