Wrap Oracle script

Mar 25

posted by Pyae Phyoe Shein in Oracle | 0 Comments Bookmark and Share

Today, I know how to wrap Oracle objects called stored procedure, functions, views and so on. It's because I want to make secure for our project source.

How-to-do is very simple.

1) Open common prompt 2) and go to Bin folder under Oracle just like "C:\Oracle\Bin" 3) Then type following script

view plain print about
1C:\Oracle\Bin\wrap iname=/SP/mysp.sql oname=/SP/wrap_mysp.sql

[More]

This entry was posted on March 25, 2012 at 6:44 PM and has received 1131 views. There are currently 0 comments. Print this entry.

Replace function in SQL

Mar 5

posted by Pyae Phyoe Shein in MsSql | 0 Comments Bookmark and Share

Today I've found how Replace function is useful in SQL. Because I need to update all columns of every table in our database. Using Replace is very simple.

view plain print about
1UPDATE <TABLE> SET
2columnText = REPLACE (columnText, 'StringToFind', 'StringToReplace')

Above query is correct for nvarchar field but when I'm trying to replace for ntext and text field, it's getting error that "replace isn't ok for text field". That's why I'm goggling and found nice example as follow.

view plain print about
1UPDATE <Table> SET columnText =
2REPLACE(SUBSTRING(columnText, 1, DATALENGTH(columnText)), 'StringToFind','StringToReplace')

This entry was posted on March 5, 2012 at 9:43 PM and has received 1328 views. There are currently 0 comments. Print this entry.

Top of Page