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

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