Oracle Database
If you want to remove line breaks or other characters from Oracle fields, the following article might help.
One scenario is for example export of data into text files.
SQL
The above will replace all line breaks (chr(10)), all tabs (chr(09)) and all carriage returns (chr(13)) with a space (' ').
The Oracle function 'translate' is applied on the whole String and might show better performance than regular expressions depending on the complexity of your regex.
Enjoy.
- Hits: 23497
I had to rename a column in a table in an oracle database.
SQL
Unfortunately the oracle documentation was not working for me and I had to play around a bit and search the internet until I found the following syntax to be working.
alter table tableName rename column oldName to newName;
Some things to watch out for.
You have to use simple column names.
The oracle documentation listed as first result in a google search provided the following example, which did not work for me.
RENAME COLUMN EMPLOYEE.MANAGER TO SUPERVISOR
I am puzzled as to why the above syntax did not work for me while the alter table statement worked fine, since I was able to create the table in the first place
It looks as if I just misinterpreted the oracle documentation and the rename statement always has to be combined with an alter table statement.
References
Oracle documentation
https://docs.oracle.com/javadb/10.6.2.1/ref/rrefsqljrenamecolumnstatement.html
Another resource using a syntax, which worked for me.
http://www.dba-oracle.com/t_rename_column_table.htm
- Hits: 11310
Splitting Strings is a trivial task. Using SQL unfortunately it is not so easy to do. Recently I had to split long concatenated strings from one field in an Oracle database.
Luckily I was not the only one facing this challenge and found helpful information on the internet.
Below an example that did the trick for me.
The resultset of above query will look like the following picture.
- Hits: 16456
Subcategories
Oracle SQL Article Count: 8
This category will hold examples for Oracle SQL.
Oracle SQL Developer Article Count: 4
This category will hold Oracle SQL Developer specific articles.
Oracle PL SQL Article Count: 6
A category holding articles for Oracles programming language PL SQL.
Page 1 of 6