text

Oracle: source text for the view, package etc

Friday, January 25th, 2008

Source text of the package

SELECT text
FROM dba_source
WHERE upper(name) LIKE upper(’&which_object’)
ORDER BY line ;

Use $ORACLE_HOME/bin/wrap utility to encrypt the package (there is no unwrap)
(Well, actually, there is unwrap - just look in the search machine for the words unwrap10 or rewrap…)
Source text of the views

SET long 5000
col text FOR a80
SELECT text FROM dba_views WHERE view_name = [...]

MS Word: replace spaces to non-breaking

Thursday, January 10th, 2008

To insert it manually, use Ctrl+Shift+Space

Selection.HomeKey Unit:=wdStory
Selection.Find.ClearFormatting
Selection.Find.Style = ActiveDocument.Styles(”Normal”)
Selection.Find.Replacement.ClearFormatting
With Selection.Find
   .Text = “   ”
   .Replacement.Text = “^s”
   .Forward = True
   .Wrap = wdFindContinue
   .Format = True
End With
Selection.Find.Execute Replace:=wdReplaceAll

Keep on coding