Home
Search results “Index asc desc oracle”
B*Tree Index Types (Indexes in Oracle-2)
 
33:58
This video will cover different types of B-tree indexes: Descending index,Reverse key index,Key Compressed Index B-tree cluster index,Index Organized Table(IOT):
Views: 15479 Anindya Das
SEQUENCES IN ORACLE SQL WITH EXAMPLES (asc, desc, cycle, nocycle, cache, nocache)
 
24:39
This video tutorial is to understand the working of sequences in oracle SQL. The video demonstrations explain all the attributes of a create sequence statement such as start with, increment by, maxvalue, nomaxvalue, minvalue, nominvalue, cycle, nocycle, cache, nocache, order, and noorder. All the parameters are explained with appropriate examples so that the user can understand them clearly. For more detail refer to the link: http://plsqlnsql.blogspot.com/2017/01/sequences.html
Views: 2247 Kishan Mashru
DESCRIBE or DESC Keyword in Oracle | Oracle Tutorials for Beginners
 
07:09
DESCRIBE or DESC Keyword in Oracle | Oracle Tutorials for Beginners DESCRIBE Keyword in Oracle DESC Keyword in Oracle DESCRIBE Keyword in Oracle SQL DESC Keyword in Oracle SQL DESCRIBE Keyword in SQL DESC Keyword in SQL Oracle Tutorials for Beginners Oracle SQL for Beginners Oracle Database for Beginners Oracle SQL Tutorials for Biners Oracle Database tutorials for Beginners oracle describe table structure desc table in sql server descending order in oracle how to see table structure in oracle sql developer desc command in mysql pl sql describe table desc command in sql example describe table in sql query how to see table structure in oracle sql developer desc table in sql server sql query to view table structure in oracle oracle describe table invalid sql statement describe table in sql query oracle desc table order by column name describe not working in oracle oracle show tables how to see table structure in oracle sql developer how to get table structure in oracle 11g sql query to list all tables in a database describe table in oracle sql developer sql query to view table structure in sql server oracle get list of tables in schema oracle show tables describe table structure in sql server
Views: 674 Oracle PL/SQL World
Oracle - Managing Views, Sequences, Synonyms, and Index
 
03:18
Oracle - Managing Views, Sequences, Synonyms, and Index
Views: 270 Si Ruy
Oracle - SQL - Sorting Data
 
07:05
Oracle - SQL - Sorting Data Watch more Videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Anadi Sharma, Tutorials Point India Private Limited.
Creating SQL table and sorting accordance to ascending & descending using ORACLE 10g. hd
 
10:19
How to create a table and sorting it according to ascending & descending order. Program used is ORACLE® 10g. 🏁Watch in 720p or 480p for better view. ➡MrSuicideSheep-https://www.youtube.com/channel/UC5nc_ZtjKW1htCVZVRxlQAQ http://facebook.com/synchronicemusic http://soundcloud.com/synchronice ➡NCS-https://www.youtube.com/channel/UC_aEa8K-EOJ3D6gOs7HcyNg ➡ Unknown Brain- http://soundcloud.com/UnknownBrain ➡Chris Linton-http://soundcloud.com/chris-linton-1 ➡MrRevillz - https://www.youtube.com/channel/UCd3TI79UTgYvVEq5lTnJ4uQ https://soundcloud.com/mrrevillz ➡MAX - https://www.youtube.com/user/MaxSchneider1 https://itunes.apple.com/us/album/the-say-max-ep/id863989577 http://open.spotify.com/artist/1bqxdqvUtPWZri43cKHac8
Views: 293 Ankur Debbarma
Oracle SQL Tutorial : How to create Id with AUTO INCREMENT in Oracle PL SQL
 
08:43
Oracle SQL Tutorial Oracle tutorial: How to create Id with AUTO INCREMENT in Oracle oracle tutorial for beginners sequence in oracle identity key in sql In this Oracle tutorial , we can create an auto increment field using ‘sequence’ object that can be assigned as primary keys. Using Oracle ‘sequence’ object, you can generate new values for a column. An Oracle sequence is an object like a table or a stored procedure. Examples CREATE SEQUENCE SYSTEM.MYSEQ START WITH 1 MAXVALUE 999999999999999999999999999 MINVALUE 1 NOCYCLE CACHE 20 NOORDER; CREATE OR REPLACE TRIGGER TR_CITY BEFORE INSERT ON CITY FOR EACH ROW BEGIN SELECT LPAD(LTRIM(RTRIM(TO_CHAR(myseq.NEXTVAL))),10,'0') INTO :NEW.id FROM DUAL; END; / Subscribe on youtube: https://www.youtube.com/channel/UCpiyAesWNYOXSz5GPq8lbkA For more tutorial please visit #techquerypond https://techquerypond.wordpress.com https://twitter.com/techquerypond identity column
Views: 10105 Tech Query Pond
T-SQL - Sorting Data
 
06:16
T-SQL - Sorting Data Watch more Videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Anadi Sharma, Tutorials Point India Private Limited
Oracle Database 11g - SQL Bangla Tutorial |Ch12_2- How to create View, Synonyms, Sequence, Index
 
38:48
See the Description for required source code and links SQL Tutorial Source Code of Oracle Database 11g Training: https://drive.google.com/open?id=0Bz0MNaVyRm3ldDZkT3ZfWFlOVDQ Chapter-12: Creating Other Schema Objects. In this video tutorial, you will know how to create, alter, drop schema objects such as View, Synonyms, Sequence, Index. The View, Synonyms, Sequence, Index are important object for database management. This is special computer training designing online courses on Database Management System. It is fully bangla tutorial. It will be helpful for every database programmer and administrator. Subscribe this channel to watch my all tutorials on PHP, MYSQL, Javascript, Linux, Networking, Access Programming & Microsoft Office, C++, HTML, CSS. Oracle Database PDF eBook Link : https://drive.google.com/open?id=0Bz0MNaVyRm3lUWpGbXMyX3lRUTg All Source Codes & Required Documents together are found in the link: https://drive.google.com/open?id=0Bz0MNaVyRm3lMjFVcXhzMjNvWDA All SQL & PL SQL Tutorials are found in the link: https://www.youtube.com/playlist?list=PLUYY2piVmub7QL0ET2_eg4D_SV3AOsPHT Oracle DBA Tutorials: https://www.youtube.com/playlist?list=PLUYY2piVmub6bRM0ScQMNnbyH66yrh1cf Channel Link: http://www.youtube.com/channel/UCT_fWLNX67sDH3W3FZ1wxLg?sub_confirmation=1 Required Document Link : https://drive.google.com/open?id=0Bz0MNaVyRm3lWDB0V1JOOE93eUE FB Page: https://www.facebook.com/BanglaTutorial24 FB Group: https://www.facebook.com/groups/banglatutorial24/ In the tutorial, I have tried to describe about how to create and manage View, Synonyms, Sequence, Index in oracle database. [SQL TUTORIAL, DATABASE MANAGEMENT SYSTEM, BANGLA TUTORIAL, TRAINING, DATABASE, ORACLE DATABASE]
Views: 387 MD. SHARIFUL ALAM
Sorting in Descending Order in SQL Using Order By Desc Clause - SQL LESSON 29
 
04:17
Sorting in Descending Order in SQL Using Order By Desc Clause - SQL LESSON 29
Views: 16946 HandsonERP
Oracle Character Manipulation | REVERSE | LENGTH Functions | Oracle Tutorial for Beginners
 
04:21
Oracle Character Manipulation | REVERSE | LENGTH Functions | Oracle Tutorial for Beginners Oracle Tutorial for Beginners Oracle Tutorial for Beginners Oracle LENGTH Function Oracle REVERSE Functions Oracle SQL Tutorials for Beginners Oracle tutorials Oracle Character Manipulation Oracle Character Manipulation Character Manipulation Oracle 12c Oracle 18c Oracle In built Functions Oracle LENGTH() Oracle REVERSE() reversing string in oracle without using reverse function query to reverse a string in oracle how to reverse a string in oracle sql without using reverse function substr oracle reverse string using substr in oracle instr in oracle reverse function in oracle how to reverse a string in sql without using reverse function
Views: 265 Oracle PL/SQL World
Cara Membuat Table Di ORACLE SQL DEVELOPER PART 2
 
10:04
Create Table Di ORACLE SQL DEVELIPER Add Column Di ORACLE SQL DEVELIPER Alter Table Di ORACLE SQL DEVELIPER Modify Column Di ORACLE SQL DEVELIPER Rename Table Di ORACLE SQL DEVELIPER Rename Column Di ORACLE SQL DEVELIPER Drop Column Di ORACLE SQL DEVELIPER Drop Table Di ORACLE SQL DEVELIPER ----------------------------------------------------------------------------------------------------------------------------------------------- CREATE TABLE MAHASISWA ( NIM NUMBER(2) NOT NULL, NAMA VARCHAR(20) NOT NULL, CONSTRAINT MAHASISWA_PK PRIMARY KEY (NIM) ENABLE ); ----------------------------------------------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------------------------------------------------------- ALTER TABLE MAHASISWA ADD ( ALAMAT VARCHAR(45) NOT NULL, BERAT NUMBER(2) NOT NULL ); ----------------------------------------------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------------------------------------------------------- DESC MAHASISWA; ----------------------------------------------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------------------------------------------------------- ALTER TABLE MAHASISWA MODIFY BERAT VARCHAR(2); ----------------------------------------------------------------------------------------------------------------------------------------------- ALTER TABLE MAHASISWA RENAME COLUMN BERAT TO UMUR; ----------------------------------------------------------------------------------------------------------------------------------------------- ALTER TABLE MAHASISWA DROP COLUMN UMUR; ----------------------------------------------------------------------------------------------------------------------------------------------- ALTER TABLE MAHASISWA RENAME TO STUDENT; ----------------------------------------------------------------------------------------------------------------------------------------------- DESC STUDENT; ----------------------------------------------------------------------------------------------------------------------------------------------- DROP TABLE STUDENT; -----------------------------------------------------------------------------------------------------------------------------------------------
Views: 171 Dwiki Olajuwon
Oracle Sequences and Synonyms
 
21:11
DURGASOFT is INDIA's No.1 Software Training Center offers online training on various technologies like JAVA, .NET , ANDROID,HADOOP,TESTING TOOLS , ADF, INFORMATICA, 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......
Oracle Tutorial || Oracle|Sql Other DB Objets Synonym by basha
 
50:06
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......
PL/SQL Tutorial 3 (Oracle): Using an Alias
 
01:44
PL/SQL Tutorial 3 (Oracle): Using an Alias In this tutorial I show you how to use an Alias in PL/SQL. Source Code: https://github.com/mitchtabian/SQL-tutorials Subscribe to my Blog and YouTube channel to get notifications when new FREE coding tutorials are posted! Blog: http://www.codingwithmitch.com/
Views: 222 CodingWithMitch
8. Describe Table in SQL (Hindi)
 
04:22
Please Subscribe Channel Like, Share and Comment Visit : www.geekyshows.com
Views: 48782 Geeky Shows
jQuery datatables stored procedure for paging sorting and searching
 
14:36
Link for all dot net and sql server video tutorial playlists https://www.youtube.com/user/kudvenkat/playlists?sort=dd&view=1 Link for slides, code samples and text version of the video http://csharp-video-tutorials.blogspot.com/2015/08/jquery-datatables-stored-procedure-for.html In this video we will discuss implementing a stored procedure that can perform paging sorting and searching. In our upcoming videos we will discuss writing a generic handler that calls this stored procedure. The generic handler will convert the data to JSON format. The JSON formatted data can then be consumed by the jQuery datatables plugin. All the processing, that is, paging, sorting and searching is done on the server side. If the dataset is small you can retrieve all the data at once and all the processing (i.e paging, searching, sorting) can be done on the client-side. We discussed this in Part 106 for jQuery tutorial. However, if the dataset is large (i.e if you have millions of records), loading all data at once is not the best thing to do from a performance standpoint. With large dataset, we only want to load the correct set of rows (sorted, paged and filtered data ) that want to display on the page. So all the processing ((i.e paging, searching and sorting) should be done by the server. So in this and our upcoming videos we will discuss performing server side processing. SQL Script to create the table and populate it with test data Create table tblEmployees ( ID int primary key identity, FirstName nvarchar(50), LastName nvarchar(50), Gender nvarchar(20), JobTitle nvarchar(20) ) Go Insert into tblEmployees values('Mark', 'Hastings','Male','Developer') Insert into tblEmployees values('Maria', 'Nicholas','Female','Developer') Insert into tblEmployees values('Robert', 'Stephenson','Male','Sr. Developer') Insert into tblEmployees values('Mary', 'Quant','Female','Sr. Developer') Insert into tblEmployees values('John', 'Stenson','Male','Sr. Developer') Insert into tblEmployees values('Gilbert', 'Sullivan','Male','Developer') Insert into tblEmployees values('Rob', 'Gerald','Male','Sr. Developer') Insert into tblEmployees values('Ron', 'Simpson','Male','Developer') Insert into tblEmployees values('Sara', 'Solomon','Female','Sr. Developer') Insert into tblEmployees values('Rad', 'Wicht','Male','Sr. Developer') Insert into tblEmployees values('Julian', 'John','Male','Developer') Insert into tblEmployees values('James', 'Bynes','Male','Sr. Developer') Insert into tblEmployees values('Mary', 'Ward','Female','Developer') Insert into tblEmployees values('Michael', 'Niron','Male','Sr. Developer') SQL Server stored procedure paging sorting and searching create proc spGetEmployees @DisplayLength int, @DisplayStart int, @SortCol int, @SortDir nvarchar(10), @Search nvarchar(255) = NULL as begin Declare @FirstRec int, @LastRec int Set @FirstRec = @DisplayStart; Set @LastRec = @DisplayStart + @DisplayLength; With CTE_Employees as ( Select ROW_NUMBER() over (order by case when (@SortCol = 0 and @SortDir='asc') then Id end asc, case when (@SortCol = 0 and @SortDir='desc') then Id end desc, case when (@SortCol = 1 and @SortDir='asc') then FirstName end asc, case when (@SortCol = 1 and @SortDir='desc') then FirstName end desc, case when (@SortCol = 2 and @SortDir='asc') then LastName end asc, case when (@SortCol = 2 and @SortDir='desc') then LastName end desc, case when (@SortCol = 3 and @SortDir='asc') then Gender end asc, case when (@SortCol = 3 and @SortDir='desc') then Gender end desc, case when (@SortCol = 4 and @SortDir='asc') then JobTitle end asc, case when (@SortCol = 4 and @SortDir='desc') then JobTitle end desc ) as RowNum, COUNT(*) over() as TotalCount, Id, FirstName, LastName, Gender, JobTitle from tblEmployees where (@Search IS NULL Or Id like '%' + @Search + '%' Or FirstName like '%' + @Search + '%' Or LastName like '%' + @Search + '%' Or Gender like '%' + @Search + '%' Or JobTitle like '%' + @Search + '%') ) Select * from CTE_Employees where RowNum ] @FirstRec and RowNum [= @LastRec end Finally test the stored procedure
Views: 41304 kudvenkat
Select SQL Server Relation with Order By Column Ascending Descending Command Line Management Studio
 
02:27
Select SQL Server Relation with Order By Column Ascending Descending Command Line Management Studio
Views: 24 Saidah Faulia
Synonyms in Oracle PL SQL
 
03:48
Synonyms in Oracle #techquerypond sql synonyms oracle synonym what is Synonyms in Oracle ? 1)A synonym is an alternative name tO objects. 2)Objects like tables, views, sequences, stored procedures. 3)Generally we use to granting or revoking the access. 4)It means that the synonym is a public synonym and is accessible to all users. 5)Please note user must first have the appropriate privileges to access synonym. To get more information watch the above video. For example: CREATE PUBLIC SYNONYM EMP FOR EMPLOYEE; SELECT * FROM EMP; DROP PUBLIC SYNONYM EMP; https://techquerypond.wordpress.com https://techquerypond.com https://twitter.com/techquerypond
Views: 1425 Tech Query Pond
Oracle SQL Developer Tutorial For Beginners  94   Alias for Columns
 
02:44
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: 632 Sam Dhanasekaran
Sql Tutorial - How to create SEQUENCE in Oracle
 
13:44
Hi guys today we understanding about sequence in SQL language how to create and modify sequence and how these are beneficial to speedup the process of insertion.Oracle database #SqlTutorial Unbeatable,Unbreakable Platform..
Views: 4983 Oracle World
How to install Oracle SQl Developer And How to Connect Your Database Sql Developer[Hindi/Urdu].
 
04:46
Hi Friends !!!! In This Video We will Show The How to install SQL Developer And How to Connect Your Database SQL Developer. SQL Developer Download Link : http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html Related video Links : How to Install Java Netbeans IDE in Windows 7, 8.1, 10 [Hindi/Urdu]: https://youtu.be/jOYMNognZXM How To Install Java On Window 10, 8.1, 7 64 bit Operating System [Hindi/Urdu] : https://youtu.be/y2-g09nY33A How to install Windows 7, 8.1,10 from a flash drive or Pandrive . [Hindi/Urdu] : https://youtu.be/s4kNcirxWrc How to Make Bootable Your Pandrive [Hindi/Urdu] : https://youtu.be/BPx_Ua_aCfY How to install Oracle 11G XE On Windows 10, 8.1, 7 Operating System in [Hindi/Urdu] : https://youtu.be/-2k4QCIpIOs How to Create Table Oracle Datbase Using Sqlplus [Hindi/Urdu] : https://youtu.be/EHnAebRP6Yw How To Insert Table Oracle Database Using Sqlplus [Hindi/Urdu]: https://youtu.be/Fu0tlCml8F8 How TO DELETE ROW, MODIFY, UPDATE COLUMN, DROP TABLE in Oracle SQL Using Cmd [Hindi/Urdu]: https://youtu.be/prz9Pr0PFEg How to recover format or delete Pandrive, Sdcard, Memory Card Or Harddisk Data [Hindi/Urdu] : https://youtu.be/0GGDHVTxDh0 How to install Oracle SQl Developer And How to Connect Your Database Sql Developer[Hindi/Urdu] : https://youtu.be/608nx3mT10c How to use SQL Distinct Keyword in Cmd Or Oracle SQL Developer [Hindi/Urdu] : https://youtu.be/ofLLZ9-EG_E How to use SQL AND Or OR operator [Hindi/Urdu] : https://youtu.be/zzqDp7U3rC8 How To Use SQL Where Operation using CMD [Hindi/Urdu] : https://youtu.be/EHmL0Wa14UY How To Use SQL ASC and DESC Operation using cmd [Hindi/Urdu] : https://youtu.be/UI0hat_RMX0 Thank You For Any Query Email Add : [email protected] Facebook Page link : https://www.facebook.com/Technical-Education-4-You-144220269545756/?ref=nf&hc_ref=ART3p2EX_iIdZHm96Uz36P99q7xfycGfo54RJafY-f0O4n1bdvWU_5xGHpPrOpLepi4
Indexes Table Filter SQL Command window - English
 
10:34
Indexes, Table Filter, SQL Command window
SQL ORDER BY With Multiple Columns
 
03:50
Jamie King of Neumont University demonstrating ORDER BY in regards to multiple columns.
Views: 7717 Jamie King
create sequence in oracle in HINDI | Sequences in Oracle in HINDI
 
06:00
sql tutorial | create sequence in oracle | Sequences in Oracle in HINDI To create sequence in oracle, we have to use create sequence statement of oracle. This video of create sequence in oracle, will give you hands on practice about sequences in oracle. We have used screen capture option for making this video of sequences in oracle. The main objective of this video create sequence in oracle is to give the users a real hands on practice to use sequences in oracle. The language of the video is hindi, if you wish to watch this video in english, please suggest in comment section of this video. Oracle uses the concept of SEQUENCE to create numerical primary key values as we add rows of data into a table. Whereas numerical primary key population for MySQL and SQL Server is tied to individual tables, in Oracle the SEQUENCE construct is created separately and is not tied to an individual table. Hope this video of sequences in oracle, is helpful for you. Music www.bensound.com facebook page www.facebook.com/learningseveryday -~-~~-~~~-~~-~- Please watch: "what is flow chart | symbols of flowchart explained in hindi" https://www.youtube.com/watch?v=k2I8gp1NGGU -~-~~-~~~-~~-~-
Views: 330 Learning Everyday
Describe keyword in Oracle database Hindi/Urdu
 
06:59
In this video we Learn about "Describe" keyword in oracle database. Describe keyword is used to show the structure of table Previous Video Link:https://www.youtube.com/watch?v=uYaBpS7Tl2U Like,Share,Comment and Subscribe My Channel
Views: 226 Oracle With Asad
Maintenance Plan for Update Statistics Task in SQL Server
 
06:47
Click here to Subscribe to IT PORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg If your queries are executing slower, then it is time to update the statistics. It is recommended to update your statistics after you insert a larger amount of data into ascending or descending key columns because in such cases the statistics histogram might not have any information about the newly inserted values. This task is used to update SQL Server information about the data in the tables and indexes. This task resamples the distribution statistics of each index created on user tables in the database. The distribution statistics are used by SQL Server to optimize navigation through tables during the processing of Transact-SQL statements. To build the distribution statistics automatically, SQL Server periodically samples the data in the corresponding table for each index.This size of the sample is based on the number of rows in the table and the frequency of data modification. Use this option to perform an additional sampling using the specified percentage of data in the tables. SQL Server uses this information to create better query plans. This task executes the UPDATE STATISTICS statement.
Views: 1015 IT Port
Wednesday October 4: Room 2011: Oracle Code Sessions
 
10:26:05
https://www.oracle.com/javaone/index.html 08:30: Ask the OpenJ9 Architects 09:30: Make Your CPU Cores Sweat with Parallel Streams 10:45: Java at Speed: Getting the Most Out of Modern Hardware 12:45: Lambda Chops: Recipes for Simpler, More Expressive Code 01:45: Asynchronous API with CompletableFuture: Performance Tips and Tricks 02:45: Flow and the Future of Reactive Systems on the JVM 04:30: The Good Cop/Bad Cop Guide to Java 9 05:30: It’s Java, but Not As We Know It
Views: 827 Java
Sequences In Oracle
 
02:46
Sequences In Oracle
Oracle Training Bangladesh : SQL Sorting data
 
06:08
Oracle Training in Bangladesh Oracle Developer and Database Training in Bangladesh Oracle Training at Dev Net IT Oracle forms Training Oracle SQL Training Oracle PL SQL Training Oracle BI Training Oracle Web Logic Training Oracle Reports Training for details http://www.devnet-it.com
Views: 96 devnetbd devnetit
6-Oracle Tutorial in SQL (Bangla) - Subqueries
 
12:06
TrainerBD.com Offers the most affordable (BDT. 15,000/-) Oracle Training in Mirpur, Dhaka, Bangladesh. Learn Oracle, Be an Oracle Developer and/or Database Administrator. Click http://goo.gl/OYI9lF to learn Oracle.
Views: 1621 TrainerBD .com
Sequence object in SQL Server 2012
 
12:22
create sequence in sql server In this video we will discuss sequence object in SQL Server. Sequence object Introduced in SQL Server 2012 Generates sequence of numeric values in an ascending or descending order Text version of the video http://csharp-video-tutorials.blogspot.com/2015/10/sequence-object-in-sql-server-2012.html Slides http://csharp-video-tutorials.blogspot.com/2015/10/sequence-object-in-sql-server-2012_26.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists Creating the Incrementing Sequence : The following code create a Sequence object that starts with 1 and increments by 1 CREATE SEQUENCE [dbo].[SequenceObject] AS INT START WITH 1 INCREMENT BY 1 Generating the Next Sequence Value : Now we have a sequence object created. To generate the sequence value use NEXT VALUE FOR clause SELECT NEXT VALUE FOR [dbo].[SequenceObject] Output : 1 Every time you execute the above query the sequence value will be incremented by 1. I executed the above query 5 times, so the current sequence value is 5. Retrieving the current sequence value : If you want to see what the current Sequence value before generating the next, use sys.sequences SELECT * FROM sys.sequences WHERE name = 'SequenceObject' Alter the Sequence object to reset the sequence value : ALTER SEQUENCE [SequenceObject] RESTART WITH 1 Select the next sequence value to make sure the value starts from 1 SELECT NEXT VALUE FOR [dbo].[SequenceObject] Using sequence value in an INSERT query : CREATE TABLE Employees ( Id INT PRIMARY KEY, Name NVARCHAR(50), Gender NVARCHAR(10) ) -- Generate and insert Sequence values INSERT INTO Employees VALUES (NEXT VALUE for [dbo].[SequenceObject], 'Ben', 'Male') INSERT INTO Employees VALUES (NEXT VALUE for [dbo].[SequenceObject], 'Sara', 'Female') -- Select the data from the table SELECT * FROM Employees Creating the decrementing Sequence : The following code create a Sequence object that starts with 100 and decrements by 1 CREATE SEQUENCE [dbo].[SequenceObject] AS INT START WITH 100 INCREMENT BY -1 Specifying MIN and MAX values for the sequence : Use the MINVALUE and MAXVALUE arguments to specify the MIN and MAX values respectively. Step 1 : Create the Sequence object CREATE SEQUENCE [dbo].[SequenceObject] START WITH 100 INCREMENT BY 10 MINVALUE 100 MAXVALUE 150 Step 2 : Retrieve the next sequence value. The sequence value starts at 100. Every time we call NEXT VALUE, the value will be incremented by 10. SELECT NEXT VALUE FOR [dbo].[SequenceObject] If you call NEXT VALUE, when the value reaches 150 (MAXVALUE), you will get the following error The sequence object 'SequenceObject' has reached its minimum or maximum value. Restart the sequence object to allow new values to be generated. Recycling Sequence values : When the sequence object has reached it's maximum value, and if you want to restart from the minimum value, set CYCLE option ALTER SEQUENCE [dbo].[SequenceObject] INCREMENT BY 10 MINVALUE 100 MAXVALUE 150 CYCLE At this point, whe the sequence object has reached it's maximum value, and if you ask for the NEXT VALUE, sequence object starts from the minimum value again which in this case is 100. To improve performance, the Sequence object values can be cached using the CACHE option. When the values are cached they are read from the memory instead of from the disk, which improves the performance. When the cache option is specified you can also specify the size of th cache , that is the number of values to cache. The following example, creates the sequence object with 10 values cached. When the 11th value is requested, the next 10 values will be cached again. CREATE SEQUENCE [dbo].[SequenceObject] START WITH 1 INCREMENT BY 1 CACHE 10 Using SQL Server Graphical User Interface (GUI) to create the sequence object : 1. Expand the database folder 2. Expand Programmability folder 3. Right click on Sequences folder 4. Select New Sequence Next video : Difference between SEQUENCE and IDENTITY in SQL Server
Views: 36367 kudvenkat
sequence in oracle
 
05:30
in this tutorial i teach sequence in oracle
Sequence in SQL Server
 
08:06
Click here to Subscribe to IT PORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg A sequence is a user-defined schema bound object that generates a sequence of numeric values according to the specification with which the sequence was created. The sequence of numeric values is generated in an ascending or descending order at a defined interval and can be configured to restart (cycle) when exhausted. Sequences, unlike identity columns, are not associated with specific tables. Applications refer to a sequence object to retrieve its next value. The relationship between sequences and tables is controlled by the application. User applications can reference a sequence object and coordinate the values across multiple rows and tables.
Views: 123 IT Port
Part 1   How to find nth highest salary in sql
 
11:45
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-1-how-to-find-nth-highest-salary_17.html This is a very common SQL Server Interview Question. There are several ways of finding the nth highest salary. By the end of this video, we will be able to answer all the following questions as well. How to find nth highest salary in SQL Server using a Sub-Query How to find nth highest salary in SQL Server using a CTE How to find the 2nd, 3rd or 15th highest salary Let's use the following Employees table for this demo Use the following script to create Employees table Create table Employees ( ID int primary key identity, FirstName nvarchar(50), LastName nvarchar(50), Gender nvarchar(50), Salary int ) GO Insert into Employees values ('Ben', 'Hoskins', 'Male', 70000) Insert into Employees values ('Mark', 'Hastings', 'Male', 60000) Insert into Employees values ('Steve', 'Pound', 'Male', 45000) Insert into Employees values ('Ben', 'Hoskins', 'Male', 70000) Insert into Employees values ('Philip', 'Hastings', 'Male', 45000) Insert into Employees values ('Mary', 'Lambeth', 'Female', 30000) Insert into Employees values ('Valarie', 'Vikings', 'Female', 35000) Insert into Employees values ('John', 'Stanmore', 'Male', 80000) GO To find the highest salary it is straight forward. We can simply use the Max() function as shown below. Select Max(Salary) from Employees To get the second highest salary use a sub query along with Max() function as shown below. Select Max(Salary) from Employees where Salary [ (Select Max(Salary) from Employees) To find nth highest salary using Sub-Query SELECT TOP 1 SALARY FROM ( SELECT DISTINCT TOP N SALARY FROM EMPLOYEES ORDER BY SALARY DESC ) RESULT ORDER BY SALARY To find nth highest salary using CTE WITH RESULT AS ( SELECT SALARY, DENSE_RANK() OVER (ORDER BY SALARY DESC) AS DENSERANK FROM EMPLOYEES ) SELECT TOP 1 SALARY FROM RESULT WHERE DENSERANK = N To find 2nd highest salary we can use any of the above queries. Simple replace N with 2. Similarly, to find 3rd highest salary, simple replace N with 3. Please Note: On many of the websites, you may have seen that, the following query can be used to get the nth highest salary. The below query will only work if there are no duplicates. WITH RESULT AS ( SELECT SALARY, ROW_NUMBER() OVER (ORDER BY SALARY DESC) AS ROWNUMBER FROM EMPLOYEES ) SELECT SALARY FROM RESULT WHERE ROWNUMBER = 3
Views: 940737 kudvenkat
Базы данных для начинающих. Внутренние индексы SQL таблицы. Таблицы WITHOUT ROWID в SQLite.
 
15:32
Помощь проекту: WMR: R288272666982 WMZ: Z293550531456 Яндекс.Деньги: 410011531129223 Рубрика SQLite на сайте: http://zametkinapolyah.ru/zametki-o-mysql/sqlite/ Текстовая версия: http://zametkinapolyah.ru/zametki-o-mysql/chast-11-7-indeksy-v-bazax-dannyx-sqlite-indeksaciya-tablic-v-sqlite3-algoritm-b-dereva-v-bazax-dannyx.html Паблик блога в ВК: https://vk.com/zametkinapolyah Тематическая группа в ВК: https://vk.com/zametki_bd -- Столбец ROWID или внутренние индексы таблицы в базе данных SQLite -- У каждой таблицы базы данных SQLite по умолчанию есть внутренний индекс, который называет ROWID. Иногда этот индекс совпадает с первичным ключом таблицы PRIMARY KEY, иногда не совпадает, но ROWID есть у каждой таблицы. Если говорить просто и понятно, то ROWID – это дополнительный столбец, который есть у любой таблицы SQLiteи является индексом для данной таблицы. -- Помимо того, что ROWID – это индекс, это еще один способ поддержание целостности данных. Давайте разберемся с индексом ROWID в базах данных SQLite. ROWID–это 64-разрядное число, которое однозначно идентифицирую любую строку в базе данных SQLite. -- Создадим таблицу без индексов и наполним ее данными CREATE TABLE table1(a, b ,c ,d); INSERT INTO table1 (a, b, c , d) VALUES (1, 2, 3, 4); INSERT INTO table1 (a, b, c , d) VALUES (1, 2, 3, 4); INSERT INTO table1 (a, b, c , d) VALUES (1, 2, 3, 4); INSERT INTO table1 (a, b, c , d) VALUES (1, 2, 3, 4); -- посмотрим содержимое таблицы SELECT*FROM table1; -- SQLite не показывает столбец ROWID, если не обращаться к нему по имени, давайте изменим наш запрос SELECT SELECT rowid, a, b, c, d FROM table1; SELECT rowid, a FROM table1; -- Чтобы первичный ключ совпадал с ROWID, нужно создать таблицу следующим образом CREATE TABLE table1(x INTEGER PRIMARY KEY ASC, y, z); CREATE TABLE table2(x INTEGER, y, z, PRIMARY KEY(x ASC)); CREATE TABLE table3(x INTEGER, y, z, PRIMARY KEY(x DESC)); -- Обратите внимание: если столбец PRIMARY KEY объявить как-нибудь по-другому, то значения PRIMARY KEY и ROWID совпадать не будут. -- Таблицы WITHOUT ROWID в базах данных SQLite, таблицы без внутренних индексов -- В SQLite можно создавать таблицы без столбца ROWID, то есть без внутреннего индекса. Такой подход несет незначительные плюсы: иногда это ускоряет выборку данных из базы данных и немного уменьшает объем базы данных. Если вы решили создать таблицу без ROWID в SQLite, то вам необходимо сделать две вещи: во-первых, у таблицы должен быть обязательно первичный ключ, во-вторых, вам необходимо использовать ключевую фразу WITHOUT ROWID. CREATE TABLE IF NOT EXISTS wordcount( word TEXT PRIMARY KEY, cnt INTEGER ) WITHOUT ROWID; INSERT INTO wordcount (word, cnt) VALUES ('word1', 2); INSERT INTO wordcount (word, cnt) VALUES ('word2', 5); INSERT INTO wordcount (word, cnt) VALUES (NULL, 5); CREATE TABLE IF NOT EXISTS wordcount1( word TEXT PRIMARY KEY, cnt INTEGER ); INSERT INTO wordcount1 (word, cnt) VALUES (NULL, 5); -- Теперь у таблицы не будет столбца ROWID. Еще одной особенностью таблиц WITHOUT ROWID является то, что ограничение уровня столбца AUTOINCREMENT работать не будет. Первичный ключ таблицы WITHOUT ROWID ни при каких обстоятельствах не может иметь значение NULL, если вы попробуете добавить NULL в столбец PRIMARY KEY таблицы WITHOUT ROWID, то SQLite выдаст ошибку. Из-за особенностей работы таблиц WITHOUT ROWID, разработчики SQLiteрекомендуют использовать такие таблицы в тех случаях, когда: Вы используете составные первичные ключи или когда первичный ключ не является целым числом, а имеет другой тип данных. Если вам нужно повысить скорость работы таблицы с первичным ключом INTEGER, создавайте таблицу без внутреннего индекса, этим вы ускорите выборку и уменьшите объем базы данных. Если таблицы имеет индекс ROWID и индекс в виде INTEGER PRIMARY KEY, то SQLIte делает перебор двумя циклами: первый цикл идет по столбцу ROWID, второй цикл идет по столбцу INTEGER PRIMARY KEY, хотя значения этих столбцов совпадают. Если в таблицах хранится небольшое количество строк, то таблицы без индекса (WITHOUT ROWID) будут работать несколько быстрее, чем со столбцом ROWID. Если вы проектируете базу данных и хотите ее оптимизировать, то вам не стоит задумываться о том, какие таблицы использовать: ROWID или WITHOUT ROWID, на этапе разработки и проектирования. Тесты лучше всего проводить после того, как база данных будет спроектирована и реализована. Так как никаких отличий между таблицами с ROWID и без нет, за исключением тех, что описаны выше, нет.
Select Top N Query
 
02:22
http://zerotoprotraining.com Select Top N Query Category: Oracle SQL Tags: Select Top N Query
Views: 2086 HandsonERP
SQL for Beginners (Part 3) : The WHERE Clause
 
03:23
The third part of a mini-series of videos showing the basics of SQL. In this episode, we take a look at the type of things you are likely to see in the WHERE clause of queries. For more information see: https://oracle-base.com/articles/misc/sql-for-beginners-the-where-clause Website: https://oracle-base.com Blog: https://oracle-base.com/blog Twitter: https://twitter.com/oraclebase Cameo by Rita Nunez : Blog: http://dbaoraclesoporte.blogspot.com Twitter: https://twitter.com/ritan2000 Cameo appearances are for fun, not an endorsement of the content of this video.
Views: 1151 ORACLE-BASE.com
SQL Query Interview Questions
 
19:06
Video talks about SQL Query Interview Questions SQL Interview Questions SQL Interview Questions and answers top sql questions SQL real time scenario based interview questions Top SQL Interview Questions and answers Step by step SQL Training videos SQL Tutorial More videos at https://www.youtube.com/channel/UCgWvQ6cBxZwABl_hL48ayXg sample Code : --A. Select highest salary from employee table SELECT MAX(SAL) AS 'Max Salary' , MIN(Sal) AS 'Min Salary' FROM EMP -- B. Get the employee details who has highest salary SELECT * FROM EMP WHERE SAL=(SELECT MAX(SAL) FROM EMP) -- C. Get the second highest salary from employee table SELECT TOP 1 EMPName,SAL FROM ( SELECT TOP 2 EMPName,SAL FROM EMP ORDER BY SAL DESC) SUB ORDER BY SAL ASC -- D. Get the employees list who has the salary between x and y. SELECT * FROM EMP WHERE SAL Between 9000 and 13000 -- E. Get the highest salary on department wise SELECT DeptName,MAX(SAL) AS 'MAX SAL' FROM EMP E JOIN DEPT D ON E.DeptNo=D.DeptNo GROUP BY DeptName -- F. Get the highest salary, employee name along with department SELECT E.EmpName,SUB.DeptName,SUB.[Max Sal] FROM EMP E JOIN ( SELECT E.DeptNo, DeptName,MAX(SAL) AS 'Max Sal' FROM EMP E JOIN DEPT D ON E.DeptNo=D.DeptNo GROUP BY DeptName,E.DeptNo) SUB ON E.DeptNo=SUB.DeptNo AND E.Sal=SUB.[Max Sal]
Views: 21240 Training2SQL MSBI
SQL for Beginners (Part 4) : The ORDER BY Clause
 
02:08
The fourth part of a mini-series of videos showing the basics of SQL. In this episode, we take a look at how you can influence the order of the data that is returned by queries. For more information see: https://oracle-base.com/articles/misc/sql-for-beginners-the-order-by-clause Website: https://oracle-base.com Blog: https://oracle-base.com/blog Twitter: https://twitter.com/oraclebase Cameo by Nelson Calero : Blog: http://databaseindex.blogspot.com/ Twitter: https://twitter.com/ncalerouy Cameo appearances are for fun, not an endorsement of the content of this video.
Views: 789 ORACLE-BASE.com
DESCRIBE TABLE IN SQL SERVER
 
00:24
DESCRIBE ORACLE IN SQL SERVER BY khalidXY
Views: 7654 Khalid Fahim
How to create Sequence in sql using Oracle 10g
 
01:18
This vIdeo gives Information aboutHow to create Sequence in sql using Oracle 10g
Views: 297 AvilTwo Beginer
08- Oracle SQL Arabic Course  Order by clause  اوراكل ديفلوبر
 
05:11
أهلا بكم فى درس جديد من سلسلة دروس أوراكل ديفلوبر شرح SQL فى درس اليوم نتحدث عن Order by clause .......................................­.................... تواصل معانا علي الفيس بوك من هنا : https://www.facebook.com/askgad .......................................­.................... تواصل معانا علي موقعنا من هنا : https://www.askgad.com
Views: 2862 Ask Gad
SQL Server Group By in Arabic
 
16:02
Text version of the video http://csharp-video-tutorials.blogspot.com/2012/08/group-by-part-11.html Slides http://csharp-video-tutorials.blogspot.com/2013/08/part-11-group-by.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 1853 kudvenkat.arabic