• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer navigation

The Geek Diary

  • OS
    • Linux
    • CentOS/RHEL
    • Solaris
    • Oracle Linux
    • VCS
  • Interview Questions
  • Database
    • oracle
    • oracle 12c
    • ASM
    • mysql
    • MariaDB
  • DevOps
    • Docker
    • Shell Scripting
  • Big Data
    • Hadoop
    • Cloudera
    • Hortonworks HDP

Archives for February 2022

IF statements in PL/SQL

by admin

You have learned to write PL/SQL blocks containing declarative and executable sections. You have also learned to include expressions and SQL statements in the executable block. In this post, you will learn how to use control structures such as IF statements in a PL/SQL block. IF Statement The structure of the PL/SQL IF statement is […]

Filed Under: oracle, PL/SQL

What is a SQL Cursor

by admin

A cursor is a pointer to the private memory area allocated by the Oracle Server. It is used to handle the result set of a SELECT statement. There are two types of cursors: implicit and explicit. Implicit: Created and managed internally by the Oracle Server to process SQL statements. Explicit: Declared explicitly by the programmer […]

Filed Under: oracle, PL/SQL

Using PL/SQL to Manipulate Data using DML Commands

by admin

You can manipulate data in the database by using DML commands. You can issue DML commands such as INSERT, UPDATE, DELETE, and MERGE without restriction in PL/SQL. Row locks (and table locks) are released by including the COMMIT or ROLLBACK statements in the PL/SQL code. The INSERT statement adds new rows to the table. The […]

Filed Under: oracle, PL/SQL

Retrieving data with PL/SQL

by admin

SQL Statements in PL/SQL In a PL/SQL block, you use SQL statements to retrieve and modify data from the database table. PL/SQL supports data manipulation language (DML) and transaction control commands. You can use DML commands to modify the data in a database table. However, remember the following points while using DML statements and transaction […]

Filed Under: oracle, PL/SQL

Operators in PL/SQL

by admin

The operations in an expression are performed in a particular order depending on their precedence (priority). The following table shows the default order of operations from high priority to low priority: Operator Operation ** Exponentiation +, – Identity, negation *, / Multiplication, division +, -, || Addition, subtraction, concatenation =,, =, , !=, ~=, ^=, […]

Filed Under: oracle, PL/SQL

PL/SQL Nested Blocks

by admin

Being procedural gives PL/SQL the ability to nest statements. You can nest blocks wherever an executable statement is allowed, thus making the nested block a statement. If your executable section has code for many logically related functionalities to support multiple business requirements, you can divide the executable section into smaller blocks. The exception section can […]

Filed Under: oracle, PL/SQL

What are Lexical Units in a PL/SQL Block

by admin

Lexical Units in a PL/SQL Block Lexical units include letters, numerals, special characters, tabs, spaces, returns, and symbols. Identifiers Identifiers are the names given to PL/SQL objects. You learned to identify valid and invalid identifiers. Recall that keywords cannot be used as identifiers. Quoted identifiers: Make identifiers case-sensitive Include characters such as spaces Use reserved […]

Filed Under: oracle, PL/SQL

Declaring PL/SQL Variables

by admin

With PL/SQL, you can declare variables, and then use them in SQL and procedural statements. Variables are mainly used for storage of data and manipulation of stored values. Consider the PL/SQL statement given below: SELECT first_name, department_id INTO v_fname, v_deptno FROM … The statement retrieves first_name and department_id from the table. If you have to […]

Filed Under: oracle, PL/SQL

dpkg-reconfigure Command Options

by admin

When a package is installed, it may run a configuration script as part of the installation process. To run this configuration script again at some point in the future, use the dpkg-reconfigure command. Although there are some options to this command, they are rarely used. Syntax of the dpkg-reconfigure command: # dpkg-reconfigure [options] source packages […]

Filed Under: Linux, Ubuntu

How to use ldconfig Command in Linux

by admin

ldconfig command is used to tell the system about new locations of shared libraries. The uses information provided by the /etc/ld.so.conf configuration file. The ldconfig command creates a cache database of all libraries based on the configuration file. This cache is normally stored in the /etc/ld.so.cache file. Here is the syntax of the ldconfig command: […]

Filed Under: CentOS/RHEL, Linux

Next Page »

Primary Sidebar

Recent Posts

  • nixos-rebuild Command Examples in Linux
  • nixos-option: Command Examples in Linux
  • nixos-container : Command Examples in Linux
  • nitrogen Command Examples in Linux

© 2023 · The Geek Diary

  • Archives
  • Contact Us
  • Copyright