Subscribe to this list via RSS Blog posts tagged in Code
Almost TSP!! : Travelling Salesman Problem Solution through PL/SQL Hi!!!!   /* PROBLEM STATEMENT Here, the salesman is given the distance chart by his/her manager based on which (s)he has to cover all the cities in the distance chart but ensure that (s)he covers the MINIMUM DISTANCE. For better text, read http://en.wikipedia.org/wiki/Travelling_salesman_problem. */         / drop table salesmans_scrambled_dist_chart; create table salesmans_scrambled_dist_chart (       source      varchar2(5),       destination varchar2(5),       distan...
Oracle Package / Stored Procedure to generate distinct scrambled combination of given elements Due to my 'lazy' mind fidgeting around, I came up with the following :-) the following article gives the complete code (yes, it's redistributable!) to generate the distinct alphabets that are possible, if the list of alphabets to be used are known [in the table - elements_for_scramble] (through Oracle PL/SQL - pkg_scrambler ) as a part of solving the business problem, you will also learn the basics of SQL and  PL/SQL in oracle). So, without further ado, here it goes:     --=: LOA...
  • Page :
  • 1

Check out more tips and tricks in this development video: