i've a hard time at googling! i want to know how to replace a line which has loads of non printable binary characters and want to extract only those printable characters. is there anyway to do this with replace function or do we have any other functions to do this?
I generally consider the printable characters as having ascii values from 32 to 126. You can also write your function using the replace function as follows:
create or replace function get_print_chars(str_in
Working with Network Access Control Lists in Oracle 11g (part 1)
Part 2: http://www.e-e.com/A_9074.html
So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.