{"in":{"data":"insert into tabtmp\r\n(no_part,\r\ndeptname,\r\nfirtname,\r\nlastname\r\n)\r\nselect\r\nno_part,\r\ndeptname,\r\nfirtname,\r\nlastname\r\nfrom\r\nemp e,dept d\r\nwhere e.no_part=10\r\nand d.no_part=10\r\nand e.deptno=d.deptno;","type":"txt"},"out":{"data":"c_part:=10;\r\nexecute immediate\r\n\" insert into tabtmp\"||\r\n\" (no_part,\"||\r\n\" deptname,\"||\r\n\" firtname,\"||\r\n\" lastname\"||\r\n\" )\"||\r\n\" select\"||\r\n\" no_part,\"||\r\n\" deptname,\"||\r\n\" firtname,\"||\r\n\" lastname\"||\r\n\" from\"||\r\n\" emp e,dept d\"||\r\n\" where e.no_part=\"||c_part||\r\n\" and d.no_part=\"||c_part||\r\n\" and e.deptno=d.deptno\";","type":"txt"},"client":"0.5.0"}