Skip to main content

Posts

Showing posts from 2020

SQL

  A ll tables in Oracle database that were created within the last 60 days Ref:  https://dataedo.com/kb/query/oracle/find-recently-created-tables select owner as schema_name, object_name as table_name, created from sys.dba_objects where object_type = 'TABLE' -- excluding some Oracle maintained schemas and owner not in ( 'ANONYMOUS' , 'CTXSYS' , 'DBSNMP' , 'EXFSYS' , 'LBACSYS' , 'MDSYS' , 'MGMT_VIEW' , 'OLAPSYS' , 'OWBSYS' , 'ORDPLUGINS' , 'ORDSYS' , 'OUTLN' , 'SI_INFORMTN_SCHEMA' , 'SYS' , 'SYSMAN' , 'SYSTEM' , 'TSMSYS' , 'WK_TEST' , 'WKSYS' , 'WKPROXY' , 'WMSYS' , 'XDB' , 'APEX_040000' , 'APEX_PUBLIC_USER' , 'DIP' , 'FLOWS_30000' , 'FLOWS_FILES' , 'MDDATA' , 'ORACLE_OCM' , 'XS$NULL' , 'SPATIAL_CSW_A...

servelet&jsp

Servelet & JSP Can use web.xml or Annotations to link form action to Servelet < form method = " post " action = " Validate " > Name: < input type = " text " name = " user " /> < br /> Password: < input type = " password " name = " pass " > < br /> < input type = " submit " value = " submit " > </ form > Welcome.java import java . io . * ; import javax . servlet . * ; import javax . servlet . http . * ; public class Welcome extends HttpServlet { protected void doPost ( HttpServletRequest request , HttpServletResponse response ) throws ServletException , IOException { response . setContentType ( "text/html;charset=UTF-8" ) ; PrintWriter out = response . getWriter ( ) ; out . println ( "<h2>Welcome user</h2>" ) ; ...