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...
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...