Record insert and the select in Oracle
Here i have a select query and on the basis of where condition record are fecthing from the database & show in the DropDown list.Now I want add new specific Item in the DropDown List in the end (Allocated on Basis of round), how i can do it in the database.
Means After Select Query Recodrs Fetch From database, insert into this record at the end. how i can write query firstly record insert then select all record.
SELECT LUD_USER_ID "CODE",
LUD_USER_NAME "DESCRIPTION"
FROM LMS_USER_DETAILS
WHERE LUD_LEVEL = 'T4' AND LUD_STATUS = 'A' AND LUD_COMPANY = 'ISL' AND LUD_REPORTING_HEAD = PI_DEPENDENTARGUMENT2
ORDER BY LUD_USER_ID;