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 Find CPU And Memory Information Of Oracle Database Server

Hello friends, In this article we are going to find cpu and memory information of oracle database server. The below script will help us to get CPU, memory and core, socket information of an Oracle database server from SQL prompt. Output from above query. Read: How To Find Execution History …

Read moreHow To Find CPU And Memory Information Of Oracle Database Server

Enable Notifications    OK No thanks