Browsing category Oracle Database

Introduction to PL/SQL (Lexical Units & Operator)


Lexical Units: Lexical units include letters, numerals, special characters, tabs, spaces, returns and symbol that building a PL/SQL block. Lexical unit can classified as following… Identifier Delimiters Literals Comments Identifier: Identifier are the names given to PL/SQL objects. Quoted Identifier: Quoted identifier makes identifier case sensitive, include character such as space and use reserved words.

Introduction to PL/SQL (Composite Data Type)


Composite data type: Composite data type stores values that have internal components. You can pass entire composite variables to subprograms as parameters, and you can access internal components of composite variables individually. Internal components can be either scalar or composite. You can use scalar components wherever you can use scalar variables or you can use

Introduction to PL/SQL (Variable & Data type)


Variable: Variable are mainly used for temporary storage of data and manipulation of stored data. Variable can stored any PL/SQL objects, such as variables, types, cursors and subprograms. Variable can be used repeatedly in an application by referring to them in the statements. Identifier & Variable: Identifier are name of the variables. Variable are storage

Introduction to PL/SQL (Basic)


PL/SQL (Procedural Language/Structured Query Language): PL/SQL is Oracle Corporation’s procedural language extension for SQL and Oracle corporation’s standard data access language for relational database. PL/SQL is available in Oracle Database since version 7. PL/SQL includes procedural language elements such as conditions and loops. You can declare constants and variables, procedures and functions, types and variables

How to Install APEX with Oracle 11g


আসসালামু আলাইকুম। বন্ধুরা আজকে আমি দেখাবো কিভাবে Oracle Database 11g এর সাথে Oracle APEX ইন্সটল করবেন। মনে রাখবেন APEX ইন্সটল করতে হলে আপনার ডাটাবেজ ভার্সন 11g বা তার উপরে হতে হবে। প্রথমেই এই লিঙ্ক থেকে APEX এর সর্বশেষ ভার্সনটি ডাউনলোড করে নিন। আমি নতুন টেবিলস্পেসে APEX ইন্সটল করে দেখাব, আপনি চাইলে ডাটাবেজের ডিফল্ট টেবিলস্পেসও (SYSAUX)

Follow Me

Oracle Certification