Reverse Engineering Tools For Pl Sql Substr

1. Sql Substr Date

Sql Substr Date

Mar 05, 2014  You can reverse a string in SQL by using Reverse function of SQL. It is very simple to use, following is the command to reverse. Hi, I am using sqldeveloper and eclipse and they do help with the collapsable logical blocks. For code that is comprised of thousands of lines it is not really easy to follow even with the logical blocks. I have seen several tools for converting pl/sql to dataflow diagrams but they are all.

Of course more recently Anton made available some details on how to unwrap 10g PL/SQL on his blog. In that he refrained from publishing the lookup table used in the wrap process but this was actually about trade secrets and reverse engineering and not about using an. SQL> select substr(text,1,60).

I just started learning PL/SQL and I'm not sure how to create a procedure. The logic seems about right but I think there's some syntactical mistake in the first line. Here's my code:-

Justin CaveShailShail

6 Answers

Two things - you shouldn't specify the datatype size in procedure's/function's parameter list and you do not need the DECLARE keyword. Try this:

TordekPrzemyslaw KruglejPrzemyslaw Kruglej

Try it without PL/SQL!

Citation: http://rdbms-insight.com/wp/?p=94

Another solution reverse string minimizing loop count

Not the answer you're looking for? Browse other questions tagged sqloracleplsqlsyntax-error or ask your own question.

Does anyone know of an open source/free tool for converting pl/sql code to a flowchart or data flow or activity diagram?

Thanks

ziggyziggy

3 Answers

No I don't. Data flow and activity diagrams are at a much higher level of abstraction than PL/SQL code, so it wouldn't make sense to try to generate those from PL/SQL. Flowcharts are for code, but I thought they went out of vogue about 25 years ago? They are so pointless.

What you can get are IDEs like SQL Developer (free), Toad etc. that can show the structure of your code, allow you to collapse logical blocks of code, colour code the different elements of the code, indent code etc.

Tony AndrewsTony Andrews

• Visustin v6 Flow chart generator
• Code Visual to Flowchart 3.5

They are not really freeware but you can do pretty much everything using their free version.

It might be of help to build a kind of three with a query through dba_dependencies:

J. ChomelJ. Chomel

Not the answer you're looking for? Browse other questions tagged plsql or ask your own question.