Showing posts from June, 2024
Transposing data in Microsoft Excel means converting rows into columns and vice versa. This can be useful for reformatting data to better suit your needs. Here are several methods to transpose data in Excel: Method 1: Using the Paste Special Feature S…
Changing the case of text in Microsoft Word can be done quickly using several methods. Here are the steps for different ways to change the case: Method 1: Using the Ribbon Select the Text : Highlight the text you want to change. G…
In Oracle, tablespace coalescing is the process of merging adjacent free space chunks in a tablespace into a single larger chunk of free space. This process helps in improving space management by reducing fragmentation, making larger contiguous blocks…
The COALESCE function in Oracle is used to return the first non-NULL expression among its arguments. It is a very useful function for handling NULL values and ensuring that some meaningful data is returned even when some inputs might be NULL. Syntax …
To find the datafile in which a table is stored in Oracle, you need to trace the storage of the table down to its datafile(s). The storage hierarchy involves the following Oracle components: Table : The actual data container. Segment : A segment is a …
How to block an application for example TOAD in oracle ---DIRECTORY CREATION CREATE OR REPLACE DIRECTORY ADMIN as '/apps/app/oracle/product/9201/network/log/' ; -in the above command you need to replace the path with your listener.log …
$ sqlplus "/as sysdba" SQL*Plus: Release 9.2.0.1.0 - Production on Tue Mar 9 14:05:49 2010 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. ERROR: ORA-01075: you are currently logged on ACTION $ echo $ORACLE_SID SS…
Database login auditing in Oracle involves tracking and monitoring user login activities to ensure database security and compliance with policies and regulations. Oracle provides several ways to audit login activities, including: Standard Auditing Uni…
In Oracle, a package is a schema object that groups logically related PL/SQL types, variables, constants, subprograms (procedures and functions), cursors, and exceptions. Packages have two parts: the specification and the body. Package Specification :…
In Oracle Database, a profile is a set of limits on database resources and password policies that you can assign to users. Profiles help manage database security and resource allocation. You can use profiles to control things like password expiration,…
In Oracle, database links (dblinks) allow you to access data in a remote database from your local database. There are two types of database links: public and private. Here’s a detailed explanation of the differences between public and private dblinks:…
How to change processes/sessions parameter in Oracle To change the processes or sessions parameter in Oracle, you need to modify the initialization parameter file ( init.ora or spfile.ora ) and then restart the Oracle instance. Here's a step-b…
