Pass text in pl / sql to uppercase

Question

Pass text in pl / sql to uppercase

Navigation

#1 by (3 votes)

3

I have many create table, sequence, and etc scripts, however everything is in lowercase, which the colleague did. Deleting line by line and capitalizing is unproductive as there are over 1000 scripts to change. In SQL Server I select and give Ctrl + Shift + U and move the selected text to uppercase. How do I do this in PL / SQL? I have searched in NET and only comes passing the Data (string) to uppercase, type ( Upper(meu_campo) ) and this is not what I want but change the script. How do I do it?

oracle pl-sql

asked by anonymous 23.02.2016 / 13:28

1 answer

Dealing with collisions in dictionary C # What does the equals (Object o) mean in this method?

score 3 · Accepted Answer

It has as its own,

Via PL / SQL by going to the Tools > Preferences option, the PL / SQL Beautifier option exists in the User Interface group.

ConfiguringRulesFile,clickEdit..:

Soautomaticallythismodificationyouwantisdonethroughtheoptioninthetaskbar:

Youcanalsoinsertashortcut,Tools>Preferences>intheUserInterfacegroupthereistheKeyConfigurationoption,andassignashortcuttothecommand.

Anotheroption,youcanloadaRolesFile,asanexample:Copythecodebelowandsaveitwiththeextension.br

Version=1RightMargin=90Indent=3UseTabCharacter=FALSETabCharacterSize=3AlignDeclarationGroups=TRUEAlignAssignmentGroups=TRUEKeywordCase=1IdentifierCase=0UseSpecialCase=TRUEItemList.Format=2ItemList.Align=TRUEItemList.CommaAfter=TRUEItemList.AtLeftMargin=FALSEEmptyLines=2ThenOnNewLine=FALSELoopOnNewLine=FALSEDML.LeftAlignKeywords=FALSEDML.LeftAlignItems=FALSEDML.OnOneLineIfPossible=TRUEDML.WhereSplitAndOr=TRUEDML.WhereAndOrAfterExpression=FALSEDML.WhereAndOrUnderWhere=TRUEDML.InsertItemList.Format=2DML.InsertItemList.Align=FALSEDML.InsertItemList.CommaAfter=TRUEDML.InsertItemList.AtLeftMargin=FALSEDML.SelectItemList.Format=2DML.SelectItemList.Align=TRUEDML.SelectItemList.CommaAfter=TRUEDML.SelectItemList.AtLeftMargin=FALSEDML.UpdateItemList.Format=2DML.UpdateItemList.Align=TRUEDML.UpdateItemList.CommaAfter=TRUEDML.UpdateItemList.AtLeftMargin=FALSEParameterDeclarationList.Format=2ParameterDeclarationList.Align=TRUEParameterDeclarationList.CommaAfter=TRUEParameterDeclarationList.AtLeftMargin=FALSERecordFieldList.Format=1RecordFieldList.Align=TRUERecordFieldList.CommaAfter=TRUERecordFieldList.AtLeftMargin=FALSESplitAndOr=FALSEAndOrAfterExpression=FALSE

SourceofRolesExampleFile: link

Configuration Source: link