Skip to content

Miscellaneous

IT Notes → Database → Oracle @ December 22, 2020

REGULAR EXPRESSIONS:

  • REGEX_SUBSTR(string,pattern,position,whichoccurence,instructionofmatch) character string matched.
  • REGEX_INSTR(string,pattern,position,whichoccurence,optional,instructionofmatch) optional = 1 position 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 password.
  • ALTER USER username IDENTIFIED BY password.
  • DROP USER username.
  • DROP USER username CASCADE.
  • CONNECT username/password.

Related Posts

  1. Introduction ( IT Notes → Database → Oracle )
  2. Data Definition Language ( IT Notes → Database → Oracle )
  3. Data Manipulation Language ( IT Notes → Database → Oracle )
  4. Data Control Language ( IT Notes → Database → Oracle )
  5. Transaction Control Language ( IT Notes → Database → Oracle )
  6. General ( IT Notes → Database )
  7. RDBMS ( IT Notes → Database )
  8. Data Model ( IT Notes → Database )
  9. Logical Data Model ( IT Notes → Database )
  10. Physical and Relational Data Model ( IT Notes → Database )
  11. Data Normalization ( IT Notes → Database )
  12. Managing the RDBMS ( IT Notes → Database )
  13. Security ( IT Notes → Database )
  14. Performance Issue ( IT Notes → Database )
  15. SQL ( IT Notes → Database → SQL )
  16. Create Table ( IT Notes → Database → SQL )
  17. Import Data ( IT Notes → Database → SQL )
  18. Select ( IT Notes → Database → SQL )
  19. Update ( IT Notes → Database → SQL )
  20. Delete ( IT Notes → Database → SQL )
  21. Join ( IT Notes → Database → SQL )
  22. Create ( IT Notes → Database → SQL )
  23. View ( IT Notes → Database → SQL )
  24. Programming ( IT Notes → Database )
  25. MS SQL ( IT Notes → Database )
  26. Abbreviations ( IT Notes → Abbreviations )
  27. OOP Concepts or Object Oriented Programming Concepts ( IT Notes → Object Oriented Programming )
  28. Basics ( IT Notes → Javascript )
  29. Regex ( IT Notes → Javascript )
  30. Functions ( IT Notes → Javascript )
  31. General ( IT Notes → Javascript )
  32. Debugging ( IT Notes → Javascript )
  33. Data Types ( IT Notes → PHP )
  34. Operators ( IT Notes → PHP )
  35. Design Pattern ( IT Notes → PHP )
  36. Security ( IT Notes → PHP )
  37. Streams and Network Programming ( IT Notes → PHP )
  38. Arrays ( IT Notes → C# )
  39. Namespace ( IT Notes → C# )
  40. Indexers ( IT Notes → C# )
  41. Generics ( IT Notes → C# )
  42. Attributes ( IT Notes → C# )
  43. Anonymous Types ( IT Notes → C# )
  44. Performance Thumb Rules ( IT Notes → C# )
  45. Basic Documents to be Developed ( IT Notes → Testing )
  46. Different Types of Testing ( IT Notes → Testing )
  47. Excel Template to Replicate QC ( IT Notes → Testing )
  48. HTTP Status Messages ( IT Notes → URL Rewrite )
  49. General ( IT Notes → SEO )
  50. IT Notes ( IT Notes )
0 0 votes
Article Rating
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x