fbpx

Global Temporary Tables

Global Temporary Tables

Applications regularly utilize some type of impermanent information store for processes that are too convoluted to finish in a solitary pass. Regularly, these transitory stores are characterized as data set tables or PL/SQL tables. From Oracle 8i ahead, the upkeep and the board of transitory tables can be assigned to the waiter by utilizing Global … Read more

SQL Character Function

Character Functions in SQL

What is Character Functions Hello, friends in this article we are going to discuss how to use Character Functions in SQL. The character functions accept only Character type values and return in character and number both. Type of Character Functions There are Eight types of Character Functions in SQL. CONCAT SUBSTR LENGTH INSTR LPAD RPAD … Read more

Single Row Functions

Single Row Functions

Single row functions operate on a single row only then return one result for each row, there are many types of single-row functions. Following are the types of Single Row Functions. Number Function. Date Function. Character Function. Conversion Function. General Function. Number Function Always accept only numeric values and also return always numeric values. Number Function … Read more

How to create a SEQUENCE step by step

How to create a SEQUENCE step by step

In this article, we are going to learn how to create and use SEQUENCE. What is SEQUENCE? SEQUENCE is an oracle shareable object which is generated numeric values and it can be unique. you can use this value as a primary key and unique value. Let see how to create SEQUENCE and how to use sequence step by step. How to … Read more

Alter table drop column Oracle

alter table modify column oracle example

Hello friends, In this article, we are going to discuss, how to use the ALTER TABLE ORACLE MODIFY column. Using this command we can modify table structure if required after table creation. Alter Table Oracle Modify In this practical, we are using the following table which has three columns. Modify Column Suppose, I want to … Read more

How to create DB Link?

create db link

In this article, I’m going to show you how to create a DB Link step by step. How to create a database link, A database link is a schema object in one database that enables you to access objects on another database. The other database need not be an Oracle Database system. However, to access … Read more

What is SQL, DBMS, and RDBMS

What is SQL DBMS and RDBMS

What is SQL, DBMS and RDBMS Hello friends, in this article we going to discuss what is SQL ( Structured Query Language), DBMS (Database Management System), and RDBMS (Relational Database Management System), also understand what is the difference between DBMS and RDBMS. What is SQL? SQL (Structured Query Language) is used for Data Manipulation and … Read more

Using SQL Select Statements

use SQL select statement

How to use SQL select statement? In this article, we are going to learn how to use SQL select statement to retrieve data from tables or views. In the database, data stored in tables format and if you want to check that data then you should know how to use Oracle SQL statements. Important points for … Read more

How to Change password without showing the actual password on screen?

How to Change password without showing the actual password on screen

Hello friends, today we are going to discuss how to change the oracle user password without showing the actual PASSWORD on the screen. There is two way one is with ALTER command another one is PASSWORD keyword. But in the case of alter command, the password will show on screen, and in the case of PASSWORD, the keyword did not. In my case, … Read more

Display all the tables with foreign key

Display all the tables with foreign key

Hello, friends in this article we are going to discuss how to display all the tables in a schema with foreign key relations and the number of records for the parent and the child tables. How do I see all foreign keys to a table or column? The following query will solve our problem, execute … Read more