SQL Tutorial : Difference Between Count(1) and Count(*) in SQL Oracle
SQL Tutorial
SQL Tutorial for beginners
PLSQL Tutorial
PLSQL Tutorial for beginners
PL/SQL Tutorial
PL SQL Tutorial
PL SQL Tutorial for beginners
PL/SQL Tutorial for beginners
Oracle SQL Tutorial
Views: 3139
TechLake
https://www.databasestar.com/oracle-count/
The Oracle COUNT function is used to count the number of rows from the column, or number of values, provided to it.
It’s commonly used to find the number of rows returned by a SELECT query.
The syntax of the COUNT function is:
COUNT ( [ * | [ DISTINCT | ALL ] expression) [ over (analytic_clause) ]
There’s a lot of square brackets here, indicating optional parameters and choices. This just means you can use the COUNT function in a few different ways:
COUNT(*)
COUNT(DISTINCT expression)
COUNT(ALL expression)
COUNT(*) OVER (analytic_clause)
COUNT(DISTINCT expression) OVER (analytic_clause)
COUNT(ALL expression) OVER (analytic_clause)
It can be used as an aggregate or analytic function.
The parameters of the COUNT function are:
- expression: The expression to count the values of. This can be a column or a set of values, for example.
- analytic_clause: This is used to specify the criteria for an analytic query.
COUNT(*) is the most common way to use this function, I’ve found.
As COUNT(*) is an aggregate function, like all aggregate functions the columns mentioned in the SELECT clause need to exist in the GROUP BY clause.
NULL values are ignored by COUNT(expression), but they are counted when using COUNT(*).
COUNT(*) has the exact same calculation and performance as COUNT(1).
For more information about the Oracle COUNT function, including all of the SQL shown in this video and the examples, read the related article here:
https://www.databasestar.com/oracle-count/
Views: 232
Database Star
Oracle SQL, PL/SQL, Select Kullanımı ve Eğitimi 2 -Select, min, max, sum, count, avg, having, oracle select statement, oracle select education, PL/SQL
Select, min, max, sum, count, avg, having, PL/SQL
Beğendiyseniz Beğen Butonuna basmayı ve Abone olarak destek olmayı unutmayın.
Views: 192
Taner TOPCU
Oracle SQL Video Tutorials 29 - COUNT function explained.In This Oracle SQL Tutorial for Beginners, I have explained basics of SQL.These examples work on Oracle 10g and Oracle 11g database. These helps youto understand Oracle Joins and helps beginners. Iam going to add more tutorials on Oracle DBA, Oracle RAC and Oracle PL/SQL.All Oracle sql tutorial with examples are executed on Oracle 11g using Oracle SQL Developer.
Views: 2955
Just Channel
Oracle SQL Developer Tutorial For Beginners Series.
This course introduces Oracle SQL Development for its subscribers. Currently this is based on Oracle 12c. The test environment is in Windows 10.
Views: 2946
Sam Dhanasekaran
Функция — это подпрограмма на языке ORACLE PL SQL, которая вычисляет значения и возвращает результат вычисления.
У функции есть уникальное в рамках схемы БД имя и набор параметров.
Функцию можно вызывать из другой процедуры или функции, а также из анонимного PL SQL блока.
Oracle PL SQL.
учебная среда https://apex.oracle.com/pls/apex/f?p=4550:1:103440124..:::::
схема: SQLADV польз: student1 пароль: student1
будут работать (student2/ student2, student3/ student3 .... student11/ student11) меню SQL Workshop , SQL Command
или используйте http://sqlfiddle.com/
скрипт бд для загрузки в sqlfiddle http://sqladv.ru/dev/sql.txt
урок и задания
http://sqladv.ru/dev/plsql/l9.txt
Views: 318
SQL adv school Макс Чалышев
From SQL Queries Joes 2 Pros (Vol2) ch4.1. Learn up to write aggregated queries.
Views: 172959
Joes2Pros SQL Trainings
Oracle SQL, PL/SQL, Select Kullanımı ve Eğitimi 4 - select, round, trunc, floor, ceil, oracle select statement, oracle select education, PL/SQL
Beğendiyseniz Beğen Butonuna basmayı ve Abone olarak destek olmayı unutmayın.
Views: 158
Taner TOPCU
Join discussion: http://www.techtud.com/video-lecture/understanding-group-clause-sql
IMPORTANT LINKS:
1) Official Website: http://www.techtud.com/
2) Virtual GATE: http://virtualgate.in/login/index.php
Both of the above mentioned platforms are COMPLETELY FREE, so feel free to Explore, Learn, Practice & Share!
Our Social Media Links:
Facebook Page: https://www.facebook.com/techtuduniversity
Facebook Group: https://www.facebook.com/groups/virtualgate
Google+ Page: https://plus.google.com/+techtud/posts
Last but not the least, SUBSCRIBE our YouTube channel to stay updated about the regularly uploaded new videos.
Views: 70258
Techtud
RebellionRider presents PL/SQL tutorial explaining the concepts of Collection Method COUNT in Oracle Database. This tutorial will help you in learning the basics of COUNT function. This video will also help you in learning –
What is collection method Count in Oracle Database
• How to use COUNT function
• How to use COUNT function with IF Condition
• How to use COUNT function with For-Loop
Hope you will enjoy. Do make sure to Like, Share & Subscribe. Thanks
Tweet Link: https://twitter.com/OracleSQLDev/status/872441483223281664
Follow me on Twitter: https://twitter.com/RebellionRider
------------------------------------------------------------------------
►►►LINKS◄◄◄
Blog: http://bit.ly/count-function
Previous Tutorial
► Introduction to collection methods https://youtu.be/8V40IaOkGcU
► Tut 51. How to create nested table
https://youtu.be/EUYyiFCzU0I
-------------------------------------------------------------------------
►Make sure you SUBSCRIBE and be the 1st one to see my videos!
-------------------------------------------------------------------------
►►►Find me on Social Media◄◄◄
Follow What I am up to as it happens on
https://twitter.com/rebellionrider
http://instagram.com/rebellionrider
https://plus.google.com/+Rebellionrider
http://in.linkedin.com/in/mannbhardwaj/
___Facebook Official Page of Manish Sharma___
https://www.facebook.com/TheRebellionRider/
___Facebook Official Page of RebellionRider.com___
https://www.facebook.com/RebellionRider.official/
You can also Email me at
for E-mail address please check the About section
Please please LIKE and SHARE my videos it makes me happy.
Thanks for liking, commenting, sharing and watching more of our videos
This is Manish from RebellionRider.com
♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 7846
Manish Sharma
In this video I use the COUNT and SUM functions available to the SQL language. I used the COUNT function to add up the number of records in my query. This function works well with all data types and will just count the number or records that result from the conditions of your query. The SUM function will add up the numeric values and produce a total amount of a column. When using a function be sure to use parenthesis around the column you are performing the function on. This video is part of a series of videos with the purpose of learning the SQL language. For more information visit Lecture Snippets at http://lecturesnippets.com.
Views: 7808
Lecture Snippets
Learn to summarize yoru data using the SQL Aggregates such as count and sum and the GROUP BY and HAVING clauses of the SELECT statement
Views: 150988
Michael Fudge
Курсы по SQL: https://goo.gl/uCWxEP регистрируйся!
SQL для чайников | SELECT - оператор DML языка SQL
SELECT (англ., означает «выбрать») — оператор DML языка SQL, возвращающий набор данных (выборку) из базы данных, удовлетворяющих заданному условию.
В данном видео я показываю, как пользоваться оператором языка SQL - SELECT
Полная конструкция:
SELECT
[DISTINCT | DISTINCTROW | ALL]
select_expression,...
FROM table_references
[WHERE where_definition]
[GROUP BY {unsigned_integer | col_name | formula}]
[HAVING where_definition]
[ORDER BY {unsigned_integer | col_name | formula} [ASC | DESC], ...]
SQL для начинающих, SQL для чайников, SQL для новичка!!! Пройди курсы по SQL: https://goo.gl/uCWxEP
Views: 9155
Oracle RUS
Oracle SQL, PL/SQL, Select Kullanımı ve Eğitimi 1 - Select, Where, Order By, Group By, Having, Distinct, oracle select statement, oracle select education, PL/SQL
Select, Where, Order By, Group By, Having, Distinct, PL/SQL
Views: 330
Taner TOPCU
Curso Grátis Oracle PL/SQL: http://bit.ly/1fOyQ6A
Aula 07 - SQL Parte 04 - Select - Curso Oracle PL/SQL
Nesta aula tratamos dos seguintes assuntos:
1º O que é um SELECT;
2º A Sintax de um SELECT;
3º Clausula WHERE;
4º Como usar um ORDER BY;
5º Um pouco sobre JOINs;
6º GROUP BY o que é e como utiliza-lo;
7º Funções do GROUP BY;
8º Aprenda a utilizar o HAVING;
9º SUBQUERIES e algumas formas de usá-las.
Views:
William Miranda
DISTINCT & UNIQUE Keyword in Oracle | Oracle Tutorials for Beginners
DISTINCT Keyword in Oracle
DISTINCT Clause in Oracle
UNIQUE Keyword in Oracle
UNIQUE Clause in Oracle
Oracle Tutorials for Beginners
Oracle Tutorials for Beginners
select distinct *
sql distinct multiple columns
sql distinct count
select distinct on one column with multiple columns returned
select distinct mysql
sql count distinct multiple columns
oracle distinct count
sql distinct group by
sql count distinct two columns
select distinct on one column with multiple columns returned
select distinct on one column with multiple columns returned oracle
sql select unique values from multiple columns
select distinct multiple columns mysql
select distinct all columns
sql count distinct multiple columns group by
sql select distinct multiple columns group by
select distinct
oracle select distinct rows
sql select distinct multiple columns
select distinct on one column
select count distinct
select unique mysql
how to select unique records in oracle without using distinct
sql select distinct values and count of each
Oracle Tutorials for Beginners
Oracle Tutorials for Beginners
Oracle Tutorials for Beginners
Oracle Tutorials for Beginners
Views: 597
Oracle PL/SQL World
Oracle tutorial : Global Temporary Table In Oracle PL SQL
create temp table sql
This video will explain to you how to create Temporary Tables in Oracle
Oracle tutorial : Global Temporary Table In Oracle
1)The data in such a table is stored only as long as the session or transaction lasts and is private for each session.
2)The definition is visible to all sessions.
3)After commit or disconnection, the data is lost but the definition of the table remains.
4)Indexes created on a temporary.
5)Scope of TRUNCATE command is a single database session. There is no effect of TRUNCATE on other sessions.
6)Foreign key constraints are not applicable in case of Temporary tables
7)Temporary tables cannot contain column of persistent collection type
Syntax :
CREATE GLOBAL TEMPORARY TABLE table_name
( column_name column_data_type
…
…
) ON COMMIT DELETE ROWS;
CREATE GLOBAL TEMPORARY TABLE Emp (
id number(5) NOT NULL,
name varchar2(50) NOT NULL,
city varchar2(50) NOT NULL ) ON COMMIT DELETE ROWS
INSERT INTO Emp VALUES (1, ‘Test1’, ‘city1’);
INSERT INTO Emp VALUES (2, ‘Test2’, ‘city2’);
INSERT INTO Emp VALUES (3, ‘Test3’, ‘city3’);
SELECT COUNT(*) FROM emp;
Result = 3 rows
COMMIT;
SELECT COUNT(*) FROM emp;
Result = 0 rows
For more tutorial please visit #techquerypond
https://techquerypond.com
https://techquerypond.wordpress.com
https://twitter.com/techquerypond
oracle temporary table
create temporary table sql
temp table
Views: 3962
Tech Query Pond
select, functions like min, max, count, sum, avg in oracle database. Demonstration of working on a table and data in it.
Please like and subscribe us.
Views: 86
Let's Learn Pro
Count Syntax:
select count(*) from tabela;
select count(coluna) from tabela;
Views: 1506
SelectTec
This video demonstrates how a function can return multiple values to the calling environment, but without using multiple out parameters, the video shows an example on how we can create a object, a nested table based on the object and then returning the nested table type from the function.
Views: 19484
Kishan Mashru
RebellionRider.com presents a PL/SQL tutorial on how to use the BULK COLLECT clause with SELECT INTO statement in Oracle Database by Manish Sharma. In this tutorial, you will also learn how to overcome the overhead caused by context switch and improve the query performance.
------------------------------------------------------------------------
►►►LINKS◄◄◄
Blog: http://bit.ly/bulk-collect-2
Previous Tutorial
►Introduction to Bulk Collect: https://youtu.be/CrJSlf_m3yA
►PL/SQL Tutorial 51-Nested Table: https://youtu.be/EUYyiFCzU0I
►Collection Method Count:https://youtu.be/NNq80CcC5K8
-------------------------------------------------------------------------
►Make sure you SUBSCRIBE and be the 1st one to see my videos!
-------------------------------------------------------------------------
►►►Find me on Social Media◄◄◄
Follow What I am up to as it happens on
https://twitter.com/rebellionrider
http://instagram.com/rebellionrider
https://plus.google.com/+Rebellionrider
http://in.linkedin.com/in/mannbhardwaj/
___Facebook Official Page of Manish Sharma___
https://www.facebook.com/TheRebellionRider/
___Facebook Official Page of RebellionRider.com___
https://www.facebook.com/RebellionRider.official/
You can also Email me at
for E-mail address please check the About section
Please please LIKE and SHARE my videos it makes me happy.
Thanks for liking, commenting, sharing and watching more of our videos
This is Manish from RebellionRider.com
♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 10855
Manish Sharma
This SQL tutorial and Oracle database 11g tutorial for beginners will show how to use SQL DISTINCT keyword with SQL Select clause.
This Video is in the continuation of previous video on SQL distinct with one column. In this video we will see How to use SQL distinct with multiple columns and SQL distinct with two columns
Tool used in this tutorial is SQL developer.
This tutorial series is part of SQL expert exam certification training. If you are preparing for SQL certification you can use my tutorials. This SQL Tutorial is a part of free training.
Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage
https://copy.com?r=j7eYO7
Contacts
Email
[email protected]
Twitter
https://twitter.com/rebellionrider
Instagram
http://instagram.com/rebellionrider
Facebook.
https://www.facebook.com/imthebhardwaj
Linkedin.
in.linkedin.com/in/mannbhardwaj/
Thanks for linking, commenting, sharing and watching more of our videos
This is Manish
From The Code makers
Views: 99465
Manish Sharma
select syntax:
select * from tabela;
Views: 6047
SelectTec
Dates in Oracle PL SQL is definitely the most powerful among all other databases. It gives us full flexibility to manipulate it of our choice, whether you are calculating days, months or year, printing date and time in various format. Useful date functions add_months, months_between, last_day, next_day and to_char helps us a lot in handling date time in our pl sql programming.
Views: 5529
Subhroneel Ganguly
------------------------------------------------------------------------
►►►LINKS◄◄◄
Blog: http://bit.ly/col-method-3
Previous Tutorial
► Intro of Collection Method: https://youtu.be/8V40IaOkGcU
► Collection Method COUNT: https://youtu.be/NNq80CcC5K8
► Collection Method EXIST: https://youtu.be/ksfwNxZl4gI
-------------------------------------------------------------------------
►Make sure you SUBSCRIBE and be the 1st one to see my videos!
-------------------------------------------------------------------------
►►►Find me on Social Media◄◄◄
Follow What I am up to as it happens on
https://twitter.com/rebellionrider
http://instagram.com/rebellionrider
https://plus.google.com/+Rebellionrider
http://in.linkedin.com/in/mannbhardwaj/
___Facebook Official Page of Manish Sharma___
https://www.facebook.com/TheRebellionRider/
___Facebook Official Page of RebellionRider.com___
https://www.facebook.com/RebellionRider.official/
You can also Email me at
for E-mail address please check the About section
Please please LIKE and SHARE my videos it makes me happy.
Thanks for liking, commenting, sharing and watching more of our videos
This is Manish from RebellionRider.com
♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 6148
Manish Sharma
http://studyandshare.wordpress.com/
http://www.facebook.com/groups/studyandsharevn/
Views: 927
studyandsharevn
SQL tutorial for beginners in hindi and english
SQL Select Statement on Oracle 11g Database with Example
Views: 79024
Easy Engineering Classes
How to initialize the variable by fetching values from the table of the database or by using SELECT INTO statement in PL/SQL by Manish Sharma RebellionRider
------------------------------------------------------------------------
►►►LINKS◄◄◄
Blog : http://bit.ly/select-into-statement-pl-sql
Previous Tutorial
► Variables: https://youtu.be/2MNmodawvnE
-------------------------------------------------------------------------
►►►Let's Get Free Uber Cab◄◄◄
Use Referral Code UberRebellionRider and get $20 free for your first ride.
--------------------------------------------------------------------------
►Make sure you SUBSCRIBE and be the 1st one to see my videos!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
►►►Find me on Social Media◄◄◄
Follow What I am up to as it happens on
https://twitter.com/rebellionrider
https://www.facebook.com/imthebhardwaj
http://instagram.com/rebellionrider
https://plus.google.com/+Rebellionrider
http://in.linkedin.com/in/mannbhardwaj/
http://rebellionrider.tumblr.com/
http://www.pinterest.com/rebellionrider/
You can also Email me at
for E-mail address please check About section
Please please LIKE and SHARE my videos it makes me happy.
Thanks for liking, commenting, sharing and watching more of our videos
This is Manish from RebellionRider.com
♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 123140
Manish Sharma
Views: 1100
Saif Shaikh
Use inner joins with multiple tables to create reports. Uses aliases, and the SUM aggregate function to demonstrate the flexibility of the join statement.
Get the SQL script to create the database and run the exercies in the video here: https://www.qewbi.com/sql/scripts/qewbijoins.zip
Views: 138972
Edward Kench
This video tutorial answers the frequently asked interview question, how to select only odd or even records in oracle sql, after watching this video you will understand more on the topic and will be able to answer this interview question with a lot of confidence.
Views: 4226
Kishan Mashru
SQL Tutorial : How To Delete Duplicate Records in SQL Oracle
SQL Tutorial
SQL Tutorial for beginners
PLSQL Tutorial
PLSQL Tutorial for beginners
PL/SQL Tutorial
PL SQL Tutorial
PL SQL Tutorial for beginners
PL/SQL Tutorial for beginners
Oracle SQL Tutorial
Views: 3589
TechLake
RebellionRider.com present Bulk Collect into with Execute Immediate of Native Dynamic SQL by Manish Sharma
------------------------------------------------------------------------
►►►LINKS◄◄◄
Blog: http://bit.ly/nds-8
Previous Tutorial
►Nested Table https://youtu.be/EUYyiFCzU0I
► Bulk Collect statement https://youtu.be/HPVzFBluM_Q
►For Loop https://youtu.be/DfAmnj2j7WI
►Collection Method Count https://youtu.be/NNq80CcC5K8
-------------------------------------------------------------------------
►Make sure you SUBSCRIBE and be the 1st one to see my videos!
-------------------------------------------------------------------------
►►►Find me on Social Media◄◄◄
Follow What I am up to as it happens on
https://twitter.com/rebellionrider
http://instagram.com/rebellionrider
https://plus.google.com/+Rebellionrider
http://in.linkedin.com/in/mannbhardwaj/
___Facebook Official Page of Manish Sharma___
https://www.facebook.com/TheRebellionRider/
___Facebook Official Page of RebellionRider.com___
https://www.facebook.com/RebellionRider.official/
You can also Email me at
for E-mail address please check the About section
Please please LIKE and SHARE my videos it makes me happy.
Thanks for liking, commenting, sharing and watching more of our videos
This is Manish from RebellionRider.com
♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 2698
Manish Sharma
SQL Where clause with example on Oracle 11g Database
-Oracle Sql Arabic Course Basic SELECT statement & Arithmetic Expressions اوراكل ديفيلوبر
SQL tutorial 49: CASE - Simple Case Expression in Oracle Database
The WHERE Clause: Case Sensitivity and Collations
ORACLE 11g Course Details -
Using TOAD (Tool For Oracle Application Development) in training ... Clause; Comparison and conditional operations; Arithmetic and logical operations ... Using group by and having clause of DRL statement ... Understanding the practical approach to sub queries/nested select/sub select/inner ... SQL Editor commands
Oracle 12C /Oracle12C-Wilson.asp
About SQL&SQL*PLUS; Constraints; Normalization and De-Normalization; ER Diagrams ... Working with DML, DRL Commands; Operators Support. DML-Insert, update, delete; DQL-SELECT Statements using WHERE clause; Comparison and Conditional Operators; Arithmetic and Logical Operators; Set Operators (UNION, ...
[PDF]Oracle SQL(Structured Query Language)
www.isashitsolution.com/pdf/ORACLE.pdf. Oracle. SQL(Structured Query Language) ... Working with DML, DRL Commands. • Operators Support. Build In Function. • Arithmetic Functions, Character Functions, ... Grouping the Result of a Query. • Using Group by and Having Clause of DRL. Statement ... Using VIEWS for DML Operations.
SQL select statement and functions -
Nov 20, 2013 - SQL Statements ... SQL as the standard language Oracle SQL complies with ... SQL Statements DRL - Retrieves data from the database DML ... If any column value in an arithmetic expression is null, the result is null. .... The DUAL table is generally used for SELECT clause syntax ...
[PDF]SQL Basics & PL-SQL - SQL School
sqlschool.com/downloads/PLSQL-Training-SQLSchool.pdf
SQL Basics & Oracle PL/SQL Developer Training. All Our Training ... COMMANDS. ✓ Structured Query Language (SQL) Basics ... Returning into clause, Bulk Collect. ✓ For All ... Recycle Bin, Regular Expressions in PLSQL ... DML Command DRL Commands Operators. ✓ INSERT ... Arithmetic and Logical Operators.
Operators in SQL.... - PL/SQL-Developer
plsql/2011/10/operators-in-sql.html
Oct 26, 2011 - If we select the data using select statement from dual ... Arithmetic Operators are used to perform arithmetic operations on numeric ... This is the syntax for using the IN operator. ... Unlike In condition where we will match selective multiple values, we will match .... SQL Statements Part3 (DRL,TCL and DCL).
learn oracle - Curly Brackets
learn-oracle/
Oracle Pre Defined Data types; DDL Commands; Create, Alter (add, modify, rename, ... Arithmetic Functions, Character Functions, Date Functions, Conversion ... a Query. Using Group by and Having Clause of DRL Statement; Using Order by clause ... Understanding the practical approach to Sub Queries/Nested Select/Sub ...
Oracle PL-SQL - SequelGate
oracle-plsql-training.html
Arithmetic Functions; Character Functions; Date functions; Conversion Functions ... Using Group by and Having Clause of DRL Statement; Using Order by clause ... CASE expression of Select Command, Temporary Tables/Global Tables; New ...
: DRL, DDL, DML, TCL and DCL commands
/2014/12/drl-ddl-dml-tcl-and-dcl-commands.html
DRL, DDL, DML, TCL and DCL commands. DRL (Data Retrieval Language):. Select. DDL (Data Definition Language):. Create. Alter. Drop. Truncate.
Missing: expressions
SQL Count - Wikitechy
https://www.wikitechy.com/tutorials/sql/sql-count
Tags : sql tutorial , pl sql tutorial , mysql tutorial , oracle tutorial , learn sql , sql server tutorial. Syntax ... expression can be a column name, an arithmetic operation, or a star . ... In addition to the COUNT function in the SELECT statement. In those cases, these columns need to be part of the GROUP BY clause as well
Views: 45
Muo sigma classes
MD.Rahim Uddin Shohag
Founder - Oracle Bangla
https://www.oraclebangla.com/
fb :: https://www.facebook.com/oracle.shohag
email: [email protected]
Recovery Deleted Row in Oracle using Flashback Query
============================================
i'm show you how to recovery Deleted row in oracle database
following Step ::
==================
/* FLASHBACK QUERY NO NEED DBA */
CREATE TABLE DEMO_CUSTOMER
(
CUST_ID NUMBER CONSTRAINT DEMO_CUSPRIMARY PRIMARY KEY,
CUST_NAME VARCHAR2(100 BYTE),
CUST_ADDRESS VARCHAR2(200 BYTE),
CUST_PHONE VARCHAR2(15 BYTE),
CUST_WEBSITE VARCHAR2(100 BYTE),
CREATE_DATE DATE DEFAULT SYSDATE
);
SELECT SYSDATE FROM DUAL;
--------------- INSERT RECORD ---------
INSERT INTO DEMO_CUSTOMER VALUES(100,'SHOHAG','DHAKA','121212','www.oraclebangla.com',SYSDATE);
INSERT INTO DEMO_CUSTOMER VALUES(101,'RAHIM','Feni','121212','www.google.com',SYSDATE);
INSERT INTO DEMO_CUSTOMER VALUES(103,'Rubel','karwan bazar','121343','www.obn.com',SYSDATE);
INSERT INTO DEMO_CUSTOMER VALUES(104,'Karim','DHAKA','1212432','www.OCA.com',SYSDATE);
COMMIT;
SELECT * FROM DEMO_CUSTOMER;
SELECT COUNT(*) FROM DEMO_CUSTOMER
SELECT SYSDATE FROM DUAL;
---- AFTER FEW MINUTE --------
DELETE FROM DEMO_CUSTOMER WHERE CUST_ID = 100;
DELETE FROM DEMO_CUSTOMER WHERE CUST_ID = 101;
DELETE FROM DEMO_CUSTOMER WHERE CUST_ID = 103;
COMMIT;
SELECT * FROM DEMO_CUSTOMER;
SELECT COUNT(*) FROM DEMO_CUSTOMER
-----Way No 1 AFTER 1 MINIUTE ----------
SELECT * FROM DEMO_CUSTOMER AS OF TIMESTAMP (SYSTIMESTAMP -INTERVAL '1' MINUTE) ;
SELECT COUNT(*) FROM DEMO_CUSTOMER;
SELECT * FROM DEMO_CUSTOMER;
/* IF SPECIFIC TIME FINDE DATA HISTORY */
---- why no 2
SELECT * FROM DEMO_CUSTOMER AS OF TIMESTAMP TO_TIMESTAMP('21-02-2018 04:24:40 PM','DD-MM-RRRR HH:MI:SS AM');
---============== recovery data =============
SELECT * FROM DEMO_CUSTOMER;
--------------------------- SPECIFIC DATA RECOVERY --------------------------
SELECT * FROM DEMO_CUSTOMER AS OF TIMESTAMP (SYSTIMESTAMP -INTERVAL '2' MINUTE);
INSERT INTO DEMO_CUSTOMER (SELECT * FROM DEMO_CUSTOMER AS OF TIMESTAMP (SYSTIMESTAMP -INTERVAL '2' MINUTE) WHERE CUST_ID = 101);
COMMIT;
SELECT * FROM DEMO_CUSTOMER;
--- RECOVERY SINGEL RECORD FLASHBACK 2ND WAY
SELECT * FROM DEMO_CUSTOMER AS OF TIMESTAMP TO_TIMESTAMP('21-02-2018 04:24:40 PM','DD-MM-RRRR HH:MI:SS AM');
INSERT INTO DEMO_CUSTOMER (
SELECT * FROM DEMO_CUSTOMER AS OF TIMESTAMP TO_TIMESTAMP('21-02-2018 04:24:40 PM','DD-MM-RRRR HH:MI:SS AM') WHERE CUST_ID = 100 );
COMMIT;
SELECT * FROM DEMO_CUSTOMER;
---IF YOU RECOVERY DATA ALL DELETE RECORD JUST SIMPLE TECHNIC -----
SELECT * FROM DEMO_CUSTOMER AS OF TIMESTAMP TO_TIMESTAMP('21-02-2018 04:24:40 PM','DD-MM-RRRR HH:MI:SS AM')
MINUS
SELECT * FROM DEMO_CUSTOMER
INSERT INTO DEMO_CUSTOMER(
SELECT * FROM DEMO_CUSTOMER AS OF TIMESTAMP TO_TIMESTAMP('21-02-2018 04:24:40 PM','DD-MM-RRRR HH:MI:SS AM')
MINUS
SELECT * FROM DEMO_CUSTOMER);
COMMIT;
SELECT * FROM DEMO_CUSTOMER;
SELECT COUNT(*) FROM DEMO_CUSTOMER;
------ IF YOU UPDATE RECORD FLASHBACK QUERY CHECK ---
UPDATE DEMO_CUSTOMER
SET CUST_NAME = 'Oracle'
WHERE cust_id = 104;
commit;
SELECT * FROM DEMO_CUSTOMER;
SELECT * FROM DEMO_CUSTOMER AS OF TIMESTAMP TO_TIMESTAMP('21-02-2018 04:24:40 PM','DD-MM-RRRR HH:MI:SS AM') WHERE CUST_ID = 104
SELECT * FROM DEMO_CUSTOMER AS OF TIMESTAMP TO_TIMESTAMP('21-02-2018 04:30:00 PM','DD-MM-RRRR HH:MI:SS AM') WHERE CUST_ID = 104
Views: 748
Oracle Bangla
sql aggregate functions
aggregate functions sql
sql analytic functions
oracle sql analytic functions
SQL have following aggregate functions that can be used to write queries.
1)SUM() -: return sum of columns values.
2)AVG() -: return Average of columns values.
3)COUNT() -: return count of rows according to condition in where clause.
4)COUNT(*) -: return count of rows according to condition in where clause.
5)MAX() -: return Maximum value from table.
6)MIN() -: return minimum value from table.
Note :
A)Aggregate functions used in SELECT and HAVING clauses.
B)Aggregate functions cannot be used in a WHERE clause.
SELECT SUM(SALARY)
FROM EMPLOYEE
SELECT AVG(SALARY)
FROM EMPLOYEE
SELECT COUNT(SALARY)
FROM EMPLOYEE
SELECT COUNT(*)
FROM EMPLOYEE
SELECT MAX(SALARY)
FROM EMPLOYEE
SELECT MIN(SALARY)
FROM EMPLOYEE
https://techquerypond.com
https://techquerypond.wordpress.com
https://twitter.com/techquerypond
Views: 475
Tech Query Pond
Oracle SQL Join Tutorials. Different types of joins and examples.
For Full Course Experience Please Go To
http://mentorsnet.org/course_preview?course_id=4
Full Course Experience Includes
1. Access to course videos and exercises
2. View & manage your progress/pace
3. In-class projects and code reviews
4. Personal guidance from your Mentors
Views: 102473
Oresoft LWC
NULL Value in Oracle Database | Oracle Tutorials for Beginners
NULL Value in Oracle Database
NULL Value in Oracle SQL
NULL Value in SQL
NULL Value in Oracle Database
Oracle Tutorials for Beginners
Oracle Tutorials for Beginners
Oracle PL/SQL Tutorials for Beginners
Oracle PL/SQL Tutorials for Beginners
Oracle PL/SQL Tutorials for Beginners
how to select null values in oracle
oracle compare null values in where clause
null=null in oracle
how to handle null in case statement in oracle
how to check null value in oracle stored procedure
oracle nvl
null value in oracle query
how to check empty column value in oracle
how to select null values in oracle
oracle is null vs = null
oracle nvl
oracle is not null
oracle decode
oracle isnull
oracle case when null
select null from table in oracle
oracle compare null values in where clause
oracle select null
how to check empty column value in oracle
oracle sql not null or empty
oracle is not null
how to handle null in case statement in oracle
oracle isnull
oracle nvl
Views: 590
Oracle PL/SQL World
RebellionRider.com presents the latest PL/SQL tutorial on FORALL statement with VALUES OF Bound clause in Oracle Database by Manish Sharma
------------------------------------------------------------------------
►►►LINKS◄◄◄
Blog: http://bit.ly/forall-4
learn what is a Database management system http://bit.ly/the-DBMS
Previous Tutorial
► FORALL with INDICES OF https://youtu.be/N2pv9wyTDqM
-------------------------------------------------------------------------
►Make sure you SUBSCRIBE and be the 1st one to see my videos!
-------------------------------------------------------------------------
►►►Find me on Social Media◄◄◄
Follow What I am up to as it happens on
https://twitter.com/rebellionrider
http://instagram.com/rebellionrider
https://plus.google.com/+Rebellionrider
http://in.linkedin.com/in/mannbhardwaj/
___Facebook Official Page of Manish Sharma___
https://www.facebook.com/TheRebellionRider/
___Facebook Official Page of RebellionRider.com___
https://www.facebook.com/RebellionRider.official/
You can also Email me at
for E-mail address please check the About section
Please please LIKE and SHARE my videos it makes me happy.
Thanks for liking, commenting, sharing and watching more of our videos
This is Manish from RebellionRider.com
♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 4157
Manish Sharma
In this second module in the series, Steven Feuerstein explores the code you need to write when you want your table function to return an array with multiple columns.
Best taken as part of the Oracle Dev Gym PL/SQL Table Functions class: https://devgym.oracle.com/pls/apex/dg/class/pl-sql-table-functions.html
========================================
Practically Perfect PL/SQL with Steven Feuerstein
Copyright © 2018 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
This video tutorial on Oracle database provides detailed information on various operators used in SELECT statements.
You can visit Oracle Database related videos here : https://www.youtube.com/watch?v=cDqlT7O8H0Q&list=PLRt-r4QiDOMfMmVU-8145pLcBxIdvAt8f&index=1
Website: http://guru4technoworld.wix.com/technoguru
Facebook : https://www.facebook.com/a2zoftech/
Blog: http://dronatechnoworld.blogspot.com
Views: 97
Sandip M
the group functions are sum,avg,max,min,count and distinct
syntax
sum: select sum(columnname) from tablename
Avg : select avg(columnname) from tablename
max :select max(columnname) from tablename
min :select min(columnname) from tablename
count:select count(columnname) from tablename
distinct:select distinct(columnname) from tablename
Views: 59
SB TUTORIALS
DURGASOFT is INDIA's No.1 Software Training Center offers
online training on various technologies like JAVA, .NET ,
ANDROID,HADOOP,TESTING TOOLS ,ADF,INFORMATICA,TABLEAU,IPHONE,OBIEE,ANJULAR JS, SAP...
courses from Hyderabad & Bangalore -India with Real Time Experts.
Mail us your requirements to [email protected]
so that our Supporting Team will arrange Demo Sessions.
Ph:Call +91-8885252627,+91-7207212428,+91-7207212427,+91-8096969696.
http://durgasoft.com
http://durgasoftonlinetraining.com
https://www.facebook.com/durgasoftware
http://durgajobs.com
https://www.facebook.com/durgajobsinfo......
Views: 15456
Durga Software Solutions
Oracle - SQL - Group By Clause
Watch more Videos at https://www.tutorialspoint.com/videotutorials/index.htm
Lecture By: Mr. Anadi Sharma, Tutorials Point India Private Limited.
Views: 3383
Tutorials Point (India) Pvt. Ltd.
Link for all dot net and sql server video tutorial playlists
http://www.youtube.com/user/kudvenkat/playlists
Link for slides, code samples and text version of the video
http://csharp-video-tutorials.blogspot.com/2014/05/part-2-sql-query-to-get-organization.html
To get the best out of this video, the following concepts need to be understood first. These are already discussed in SQL Server Tutorial.
1. Self-Join - http://www.youtube.com/watch?v=qnYSN_7qwgg
2. CTE - http://www.youtube.com/watch?v=ZXB5b-7HJHk
3. Recursive CTE - http://www.youtube.com/watch?v=GGoV0wTMCg0
Here is the problem definition:
1. Employees table contains the following columns
a) EmployeeId,
b) EmployeeName
c) ManagerId
2. If an EmployeeId is passed, the query should list down the entire organization hierarchy i.e who is the manager of the EmployeeId passed and who is managers manager and so on till full hierarchy is listed.
For example,
Scenario 1: If we pass David's EmployeeId to the query, then it should display the organization hierarchy starting from David.
Scenario 2: If we pass Lara's EmployeeId to the query, then it should display the organization hierarchy starting from Lara.
We will be Employees table for this demo. SQL to create and populate Employees table with test data
Create table Employees
(
EmployeeID int primary key identity,
EmployeeName nvarchar(50),
ManagerID int foreign key references Employees(EmployeeID)
)
GO
Insert into Employees values ('John', NULL)
Insert into Employees values ('Mark', NULL)
Insert into Employees values ('Steve', NULL)
Insert into Employees values ('Tom', NULL)
Insert into Employees values ('Lara', NULL)
Insert into Employees values ('Simon', NULL)
Insert into Employees values ('David', NULL)
Insert into Employees values ('Ben', NULL)
Insert into Employees values ('Stacy', NULL)
Insert into Employees values ('Sam', NULL)
GO
Update Employees Set ManagerID = 8 Where EmployeeName IN ('Mark', 'Steve', 'Lara')
Update Employees Set ManagerID = 2 Where EmployeeName IN ('Stacy', 'Simon')
Update Employees Set ManagerID = 3 Where EmployeeName IN ('Tom')
Update Employees Set ManagerID = 5 Where EmployeeName IN ('John', 'Sam')
Update Employees Set ManagerID = 4 Where EmployeeName IN ('David')
GO
Here is the SQL that does the job
Declare @ID int ;
Set @ID = 7;
WITH EmployeeCTE AS
(
Select EmployeeId, EmployeeName, ManagerID
From Employees
Where EmployeeId = @ID
UNION ALL
Select Employees.EmployeeId , Employees.EmployeeName, Employees.ManagerID
From Employees
JOIN EmployeeCTE
ON Employees.EmployeeId = EmployeeCTE.ManagerID
)
Select E1.EmployeeName, ISNULL(E2.EmployeeName, 'No Boss') as ManagerName
From EmployeeCTE E1
LEFT Join EmployeeCTE E2
ON E1.ManagerID = E2.EmployeeId
Views: 285125
kudvenkat
RebellionRider.com presents an introduction to Native Dynamic SQL (NDS) in Oracle Database by Manish Sharma. In this tutorial, you will learn what is a Static SQL and a Dynamic SQL. Also different ways of using Dynamic SQL in Oracle Database
------------------------------------------------------------------------
►►►LINKS◄◄◄
Blog: http://bit.ly/NDS-1
"What Is A Database Management Systems (DBMS)?" http://bit.ly/the-DBMS
Previous Tutorial
► Bind Variables: https://youtu.be/TJtjo3FTBtE
►Bulk Data Processing Playlist
https://www.youtube.com/playlist?list=PLL_LQvNX4xKwLcCuxb7-e8BVFxXFHCUPo
-------------------------------------------------------------------------
►Make sure you SUBSCRIBE and be the 1st one to see my videos!
-------------------------------------------------------------------------
►►►Find me on Social Media◄◄◄
Follow What I am up to as it happens on
https://twitter.com/rebellionrider
http://instagram.com/rebellionrider
https://plus.google.com/+Rebellionrider
http://in.linkedin.com/in/mannbhardwaj/
___Facebook Official Page of Manish Sharma___
https://www.facebook.com/TheRebellionRider/
___Facebook Official Page of RebellionRider.com___
https://www.facebook.com/RebellionRider.official/
You can also Email me at
for E-mail address please check the About section
Please please LIKE and SHARE my videos it makes me happy.
Thanks for liking, commenting, sharing and watching more of our videos
This is Manish from RebellionRider.com
♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 6401
Manish Sharma
Get your first month on the Joes 2 Pros Academy for just $1 with code YOUTUBE1. Visit http://www.joes2pros.com
Offer expires July 1, 2015
From the newly released 2 Disc DVD set (SQL Queries Joes 2 Pros Vol2) this video shows how to join 3 tables in 1 query.
Views: 255083
Joes2Pros SQL Trainings