Home
Search results “Oracle table of numbers”
Oracle Database tutorials 3:How to enable Line numbers in SQl Developer.
 
02:05
Wishlist: http://bit.ly/wishlist-amazon In this tutorial for database 11g You will see how to enable Line numbers in SQL Developer. This SQL tutorial and Oracle database 11g tutorial for beginners will show how to enable Line numbers in SQL Developer. 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
Views: 262635 Manish Sharma
#15. Intro to Oracle PL/SQL ( Type - table of numbers ) مقدمة لاوراكل
 
06:16
تعريف نوع خاص لحفظ بيانات من ارقام Get the Source Code: https://gist.github.com/Ismail-AlJubbah/ba2c2f17d6a84ef64a2d Help us caption & translate this video! http://amara.org/v/Fr7e/
Views: 159 Jubba Smail
Oracle PL/SQL Tutorial -  Numbers
 
04:45
Want all of our free Oracle videos? Download our free iPad app at http://itunes.apple.com/us/app/video-training-courses-from/id418130423?mt=8 http://www.infiniteskills.com/training/learning-oracle-pl-sql-programming.html You'll learn how numbers can be best utilized in this PLSQL tutorial from InfiniteSkills. YouTube: https://www.youtube.com/user/OreillyMedia Facebook: https://www.facebook.com/OReilly/?fref=ts Twitter: https://twitter.com/OReillyMedia Website: http://www.oreilly.com/
Generating random numbers in Oracle
 
03:30
For more tutorial please visit #techquerypond https://techquerypond.com https://techquerypond.wordpress.com https://twitter.com/techquerypond
Views: 720 Tech Query Pond
DBMS_RANDOM : Generating Random Data (Numbers, Strings and Dates) in Oracle
 
02:53
A demonstration of how to generate random numbers, strings and dates using the DBMS_RANDOM package in Oracle. For more information see: https://oracle-base.com/articles/misc/dbms_random.php Website: https://oracle-base.com Blog: https://oracle-base.com/blog Twitter: https://twitter.com/oraclebase Cameo by Chet Justice and LC Blog: http://www.oraclenerd.com/ Twitter: https://twitter.com/oraclenerd Cameo appearances are for fun, not an endorsement of the content of this video.
Views: 3989 ORACLE-BASE.com
add two numbers using stored procedure in Oracle Database
 
03:40
add two numbers using stored procedure in Oracle
Views: 92 Adam Tech
SQL with Oracle 10g XE - Table Overview and Basic Data Types
 
05:34
In this video I take a look at the structure of tables I plan on using for my database and point on the relational links between the tables. I also discuss the primary key of the table as well as using it as a foreign key in a related table. I take a look at a few basic data types for field columns to include: CHAR = 255 characters VARCHAR = 255 characters SMALLINT = -32,768 to 32,767 INT = -2,147,483,648 to 2,147,483,647 DECIMAL = Numbers with a decimal value Date = In the format DD-MMM-YYYY 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: 18743 Lecture Snippets
How to || make table|| in ORACLE 11G|| in Hindi||. Simplified!!! |PROGRAMMER GUYS CHANNEL.
 
02:52
............................................................................................................... HELLO FRIENDS, WELCOME TO 'PROGRAMMER GUYS' CHANNEL. ................................................................................................................ TODAY IN THIS VIDEO "WE MAKE OR CREATE A NEW TABLE WITH THE HELP OF CREATE TABLE COMMAND IN ORACLE 11 G EXPRESS EDITION in hindi". .............................................................................................................. SEE HOW TO ADD DATA INTO EXISTING TABLE : https://youtu.be/L6DPX5k9GRA ............................................................................................................... THANKS FOR WATCHING PLEASE LIKE, SUBSCRIBE AND SHARE... PLEASE SUBSCRIBE :https://goo.gl/KTN53r THESE ARE THE PREVIOUS VIDEOS :- FOR ADDING TWO NUMBERS IN C LANGUAGE : -https://youtu.be/A01StTyz-fw MAKING OF TABLE IN C LANGUAGE :- https://youtu.be/xa4Frci9FJE PRINT SERIES OF 1 USING FOR LOOP : - :https://youtu.be/AmdeAk2LseM ................................................................................................................
Views: 56 Programmer Guys
Oracle SQL Developer Tutorial For Beginners   85   Find the Total Number of Rows
 
00:52
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: 771 Sam Dhanasekaran
A Story of Indexes and Full Table Scans: Finding All the Red Sweets Part 1
 
08:43
"Why isn't Oracle using my index?!" is a common question people have when tuning SQL queries. In this episode Chris compares two methods for finding all the red candies from party bags he's prepared. He shows how these are like a full table scan and an index range scan. He goes on to compare the performance of these two approaches. He shows when a full table scan becomes more efficient than an index range scan and vice versa. ============================ The Magic of SQL with Chris Saxon Copyright © 2015 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.
Views: 9204 The Magic of SQL
Oracle SQL Practical question with answer | Sort the NUMBERS in the comma separated list
 
14:39
Oracle SQL Practical question with answer | Sort the NUMBERS in the comma separated list https://sivakacademy.blogspot.com/2019/06/sort-numbers-in-comma-separated-list.html Oracle Interview questions and Answers at https://www.youtube.com/playlist?list=PLb1qVSx1k1Vr0v4wVyvT3GEuA0J0M4xBm Oracle 18C New features at https://www.youtube.com/playlist?list=PLb1qVSx1k1Vqe06V1tIBcvnslMPWX69bW Oracle 12C New features at https://www.youtube.com/playlist?list=PLb1qVSx1k1VqM1u2IHWzZIgziqejl6wx- Oracle PLSQL records and collections at https://www.youtube.com/playlist?list=PLb1qVSx1k1VpAFTXopXvAh_D3PLcTntdm
Views: 642 Siva Academy
HOW TO CREATE TABLE IN ORACLE
 
07:40
In this video we will see how to create table in oracle also PFB syntax and create table statement used in this video --CREATE TABLE SYNTAX CREATE TABLE TABLE_NAME ( COL1_NAME DATA_TYPE (LENGTH), COL2_NAME DATA_TYPE (LENGTH), COL3_NAME DATA_TYPE (LENGTH) ) ; CREATE TABLE STUDENT ( SNAME VARCHAR2(20), SROLLNO NUMBER(4,0), SCLASS VARCHAR2(20) );
Views: 77 DWBIADDA VIDEOS
Learning PL/SQL programming
 
29:21
Download the session ppts @ https://drive.google.com/file/d/0B_2D199JLIIpLXp5cm9QMFpVS00/view?usp=sharing 3:05 - Procedures 6:48 - Cursors 15:13 - Functions 16:36 - Triggers 21:35 - Package 23:59 - Exceptions
Views: 183950 BBarters
Calculate  Maximum of Two Numbers in Oracle PLSQL
 
07:13
Calculate Maximum of Two Numbers in Oracle Function Calculate Maximum of Two Numbers in PLSQL bigger value in function MAX(x,y
Views: 44 Adam Tech
Why Is My Query Slow? More Reasons Storing Dates as Numbers Is Bad
 
05:25
Storing dates as numbers can cause unexpected problems. In this video Chris looks at one possible issue: inconsistent query performance. He then shows methods you can use to improve performance, including function-based indexes and histograms. ============================ The Magic of SQL with Chris Saxon Copyright © 2015 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.
Views: 7877 The Magic of SQL
How to Enable Line Numbers in SQL Developer
 
02:04
https://www.databasestar.com/sql-developer-line-numbers/ In this video, we’ll look at how to enable line numbers in SQL Developer. Line numbers are the numbers next to the code editor that tell you what number each line is, starting with 1 and working down. They are common in IDEs in all languages. When you install SQL Developer (or rather, download it, as it doesn’t need to be installed specifically), the line numbers are turned off by default. Why would you want to turn them on? Well, they are really helpful for debugging. When you get an error message, you’ll be given a line number. This refers to the line number in your SQL query that caused the error. With line numbers enabled in SQL Developer, you can see where the error comes from. Watch the video to learn how to turn on line numbers. (Hint: It’s an option inside Tools - Preferences). For more information on this, including screenshots, refer to the related article here: https://www.databasestar.com/sql-developer-line-numbers/
Views: 1050 Database Star
001 E(xtra) - Adding Line Numbers
 
00:31
Adding Line numbers in Oracle SQL Developer
Views: 27 Rishabh Jain
Oracle TRUNC: Number function
 
01:23
Oracle ROUND: Number function: https://www.youtube.com/watch?v=eWm_jON6NUI&index=1&list=PLjBraywgeSpHfYFw3HbwWLdThGzwNGDSR Oracle MOD: Number function: https://www.youtube.com/watch?v=eMGgo_1y6b4&list=PLjBraywgeSpHfYFw3HbwWLdThGzwNGDSR&index=3 The usage of SELECT Playlist: https://www.youtube.com/watch?v=ZwgiIiD1dWE&list=PLjBraywgeSpEW2f7AK4Ddt6BRxW0HWN74
SQL Aggregation queries using Group By, Sum, Count and Having
 
10:01
From SQL Queries Joes 2 Pros (Vol2) ch4.1. Learn up to write aggregated queries.
Views: 194352 Joes2Pros SQL Trainings
Oracle Lesson 15 (Auto G number)
 
02:38
Auto generate number
Views: 533 Haitham Salim
Insert and Commit: Databases for Developers #7
 
04:51
You load data into your database tables with an insert statement. In this episode Chris discusses how to use single and multirow inserts in SQL and their pros and cons. He also covers how to persist your changes to the database with commit. See the full syntax for insert in the SQL reference guide: http://docs.oracle.com/database/122/SQLRF/INSERT.htm#SQLRF01604 Take the Databases for Developers FREE SQL course at https://devgym.oracle.com/pls/apex/dg/class/databases-for-developers-foundations.html Need help with SQL? Ask us over on AskTOM: https://asktom.oracle.com Twitter: https://twitter.com/ChrisRSaxon Daily SQL Twitter tips: https://twitter.com/SQLDaily All Things SQL blog: https://blogs.oracle.com/sql/ ============================ The Magic of SQL with Chris Saxon Copyright © 2015 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.
Views: 6750 The Magic of SQL
Hod do I create sequence in Oracle? (Auto number in Oracle) (ICD) - icdstudents.com
 
02:35
To get auto number in Oracle. How do create sequence in Oracle? Attributes of sequence Oracle
Views: 6370 Bhavin Trivedi
Hash Tables and Hash Functions
 
13:54
This video describes the fundamental principles of the hash table data structure which allows for very fast insertion and retrieval of data. It covers commonly used hash algorithms for numeric and alphanumeric keys and summarises the objectives of a good hash function. Collision resolution is described, including open addressing techniques such as linear and quadratic probing, and closed addressing techniques such as chaining with a linked list.
Views: 331669 Computer Science
Oracle PLSQL Printing EVEN numbers from 1 to 100 Using FOR LOOP
 
01:33
#rohitkautkar #rohit #kautkar Oracle PLSQL Printing EVEN numbers from 1 to 100 Using FOR LOOP
Views: 17 Rohit Kautkar
Oracle SQL Tutorial 22 - Why Primary Keys Shouldn't Change
 
07:14
In the last video I mentioned that with our database design it is important to make sure that nobody tries to update a user's username. What happens if they do? Nothing horrible, Oracle will just throw an error. That's not such a big deal, but if you are hoping to make some kind of application that allows someone to change their username, this is not the best set up. Why? If you look at the projects table, we have a foreign key that references the username. Let's assume for a moment that Oracle allows you to do anything with your data. That means that if a user updates their username, there will be projects created by users that don't exist. Or a user could change their name to the previous owner. To fix this problem, we would need something such as an ON UPDATE CASCADE command for our foreign key. That would mean that if the user updated their username, the columns that reference that username would also update to the new value. This exists in some database management systems, but this does not exist in Oracle at the time of this video. How do we get around this problem? I'm sure we could conjure up something to allow us to update the username, but the easiest solution is to reference the user_id instead of the username. That way, when the username is updated, nothing changes inside of the foreign key. As a general rule, primary keys should never change. Foreign keys CAN change, but they should not change because a primary key changed. So, if we did happen to use a username as a column, it would be frowned upon if the username had to change because the column it references changes. However, it would be acceptable to change the foreign key if we needed to point to a new entity in the users table. Even if a username is never intended to change, these complications bother a lot of people. You can mitigate these problems by only referencing surrogate keys in foreign keys. This has the downside though that when you retrieve the data, you are going to have to do more work to make the data readable. For example, we had a table that was called project_users. It is essentially a table that says what users are part of what projects. We could have the foreign keys reference the project's name and the user's username. Then when you could say SELECT * FROM project_users. The data would be completely readable without doing anything. If you switch to only referencing surrogate primary keys, you will have a bunch of random numbers that don't mean anything and will have to be joined with other tables…which is really super frustrating when later you have to join a thousand tables to read anything. Which side do you prefer? Pick a side. Choose wisely. I'll see you all in the next video ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ HELP ME! http://www.patreon.com/calebcurry Subscribe to my newsletter: http://bit.ly/JoinCCNewsletter Donate!: http://bit.ly/DonateCTVM2. ~~~~~~~~~~~~~~~Additional Links~~~~~~~~~~~~~~~ More content: http://CalebCurry.com Facebook: http://www.facebook.com/CalebTheVideoMaker Google+: https://plus.google.com/+CalebTheVideoMaker2 Twitter: http://twitter.com/calebCurry Amazing Web Hosting - http://bit.ly/ccbluehost (The best web hosting for a cheap price!)
Views: 7088 Caleb Curry
Oracle PLSQL Printing ODD numbers from 1 to 100 Using FOR LOOP
 
01:26
#rohitkautkar #rohit #kautkar Oracle PLSQL Printing ODD numbers from 1 to 100 Using FOR LOOP
Views: 38 Rohit Kautkar
What is a HashTable Data Structure - Introduction to Hash Tables , Part 0
 
07:37
This tutorial is an introduction to hash tables. A hash table is a data structure that is used to implement an associative array. This video explains some of the basic concepts regarding hash tables, and also discusses one method (chaining) that can be used to avoid collisions. Wan't to learn C++? I highly recommend this book http://amzn.to/1PftaSt Donate http://bit.ly/17vCDFx STILL NEED MORE HELP? Connect one-on-one with a Programming Tutor. Click the link below: https://trk.justanswer.com/aff_c?offer_id=2&aff_id=8012&url_id=238 :)
Views: 832778 Paul Programming
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: 1050946 kudvenkat
Why is my Oracle Database Slow? The SQL Developer Performance Dashboard
 
11:00
Oracle SQL Developer's product manager, Jeff Smith, takes you through the Instance Viewer: a performance dashboard for your Oracle Database. See expensive queries, wait event break downs, and more!
Views: 2683 Jeff Smith
How to Install Oracle Database 11g on Windows 10 By Manish Sharma
 
08:24
Detail tutorial on How to install Oracle database 11g enterprise edition on Windows 10 Professional 64 bit. Full installation under 9 mins. You can follow the steps for installing Oracle 11g on Windows 10 32 bit home or any other version. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Previous Tutorial ► Download Link http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html ►Create Database using DBCA https://youtu.be/enFFezPYhCg ►How To Unlock User using ALTER USER https://youtu.be/sMqq9MSVmQo ------------------------------------------------------------------------- ►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/TheRebellionRider http://instagram.com/rebellionrider http://in.linkedin.com/in/mannbhardwaj/ 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: 392215 Manish Sharma
Oracle Database tutorials 4:  database connectivity using SQL developer and command prompt
 
09:19
Blog Link: http://bit.ly/how-to-create-new-connection-in-sql-developer Wishlist: http://bit.ly/wishlist-amazon This SQL tutorial and Oracle database 11g tutorial for beginners will show how to connect to database either on a local machine or on a machine in your LAN using ip address. Tool used in this tutorial is SQL developer & command prompt. 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 The Code makers
Views: 293003 Manish Sharma
SQL Tutorial - 13: Inserting Data Into a Table From Another Table
 
07:00
In this tutorial we'll learn to use the INSERT Query to copy data from one table into another.
Views: 280024 The Bad Tutorials
how to create paging,pagination in php and display 10 records per page in php
 
10:50
Need Help Or Need code? Feel Free To Contact Us Here http://www.noblecomputer.co.in/support.php using this tutorial you can easily understand that how paging created in php.
Views: 175700 Amit Andipara
Sql query to select all names that start with a given letter without like operator
 
03:02
Text Article http://csharp-video-tutorials.blogspot.com/2017/01/sql-query-to-select-all-names-that.html Slides http://csharp-video-tutorials.blogspot.com/2017/01/sql-query-to-select-all-names-that_31.html SQL Server Interview Questions and Answers text articles & slides http://csharp-video-tutorials.blogspot.com/2014/05/sql-server-interview-questions-and.html SQL Server Interview Questions and Answers playlist https://www.youtube.com/playlist?list=PL6n9fhu94yhXcztdLO7i6mdyaegC8CJwR 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 In this video we will discuss writing a SQL query to retrieve all student names that start with letter 'M' without using the LIKE operator. If the interviewer has not mentioned not to use LIKE operator, we would have written the query using the LIKE operator as shown below. SELECT * FROM Students WHERE Name LIKE 'M%' We can use any one of the following 3 SQL Server functions, to achieve exactly the same thing. CHARINDEX LEFT SUBSTRING The following 3 queries retrieve all student rows whose Name starts with letter 'M'. Notice none of the queries are using the LIKE operator. SELECT * FROM Students WHERE CHARINDEX('M',Name) = 1 SELECT * FROM Students WHERE LEFT(Name, 1) = 'M' SELECT * FROM Students WHERE SUBSTRING(Name, 1, 1) = 'M'
Views: 73401 kudvenkat
center the forms window in oracle forms 10g 11g | Ten Minute Code
 
01:23
Declare v_window varchar2(100):='WINDOW1'; v_width number(4); v_height number(4); vw number(4); vh number(4); BEGIN SET_WINDOW_PROPERTY(FORMS_MDI_WINDOW,WINDOW_STATE,MAXIMIZE); SET_WINDOW_PROPERTY('WINDOW1',WINDOW_STATE,MAXIMIZE); set_window_property(forms_mdi_window,title,'ABC LIMITED BARANDING MATERIALS MANAGEMENT SYSTEM'); vw:=gET_application_PROPERTY(DISPLAY_WIDTH)-50; vh :=gET_application_PROPERTY(DISPLAY_HEIGHT)-180; v_width := Get_Window_Property(v_WINDOW, WIDTH); v_height:= Get_Window_Property(v_WINDOW, HEIGHT); Set_Window_Property(v_WINDOW, POSITION, (vw-v_width)/2, (vh-v_height)/2) ; /* SET_WINDOW_PROPERTY(FORMS_MDI_WINDOW,WINDOW_STATE,MAXIMIZE); SET_WINDOW_PROPERTY('WINDOW1',WINDOW_STATE,MAXIMIZE); set_window_property(forms_mdi_window,title,:global.COMP_MODULE); SET_ITEM_PROPERTY('CON.CUT_BTN',ENABLED,PROPERTY_FALSE); SET_ITEM_PROPERTY('CON.COPY_BTN',ENABLED,PROPERTY_FALSE); SET_ITEM_PROPERTY('CON.CQUERY_BTN',ENABLED,PROPERTY_FALSE); */ END;
Views: 555 abdulquium
PL/SQL Tutorial 6 (Oracle): Sum Command
 
02:38
PL/SQL Tutorial 6 (Oracle): Sum Command In this tutorial I show you how to use the sum command in PL/SQL. It's used to sum numbers in your data tables. 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: 153 CodingWithMitch
SQL Server join :- Inner join,Left join,Right join and full outer join
 
08:11
For more such videos visit http://www.questpond.com For more such videos subscribe https://www.youtube.com/questpondvideos?sub_confirmation=1 Also watch Learn Sql Queries in 1 hour :- https://www.youtube.com/watch?v=uGlfP9o7kmY See our other Step by Step video series below :- Learn Data Science in 1 hour :- https://tinyurl.com/y5o7qbau Learn angular tutorial step by step https://tinyurl.com/ycd9j895 Learn C# Step by Step https://goo.gl/FNlqn3 Learn Design Pattern Step by Step https://goo.gl/eJdn0m Learn SQL Server Step by Step http://tinyurl.com/ja4zmwu Learn Data structures & algorithm https://tinyurl.com/ybx29c5s Learn MVC Core step by step :- http://tinyurl.com/y9jt3wkv Learn MSBI Step by Step in 32 hours:- https://goo.gl/TTpFZN Learn Xamarin Mobile Programming Step by Step :- https://goo.gl/WDVFuy Learn SharePoint Step by Step in 8 hours:- https://goo.gl/XQKHeP Learn Tableau step by step :- https://tinyurl.com/kh6ojyo Preparing for C# / .NET interviews start here http://www.youtube.com/watch?v=gaDn-sVLj8Q In this video we will try to understand four important concepts Inner joins,Left join,Right join and full outer joins. We are also distributing a 100 page Ebook ".Sql Server Interview Question and Answers". If you want this ebook please share this video in your facebook/twitter/linkedin account and email us on [email protected] with the shared link and we will email you the PDF.
Views: 931502 Questpond
Add line number SQL Developer in 30 seconds
 
00:33
Step1:Create a SQL file in SQL Developer Step2:Go to Tools/Preferences/Code Editor/Line Gutter Step3:Enable 'Show line number'by checking the checkbox Step4:Press OK
Views: 405 Automa Sha
DAX functions to generate Auto Serial Number in Power BI Table
 
07:41
In this video, we will learn about creating auto serial numbers with the help of DAX functions in Power BI. Please follow the below link to download the Power BI desktop file used in this video. https://drive.google.com/file/d/1xa0TM6AfIxnGSYeSK8W9VD7nhFs86Kam/view?usp=sharing #DynamicSerialNumber Thanks for watching! Please like, share, subscribe and comment.
Views: 962 TheDataLabs
Create and Execute simple SELECT Stored Procedure in Oracle PL SQL with Parameter
 
02:23
www.ReportingGuru.com - This video discusses how to create and run / execute a simple Oracle stored procedure in PL SQL. It returns the results of a simple SELECT statement and has one parameter that is passed in. Email us at [email protected] if you need reporting help, custom reports, or reporting architecture setup. Our phone number is 1-(800) 921-4759.
Views: 53 Reporting Guru
PL/SQL tutorial 11: PL/SQL Simple Loop in Oracle Database by Manish Sharma RebellionRider.com
 
04:21
First tutorial in Iterative statement series explaining concepts of Simple Loop in PL/SQL With a quick brief intro of Loops in Oracle PL/SQL ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/simple-loop Previous Tutorial ► IF-THEN : https://youtu.be/IWvuFD6eD30 ► Simple CASE Statement https://youtu.be/DMlDwOmqAzo ► Searched CASE Statement https://youtu.be/jk7k4TDs3F0 ► DECODE Statement https://youtu.be/lKXqXINCNLo ------------------------------------------------------------------------- ►►►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: 76728 Manish Sharma
We keep storing numbers in string datatypes
 
06:53
A common problem in the database world is when we persist in putting numeric data into a string datatype...and then expect to sequence the data in numeric fashion. This quick tip looks at how to handle it, and covers an interesting AskTom question at the same time. ========================================­­­­============== Copyright © 2015 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.
Views: 699 Connor McDonald
Data Modeling: Databases for Developers #3
 
06:26
How do you decide which table and column to store each aspect of your data? In this episode, Chris discusses things to consider when making this choice. He also compares document and relational modeling, going into the pros and cons of each. Take the Databases for Developers FREE SQL course at https://devgym.oracle.com/pls/apex/dg/class/databases-for-developers-foundations.html Twitter: https://twitter.com/ChrisRSaxon Daily SQL Twitter tips: https://twitter.com/SQLDaily All Things SQL blog: https://blogs.oracle.com/sql/ ============================ The Magic of SQL with Chris Saxon Copyright © 2015 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.
Views: 10153 The Magic of SQL
Oracleadda.com - Random functions in Oracle
 
12:23
visit our forum: www.oracleadda.com How to generate random numbers, strings and dates in Oracle. Use them for your testing purpose.Please comment in case of any concerns understanding above.
Views: 218 Oracleadda
Oracle PLSQL Printing EVEN ODD numbers from 1 to 100 Using FOR LOOP
 
01:42
#rohitkautkar #rohit #kautkar Oracle PLSQL Printing EVEN ODD numbers from 1 to 100 Using FOR LOOP
Views: 24 Rohit Kautkar