To apply data formats in SQL queries, you can use the CAST or CONVERT functions ... the data type definition when creating or altering a table or a column. For example, you can use the DECIMAL ...

This stored procedure converts ... table, so i modified it to accept any table and apply different or no styles, also you can output or not the column names to the table. This SP works with dynamic ...

The application will convert the XML data stored in the sender database to relational format (this is called publishing ... The sender database is recommended to use a PL/SQL procedure to retrieve XML ...