how to show description in data base column like Description

Anjali Khan

9y1.1k

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

13 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rafnas T P9y ago
Accepted 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_BY,CRT_DT)
VALUES(P_INCIDENT_ID ,'INSERTED NAME SUCCESSFULLY' || P_NAME, SYSDATE);
0
Anjali Khan9y ago
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_ID,NAME_DESC,CRT_DT)
VALUES(P_USER_ID,P_NAME_DESC, SYSDATE)
RETURNING USER_ID INTO P_USER_ID ;

INSERT INTO RECORD_EVENT_LOG(USER_ID, EVENT_DESC, CRT_BY,CRT_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

0
Nitin Sontakke9y ago
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.
0
Anjali Khan9y ago
I USED LIKE
INSERT INTO RECORD_EVENT_LOG(USER_ID, EVENT_DESC,CRT_DT)
VALUES(P_USER_ID , 'INSERTED RECORD SUCCESSFULLY ' + P_NAME, SYSDATE);

BUT NOT INSERTED RECORDS IN TABLE

HERE I USED OPRACLE DB
0
Ramesh Palanivel9y ago
Hi ANjali,

Can you post your error?
0
Anjali Khan9y ago
hi

i tried this like
INSERT INTO RECORD_EVENT_LOG(USER_ID, LOG_DESC,CREATED_BY)
VALUES(P_USER_ID ,'INSERTED RECORD BY- '+ P_MOVE_TO, P_LOGINUSER,);
but getting error
0
Ramesh Barik9y ago
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_DESC,CREATED_BY)
VALUES(@P_USER_ID, @LogDesc, @P_LOGINUSER );

Check this query it may help you.
0
Bikesh Srivastava9y ago
create trigger and update row with adding discription in coulmn .
0
Ramesh Palanivel9y ago
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!...
0
Rafnas T P9y ago
try this below code
INSERT INTO RECORD_EVENT_LOG(USER_ID, LOG_DESC,CREATED_BY)
VALUES(P_USER_ID ,'INSERTED RECORD BY- '+ P_MOVE_TO, P_LOGINUSER,);
0
Anjali Khan9y ago
Hi ramesh

THIS IS MY QUERY
INSERT INTO RECORD_EVENT_LOG(USER_ID, LOG_DESC,CREATED_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
0
Ramesh Palanivel9y ago
Hi Anjali,

Your question make sense!..

Just insert the text value in Description. "Records Updated Succssfully by Ritesh"
0
Manish Kumar9y ago
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] (ID,NAME)
SELECT 1,'DELHI'
UNION ALL
SELECT 2,'NOIDA'
UNION ALL
SELECT 3,'GURGAON'
UNION ALL
SELECT 4,'PUNE'
GO
SELECT * FROM [tblComments]
GO

0