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 …
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 …
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 …
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 …
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
Hello friends, in this article I’m going to show you how to find execution history of an sql_id. The below script will display the execution history of a sql_id from AWR. It will join the dba_hist_sqlstat and dba_hist_sqlsnapshot table to get the required information. Read: ORA 25153 Temporary Tablespace is …
Here is the solution of ORA 25153. If you faced the above error just add more space in the temporary tablespace or add a new tempfile in the temporary tablespace. How to check temporary tablespace in oracle Check the temporary tablespace size using the below query. Or you can use …
In this article we are going to show you how to get tablespace quota details of an user in oracle. Using below query you can get the tablespace quota details of the user. Output from above query: HOW TO GET TABLESPACE QUOTA DETAILS FOR A PARTICULAR USER Using below query …
Read moreHow To Get Tablespace Quota Details Of An User In Oracle
Hello Friends, In this article we are going to show you how to get ddl of all tablespaces in oracle. Get DDL of All Tablespaces Oracle Use below query to get ddl of all tablespaces in oracle. If you really like this article, please subscribe my YouTube channel. Read – …
Hello Friends, In this article we are going to discus how to recover our controlfile without backup. Suppose if your controlfile is deleted accidently and you don’t have any backup then what is the why to recover them. So here you can find out the manual re-creation method to your …