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 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 …

Read moreSingle Row Functions

alter table modify column oracle example

ORACLE ALTER TABLE MODIFY

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 following table which has three columns. Modify Column …

Read moreORACLE ALTER TABLE 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