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 …

Read moreGlobal Temporary Tables

Character Functions in SQL

SQL Character Function

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 …

Read moreSQL Character Function

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 …

Read moreSingle Row Functions

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 …


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 …

Read moreWhat is SQL, DBMS, and RDBMS

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 …

Read moreHow to Change password without showing the actual password on screen?

Enable Notifications    OK No thanks