Profile Picture
IT Made Easy
The site provides some rough IT Notes that make your life easier. The site currently has notes on HTML, CSS, Regex, OOPS, JS, JQuery, PHP, Java, ASP.NET, C#, Database, Linux, URL Rewrite, SEO, Project Management and Hosting. Please do share this site if you like.

Miscellaneous

REGULAR EXPRESSIONS

  • REGEX_SUBSTR(string,pattern,position,whichoccurence,instructionofmatch) chracter string matched
  • REGEX_INSTR(string,pattern,position,whichoccurence,optional,instructionofmatch) optional = 1 postion after match otherwise position of match
  • REGEX_REPLACE(string,pattern,replace,position,optional,instructionofmatch) pattern replaced
  • CHECK (REGEXP_LIKE (columnname, regexpression))
  • everything starts at 1
  • instructionofmatch c=case sensitive i=caseinsensitive n=. to match newline m=multiline x=ignore white spaces last info has precedence
  • [anyonecharacter] [^notanycharacter]
  • [:graph:] = [A-Za-z0-9punctuation]
  • + one or more *zero or more ? zero or one {n1} {n1,} {n1,n2}
  • (ab|bc|cd) where | operates like OR
  • backslash infront to tell you intend a character
  • ^starts $ends
  • \1 the first captured expression

SESSION CONTROL STATEMENTS

  • ALTER SESSION
  • SET ROLE

SYSTEM CONTROL STATEMENTS

  • ALTER SYSTEM

EMBEDDED SQL STATEMENTS

  • Any DDL, DML, TCL that is integrated into a 3GL

MISCELLANEOUS

  • SYSTEM PRIVILEGES license to drive car and OBJECT PRIVILEGES license to drive particular car
  • CREATE USER username IDENTIFIED BY pwd
  • ALTER USER username IDENTIFIED BY pwd
  • DROP USER username
  • DROP USER username CASCADE
  • CONNECT username/pwd

IT Notes

by VinodSebastian



IT Downloads


Catalogue