Ref: Software Engineering Course: https://www.cs.ox.ac.uk/people/michael.wooldridge/teaching/soft-eng/ https://www.cs.ox.ac.uk/people/michael.wooldridge/teaching/soft-eng/lect07-4up.pdf
Category: ব্লগ । Blog
ব্লগ । Blog
May 12
Oracle PL/SQL: If-Then-Else, For Loop, While Loop
How it works: if, elsif, else (then) (Click on the images to see them clearly) Ref: https://docs.oracle.com/cd/B13789_01/appdev.101/b10807/13_elems024.htm Example: Ref: https://docs.oracle.com/cd/B13789_01/appdev.101/b10807/13_elems024.htm Oracle: CASE, WHEN, THEN Simple: Searched: ” Else: Reverse For Loop Ref: For Loop Examples in Oracle https://docs.oracle.com/cd/E11882_01/appdev.112/e25519/controlstatements.htm#BABEFFDC Oracle While Loop While loop example from the referenced url DECLARE done BOOLEAN := FALSE; BEGIN WHILE …
May 12
Oracle Sub Types for Data Types: Exception Block
An unconstrained subtype has the same set of values as its base type, so it is only another name for the base type. Syntax: SUBTYPE subtype_name IS base_type Example: SUBTYPE "DOUBLE PRECISION" IS FLOAT SUBTYPE Balance IS NUMBER; Constrained SubType SUBTYPE Balance IS NUMBER(8,2); Oracle Exception Block Example: Ref: https://docs.oracle.com/cd/B13789_01/appdev.101/b10807/07_errs.htm
May 12
Misc. Oracle: Data Types: Why a Data Type.
Ref: https://docs.oracle.com/cd/B13789_01/appdev.101/b10807/02_funds.htm https://stackoverflow.com/questions/7425153/reason-why-oracle-is-case-sensitive Oracle Data Types and Allowed Sizes: https://docs.oracle.com/cd/E11882_01/appdev.112/e25519/datatypes.htm#LNPLS99943 Oracle SIMPLE_FLOAT vs SIMPLE_DOUBLE Ref: https://docs.oracle.com/cd/B28359_01/appdev.111/b28370/datatypes.htm#CJAEAEJG PLS_Integer vs Number "The PLS_INTEGER data type has these advantages over the NUMBER data type and NUMBER subtypes: PLS_INTEGER values require less storage. PLS_INTEGER operations use hardware arithmetic, so they are faster than NUMBER operations, " Ref: https://docs.oracle.com/cd/E11882_01/appdev.112/e25519/datatypes.htm#LNPLS319 Hardly …
May 12
Oracle Data types, ROWID, PLS_INTEGER vs INTEGER
Data Types Ref: https://docs.oracle.com/cd/A97630_01/server.920/a96524/c13datyp.htm (Click on the image to see it properly) Why PLS_Integer: https://docs.oracle.com/cd/B13789_01/appdev.101/b10807/03_types.htm “You use the PLS_INTEGER datatype to store signed integers. Its magnitude range is -231 .. 231. PLS_INTEGER values require less storage than NUMBER values. Also, PLS_INTEGER operations use machine arithmetic, so they are faster than NUMBER and BINARY_INTEGER operations, which …
May 12
Algorithm Complexity: Notations and Comparisons
Algorithm Complexity Notations and Comparisons: Ref: https://www.freecodecamp.org/news/big-o-notation-why-it-matters-and-why-it-doesnt-1674cfa8a23c/
May 12
Algorithm Complexity: A simple example
The complexity here is: 3n+2 i.e. O(n) Ref: https://www2.cs.sfu.ca/CourseCentral/125/johnwill/Packet06.pdf
May 06
Proxy Pattern
Proxy Pattern: “Proxy is a structural design pattern that lets you provide a substitute or placeholder for another object. A proxy controls access to the original object, allowing you to perform something either before or after the request gets through to the original object.” “A credit card is a proxy for a bank account, which …
May 06
Java: Facade Design Pattern
Façade Pattern “Facade is a structural design pattern that provides a simplified interface to a library, a framework, or any other complex set of classes.” “When you call a shop to place a phone order, an operator is your facade to all services and departments of the shop. The operator provides you with a simple …
May 06
Java : Decorator Design pattern
Decorator Design pattern: Decorator is a structural design pattern that lets you attach new behaviors to objects by placing these objects inside special wrapper objects that contain the behaviors. Example: Assume: A notifier class/object can send only email messages. But the application at a later time may want to use text/SMS, FB, or similar messages. …
