Oracle Sql Archives - Page 3 of 17

Sequence in Oracle: Use, Modify, Reset, Drop

What is Sequence in Oracle? Creating a sequence is done using the CREATE SEQUENCE [START WITH] [INCREMENT BY] [NO/MINVALUE] [NO/MAXVALUE] [NO/CYCLE] [NO/CACHE]; Description of each value Examples create sequence test_tech start with 1increment by 1maxvalue 10000cyclecache 20;Orcreate sequence test_tech1start with 1increment by 1maxvalue 4500000cyclenocache; How to use sequences To use sequence simply use the …

Sequence in Oracle: Use, Modify, Reset, Drop Read More »

How to use Coalesce Function in Oracle

Oracle, Oracle Sql

What is Coalesce Function Coalesce Function is a useful function in oracle and it is very useful when we want to return the first non-null values in the list. This SQL tutorial provides explanations, examples for Coalesce Function in Oracle and the Difference between Coalesce & NVL expr1: This is returned if it is not …

How to use Coalesce Function in Oracle Read More »

What is cursor in oracle

Oracle, Oracle Sql

In this post, we will learn about what is cursor in oracle, the types of cursors, how to fetch the row, and how to close the cursor. I hope you will like this What is a cursor in oracle? Oracle Uses a work area called Private SQL areas to execute SQL Statements and store information. …

What is cursor in oracle Read More »

what is materialized views in oracle?

Oracle, Oracle Sql

What are materialized views in Oracle? Privileges required to create materialized view User must have CREATE MATERIALIZED VIEW to create materialized view General Syntax CREATE MATERIALIZED VIEW BUILD [IMMEDIATE | DEFERRED] REFRESH [FAST | COMPLETE | FORCE ] ON [COMMIT | DEMAND ] [[ENABLE | DISABLE] QUERY REWRITE] [ON PREBUILT TABLE] AS ; Explanation of each term …

what is materialized views in oracle? Read More »

How to create view in oracle

Oracle, Oracle Database, Oracle Sql

In this post,I would be talking about Oracle views which is used quite heavily in various application for security and complexity reason.I would be listing complete life cycle of Oracle view i.e How to create view in oracle,Oracle create view example,how to alter view in oracle,How to compile view in oracle,How to drop view in …

How to create view in oracle Read More »

How to use Analytic functions in oracle (Over Partition by Keyword)

Oracle, Oracle Sql

This post is part of Oracle SQL tutorial and we would be discussing Analytic functions in oracle(Over by partition) with examples, detailed explanation . Analytic functions in oracle We have already studied about Oracle Aggregate function like avg ,sum ,count. Lets take an example First lets create the sample data CREATE TABLE “DEPT” ( “DEPTNO” …

How to use Analytic functions in oracle (Over Partition by Keyword) Read More »