<div>
You can use also Views to hold the content of the original tables:<br />
CREATE TABLE YOURTABLE AS SELECT '2030' AS COL1 FROM DUAL<br />
<br />
CREATE VIEW BDM_YOURTABLE AS<br />
SELECT 'BDM-'||YOURTABLE.COL1 AS COL1 <br />
FROM YOURTABLE<br />

</div>


<div>
<div class="content wysiwyg-content">
We're trying to add prefix (character) before the value in the column. We have about 28000 record which we need to add (BDM) before the values in the column which are numbers. For example if the column is 2030 the final result should be &quot;BDM-2030&quot;. The table is in oracle 10g and we're trying to use pl/sql for this process. Thanks for help. 
</div>
</div>


We're trying to add prefix (character) before the value in the column. We have about 28000 record which we need to add (BDM) before the values in the column which are numbers. For example if the column is 2030 the final result should be "BDM-2030". The table is in oracle 10g and we're trying to use pl/sql for this process. Thanks for help. 

Adding prefix to a column

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.