Home
Search results “Sql oracle type number”
Oracle SQL Tutorial 33 - NUMBER Data Type
 
07:18
This video we are going to discuss the NUMBER data type. The Number data type is used to store integers, and real numbers. When you create a column as a NUMBER, you can store pretty huge or pretty small numbers in this column. Now there are two things you need to consider when working with numbers, and that is the precision as well as the how big the number is. For example, we can store the number 9.9. This has two significant digits. We could also store the number 9.9 X 10^4. In this situation, the number is much larger, but the number of significant digits is the same. 9.9 are the significant digits. When we expand this out we just have 99000, and the zeros are just used for size and are not considered "significant" in this situation. In fact, you get a max precision of 38, but a maximum value of 9.99 * 10^125. You can also use this data type to store very small numbers. Check the docs for the specifics on maximums and minimums. You can provide it with two pieces of information: Precision - The total number of digits. Scale - The number of digits to the right of the decimal. You do it in this format: NUMBER (precision, scale). The important thing to remember in this is that when you specify a precision, you will be limiting the max size of the numbers. The secret behind this data type is that it is actually stored in scientific notation. That is we store a number and then we can multiply it by 10 raised to some power. This allows us to store much larger numbers without taking up a ton of space. The oracle docs actually gives a formula that you can use to see how much storage is going to be required for a specific NUMBER data type. How much precision can be used? The acceptable range is 1-38. What about scale? The range is actually -84 to 127. I'll explain the scale in more detail in an upcoming video. That's because there is a lot of confusing things here…What does it mean for the scale to be negative? How can we have a scale that is bigger that the total number of digits available through the precision. That's a topic for another video. It's important to understand that when we increase our scale, we decrease the max size of the number. For example if we have a precision of 5 and a scale of 3, the highest number we can store is 99.999. This is in contrast to a precision of 5 and a scale of 2 which allows for up to 99.999. Either way you get 5 significant digits, but the numbers of digits to the left and right of the decimal change. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Support 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: 8459 Caleb Curry
Oracle SQL Tutorial 23 - Intro to Data Types
 
05:03
Every column within a table has to be given what is known as a datatype. A data type is a fairly simple concept when you dissect the word. It is literally the type of data. Why do we use types, though? The biggest benefit is so that Oracle knows how to interpret and work with our data. It also makes the database better at rejecting incorrect data. If we had to concept of a data type, there would be a lot more work involved in forcing data to be of the right format. It would also be harder for us to get the database to treat the data in the correct way. In addition to this, a database can optimize storage and performance for a column if everything is of the same data type. Because of this, each column can only support one data type. There are numerous different data types in Oracle and it helps us if we categorize them. The first types of datatypes we should learn about are: String, Numeric, Temporal Now, there are few more categories we could make, but these are the main ones. We will worry about the other ones another day as I am only introducing the topic. A string data type is anything within quotes. Most databases use single quotes for string data. Inside of the quotes can be any number of characters. What is a character? Think of any letter, number, or symbol you can type. Some people call these letters, numbers, and symbols alphanumeric. Numeric data type includes only numbers. These data types are often used for data that you plan on using for mathematical calculations. Temporal data types are data types that are used for dates and times. Now, each data type is probably going to have some options you'll need to worry about, but one that comes up with every data type is storage. The reason we need to consider storage is because we may end up with millions of rows in a table and the difference between a few bytes for each row will make a huge difference when we look at the whole picture. When a data type gives you the option of size, you will want to a size that will be able to hold what you need, but nothing more. In the upcoming videos we are going to discuss the available data types in more detail. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Support 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: 8358 Caleb Curry
Oracle - SQL - Number Functions
 
03:59
Oracle - SQL - Number Functions Watch more Videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Anadi Sharma, Tutorials Point India Private Limited.
SQL Tutorial - 7: Data-Types in SQL (Part-2)
 
06:48
In this tutorial we';; check out the data type options we have available for use in SQL. We'll talk about Bigint, int, smallint, tinyint, decimal, number, float, char, varchar, blob, datetime, date, time and year.
Views: 101110 The Bad Tutorials
Oracle Database11g tutorials 14 : How to CREATE TABLE using sql developer and command prompt
 
08:36
Oracle Database11g tutorials 14 How to Create table using command prompt and Create table using sql developer Blog Link http://bit.ly/1TkY4Oe Time Line 0:25 Introduction of Tables in Database 1:03 What is Create Table (Introduction of create table) 1:30 Syntax of Create Table 2:08 How to create table using Command Prompt 4:55 How to create table using SQL Developer Links for Oracle Database tutorials 4: database connectivity using SQL developer and command prompt http://youtu.be/wSqoXRlXDUU You can have indepth knowledge about SQL create table here http://www.rebellionrider.com/sql-create-table.html Tool used in this tutorial is 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 E-Mail [email protected] Twitter https://twitter.com/rebellionrider Instagram http://instagram.com/rebellionrider Facebook. https://www.facebook.com/imthebhardwaj Linkedin. http://in.linkedin.com/in/mannbhardwaj/ Thanks for linking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com Today in this oracle database tutorial we will see How to CREATE A TABLE. if we have to define a table in layman language then we can say that Tables are just a collection of Rows and Columns but In RDBMS tables are database objects which help in organizing data into ROWS and COLUMNS. We can also say that SQL tables are kind of data structure which are used by database for efficient storage of data. To create a table in our database we use SQL CREATE TABLE command. SQL CREATE TABLE is a type of DATA DEFINITION LANGUAGE also known as DDL. To Create a table in your schema you will require CREATE TABLE system privilege. In our future videos we will see what are system and object privileges and how to grant them to a user. Today for this video we will be using Sample schema HR which already has all the necessary privileges. Ohk Let's see the syntax. CREATE TABLE table name ( column name1 Data-Type(size), column name2 Data-Type(size), ..... ); CREATE TABLE is an oracle reserved word or say an Oracle key word whereas There are 3 different ways of creating a table in Oracle database. Creating a table using Command Line Interface (CLI) in Oracle database For demonstrating how to create table in oracle database using CLI, I'll be using Command prompt. Thats how we create table using command prompt. you can check your table structure by DESCRIBE command for that just write DESC and your table name. Like this Another way of creating a table is by using Graphic user interface (GUI) in Oracle database To demonstrate how to create table using GUI we will use SQL developer. Lets open our SQL developer I am connected to HR schema if you do not know how to create a connection to database using SQL developer please watch my oracle database tutorial 4 that explains database connectivity using SQL developer and command prompt. Link for this video is in the description below. So lets create a table. Creating a table using SQL developer is very easy we do not have to fire any query here. Let's start First of all right click on your connection in which you want to create a table and choose schema browser. This will open a separate schema browser pane or you can expend your connection by clicking this + sign and then right click on table and choose New Table. However I prefer working with schema browser so let's skip to schema browser pane here from the first drop-down list you can choose connection name and in the second drop down list you can choose what database objects you want to work with we want to create a table thus I'll choose table and then click this arrow here and choose option for new table Ok we have created a table wizard first of all give a unique name to your table and add some column as well. For this, click the green plus button. Now we already have a column so give it some name. Also choose a datatype from the list and specify any size you can check this not null column if in case you want to make this a mandatory column you can also specify default value and constraint If you want to make this column a primary key you can click here In my future video i'll show you what are these constraints and different ways of applying them on a column in a table. for this video we will concentrate on create table only so when you are done with all your columns click ok Thats your table You can double click on your table here and can see its structure. Thats it
Views: 183318 Manish Sharma
Oracle SQL Tutorial 11 - CREATE TABLE
 
05:04
The way you create a table is to use the CREATE TABLE command. CREATE TABLE users() So in this situation, the name comes right after the TABLE keyword. The next thing we do is put all of the columns on a line that we want to put in our table. CREATE TABLE users( user_id, username, first_name, last_name ) Notice the naming conventions here. For this series we are going to make columns with what is known as snake casing. This is where each individual word is separated by an underscore. if you have more than one column, all of them have to have commas except the last one. The comma is a way to say that another column is coming, so you don't need to do it on the last one. Now you would think we were done, but we also have to say what data type each column is. Later we will extensively discuss data types so we can focus on them exclusively. For now, here are the data types we are going to use: CREATE TABLE users( user_id NUMBER, username VARCHAR2(50), first_name VARCHAR2(50), last_name VARCHAR2(50) ) Now, inside of the parenthesis for varchar2, we pass in a number... This is the max length of the string. But the question is, what is it measured in? The default is actually in bytes, not characters. For example if we have the string hello, it is 5 characters, but it might take up a total of 10 bytes of storage. So I would recommend adding the keyword char right after the number so it defaults to 50 characters, not bytes. CREATE TABLE users( user_id NUMBER, username VARCHAR(50 CHAR), first_name VARCHAR2(50 CHAR), last_name VARCHAR2(50 CHAR) ) This will work to create a table, but it's really missing a lot of information… which column is the primary key? Are we adding any indexes? Is there any thing else we need to say about these columns? So as you can tell, we are making progress, but there is still so much to learn. The biggest gotcha to remember from this video is that the data type VARCHAR ends in a 2, stupid, right? who would end the name of something with a 2? Once again, this is Caleb from CalebTheVideoMaker2, and we will catch you in the next one! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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: 36693 Caleb Curry
Learn Oracle | Data Types in PL SQL
 
13:14
Pebbles present, Learn Oracle 10g with Step By Step Video Tutorials. Learn Oracle 10g Tutorial series contains the following videos : Learn Oracle - History of Oracle Learn Oracle - What is Oracle - Why do we need Oracle Learn Oracle - What is a Database Learn Oracle - What is Grid Computing Learn Oracle - What is Normalization Learn Oracle - What is ORDBMS Learn Oracle - What is RDBMS Learn Oracle - Alias Names, Concatenation, Distinct Keyword Learn Oracle - Controlling and Managing User Access (Data Control Language) Learn Oracle - Introduction to SQL Learn Oracle - Oracle 10g New Data Types Learn Oracle - How to Alter a Table using SQL Learn Oracle - How to Create a Package in PL SQL Learn Oracle - How to Create a Report in SQL Plus Learn Oracle - How to Create a Table using SQL - Not Null, Unique Key, Primary Key Learn Oracle - How to Create a Table using SQL Learn Oracle - How to Create a Trigger in PL SQL Learn Oracle - How to Delete Data from a Table using SQL Learn Oracle - How to Drop and Truncate a Table using SQL Learn Oracle - How to Insert Data in a Table using SQL Learn Oracle - How to open ISQL Plus for the first time Learn Oracle - How to Open SQL Plus for the First Time Learn Oracle - How to Update a Table using SQL Learn Oracle - How to use Aggregate Functions in SQL Learn Oracle - How to use Functions in PL SQL Learn Oracle - How to use Group By, Having Clause in SQL Learn Oracle - How to Use Joins, Cross Join, Cartesian Product in SQL Learn Oracle - How to use Outer Joins (Left, Right, Full) in SQL Learn Oracle - How to use the Character Functions, Date Functions in SQL Learn Oracle - How to use the Merge Statement in SQL Learn Oracle - How to use the ORDER BY Clause with the Select Statement Learn Oracle - How to use the SELECT Statement Learn Oracle - How to use the Transactional Control Statements in SQL Learn Oracle - How to use PL SQL Learn Oracle - Data Types in PL SQL Learn Oracle - Exception Handling in PL SQL Learn Oracle - PL SQL Conditional Logics Learn Oracle - PL SQL Cursor Types - Explicit Cursor, Implicit Cursor Learn Oracle - PL SQL Loops Learn Oracle - Procedure Creation in PL SQL Learn Oracle - Select Statement with WHERE Cause Learn Oracle - SQL Operators and their Precedence Learn Oracle - Using Case Function, Decode Function in SQL Learn Oracle - Using Logical Operators in the WHERE Clause of the Select Statement Learn Oracle - Using Rollup Function, Cube Function Learn Oracle - Using Set Operators in SQL Learn Oracle - What are the Different SQL Data Types Learn Oracle - What are the different types of Databases Visit Pebbles Official Website - http://www.pebbles.in Subscribe to our Channel – https://www.youtube.com/channel/UCNNjWVsQqaMYccY044vtHJw?sub_confirmation=1 Engage with us on Facebook at https://www.facebook.com/PebblesChennai Please Like, Share, Comment & Subscribe
Views: 2567 Pebbles Tutorials
Oracle SQL Tutorial 24 - Important Data Types
 
06:09
In the upcoming videos we are going to discuss data types in depth, but I don't want to drown you in all of the details. Because of that, I'm giving you this video which is going to introduce you to the most important data types. Then, in the upcoming videos, I'll describe them in more depth. One of the data types we've already discussed in this video is NUMBER. This data type is used to, obviously, store a number. It can be used to store integers (whole numbers), or numbers with decimals. There are two other numeric data types you should know of. BINARY_FLOAT and BINARY_DOUBLE are both numeric data types that are known as floating point numbers. A floating point number is often used for large numbers that have decimal places where it is acceptable to not be completely precise. What I mean by this is that these numbers can only store numbers correctly up to a certain decimal point. If you need perfect precision, you will want to use the NUMBER data type. Now storing numbers is good sometimes, but occasionally you will want to store string data. String data can be any sequence of characters, including numbers. By telling the database that a column is a string data type, the database knows how to treat that column. There are four important string data types that you need to know about. The first two are CHAR and NCHAR. These data types are used to store a fixed-length string. So for example, you can say you want to store 12 characters. This means that every value for this column will be exactly 12 characters. If you insert less than 12 characters, the data will be padded with spaces. This means you will want to use one of these data types when every value in the column is the same length. What is the difference between CHAR and NCHAR? CHAR uses what is known as ASCII while NCHAR uses Unicode. The difference is what characters are allowed and how much space each character takes. ASCII takes up less space but only supports English, numbers, and some symbols. UNICODE allows you to store characters from multiple languages but takes up more space. Those were both fixed-length string. What if you want to store data that changes in length? That is where VARCHAR2 and NVARCHAR2 come in. When it comes to storing dates, the data types that are most important are DATE and TIMESTAMP. Date can be used to store dates and time. Timestamp is a data type that can be used to store an exact moment in time. Lastly, there are interval types. These store a date range. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Support 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: 6989 Caleb Curry
017-Oracle SQL 12c: Number functions
 
15:41
تعلم اوراكل حتى الاحتراف تعلم اوراكل من الصفر
Views: 4063 khaled alkhudari
84. DECIMAL Data Type in SQL (Hindi)
 
19:18
Please Subscribe Channel Like, Share and Comment Visit : www.geekyshows.com
Views: 8050 Geeky Shows
Oracle SQL Tutorial 32 - VARCHAR2 and NVARCHAR2
 
03:06
This video we are going to discuss the VARCHAR2 and the NVARCHAR2 data types. The previous videos are a good foundation to this video. I've actually discussed so much stuff in those videos that I don’t have a whole lot to say. Good for you, right? I discussed over the previous videos that you should prefer to use VARCHAR2 over CHAR. That's because there is not a difference in performance or storage for a VARCHAR2 column. The only difference is that an CHAR column forces each value to take up a certain length even if it's not. There is one difference between the variable length and fixed length data types here that you need to know about, and that is storage limits. CHAR has a limit of 2000 bytes, while VARCHAR2 has a limit of 4000 bytes. That means you can store twice as much junk in a VARCHAR2 column! Other than that, these data types work exactly the same. I recommend you always use the VARCHAR2 data types instead of the CHAR data types, and only use NVARCHAR2 if you have a non-Unicode database. This will allow you to store Unicode characters in a column. Now, the amount of storage you can put in a VARCHAR2 column is twice what you can put in a CHAR column, but 4000 characters is still not very many characters. This is where the LOB data types come in, which we will discuss in the next video! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Support 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: 5764 Caleb Curry
SQL using MySQL : Numeric Data Types
 
13:55
Note: After Re-Branding 9Lean is now CodesBay -------------------------------------------------------------------------------- The video is first pn the series of learning SQL using MySQL. This video describe the various numric data types as which can be used while creating the SQL Tables. 1. Numeric Types 2. Floating point types 3. Bit Fields 4. SQL Strict Mode Hope it helps you in learning something new.. enjoy! Please take a moment to Like! Subscribe! Share! and Comment! Your actions will keep me going Want to get more, Connect me @ Youtube: https://www.youtube.com/CodesBay Twitter: https://twitter.com/CodesBay Facebook: https://www.facebook.com/CodesBay instagram: https://www.instagram.com/CodesBay Github: https://github.com/CodesBay Pinterest: https://in.pinterest.com/CodesBay Tumblr: https://CodesBay.tumblr.com Web: http://www.CodesBay.com #sql #databse #rdbms #mysql #tables
Views: 159 CodesBay
PL/SQL: Factorial
 
08:14
In this tutorial, you'll learn how to write factorial program in plsql PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural extension for SQL and the Oracle relational database. PL/SQL is available in Oracle Database (since version 7), TimesTen in-memory database (since version 11.2.1), and IBM DB2 (since version 9.7).[1] Oracle Corporation usually extends PL/SQL functionality with each successive release of the Oracle Database. PL/SQL includes procedural language elements such as conditions and loops. It allows declaration of constants and variables, procedures and functions, types and variables of those types, and triggers. It can handle exceptions (runtime errors). Arrays are supported involving the use of PL/SQL collections. Implementations from version 8 of Oracle Database onwards have included features associated with object-orientation. One can create PL/SQL units such as procedures, functions, packages, types, and triggers, which are stored in the database for reuse by applications that use any of the Oracle Database programmatic interfaces. PL/SQL works analogously to the embedded procedural languages associated with other relational databases. For example, Sybase ASE and Microsoft SQL Server have Transact-SQL, PostgreSQL has PL/pgSQL (which emulates PL/SQL to an extent), and IBM DB2 includes SQL Procedural Language,[2] which conforms to the ISO SQL’s SQL/PSM standard. The designers of PL/SQL modeled its syntax on that of Ada. Both Ada and PL/SQL have Pascal as a common ancestor, and so PL/SQL also resembles Pascal in several aspects. However, the structure of a PL/SQL package does not resemble the basic Object Pascal program structure as implemented by a Borland Delphi or Free Pascal unit. Programmers can define public and private global data-types, constants and static variables in a PL/SQL package.[3] PL/SQL also allows for the definition of classes and instantiating these as objects in PL/SQL code. This resembles usage in object-oriented programming languages like Object Pascal, C++ and Java. PL/SQL refers to a class as an "Abstract Data Type" (ADT) or "User Defined Type" (UDT), and defines it as an Oracle SQL data-type as opposed to a PL/SQL user-defined type, allowing its use in both the Oracle SQL Engine and the Oracle PL/SQL engine. The constructor and methods of an Abstract Data Type are written in PL/SQL. The resulting Abstract Data Type can operate as an object class in PL/SQL. Such objects can also persist as column values in Oracle database tables. PL/SQL is fundamentally distinct from Transact-SQL, despite superficial similarities. Porting code from one to the other usually involves non-trivial work, not only due to the differences in the feature sets of the two languages,[4] but also due to the very significant differences in the way Oracle and SQL Server deal with concurrency and locking. There are software tools available that claim to facilitate porting including Oracle Translation Scratch Editor,[5] CEITON MSSQL/Oracle Compiler [6] and SwisSQL.[7] The StepSqlite product is a PL/SQL compiler for the popular small database SQLite. PL/SQL Program Unit A PL/SQL program unit is one of the following: PL/SQL anonymous block, procedure, function, package specification, package body, trigger, type specification, type body, library. Program units are the PL/SQL source code that is compiled, developed and ultimately executed on the database. The basic unit of a PL/SQL source program is the block, which groups together related declarations and statements. A PL/SQL block is defined by the keywords DECLARE, BEGIN, EXCEPTION, and END. These keywords divide the block into a declarative part, an executable part, and an exception-handling part. The declaration section is optional and may be used to define and initialize constants and variables. If a variable is not initialized then it defaults to NULL value. The optional exception-handling part is used to handle run time errors. Only the executable part is required. A block can have a label. Package Packages are groups of conceptually linked functions, procedures, variables, PL/SQL table and record TYPE statements, constants, cursors etc. The use of packages promotes re-use of code. Packages are composed of the package specification and an optional package body. The specification is the interface to the application; it declares the types, variables, constants, exceptions, cursors, and subprograms available. The body fully defines cursors and subprograms, and so implements the specification. Two advantages of packages are: Modular approach, encapsulation/hiding of business logic, security, performance improvement, re-usability. They support object-oriented programming features like function overloading and encapsulation. Using package variables one can declare session level (scoped) variables, since variables declared in the package specification have a session scope.
Views: 5152 radhikaravikumar
Learning Zone : P/L SQL Programming how to convert Number to Word , By Dia Rashid
 
06:33
Oracle P/L SQL Programming how to convert Number to Word , Can be used in Oracle form 10g or Report 10g , example convert Total of value in numbers to be in word . By Dia Rashid. #OnlineLz.com #SQL #Python #MySql #Oracle
Views: 715 Dia Rashid
ORACLE SQL NUMERIC FUNCTIONS
 
05:26
This video shows Oracle numeric function.
Views: 1632 SQL TUTORIALS
Index in SQL | Oracle SQL Tutorial Videos | Mr.Vijay Kumar
 
20:16
** For Online Training Registration: https://goo.gl/r6kJbB ► Call: +91-8179191999 💡 Visit Our Website for Classroom Training: https://nareshit.in/oracle-training/ 💡 For Online Training: https://nareshit.com/oracle-online-training/ #Oracle #Training #CourseVideos -------------------------- 💡 About NareshIT: "Naresh IT is having 14+ years of experience in software training industry and the best Software Training Institute for online training, classroom training, weekend training, corporate training of Hadoop, Salesforce, AWS, DevOps, Spark, Data Science, Python, Tableau, RPA , Java, C#.NET, ASP.NET, Oracle, Testing Tools, Silver light, Linq, SQL Server, Selenium, Android, iPhone, C Language, C++, PHP and Digital Marketing in USA, Hyderabad, Chennai and Vijayawada, Bangalore India which provides online training across all the locations -------------------------- 💡 Our Online Training Features: 🎈 Training with Real-Time Experts 🎈 Industry Specific Scenario’s 🎈 Flexible Timings 🎈 Soft Copy of Material 🎈 Share Videos of each and every session. -------------------------- 💡 Please write back to us at 📧 [email protected]/ 📧 [email protected] or Call us at the USA: ☎+1404-232-9879 or India: ☎ +918179191999 -------------------------- 💡 Check The Below Links ► For Course Reg: https://goo.gl/r6kJbB ► Subscribe to Our Channel: https://goo.gl/q9ozyG ► Circle us on G+: https://plus.google.com/+NareshIT ► Like us on Facebook: https://www.facebook.com/NareshIT ► Follow us on Twitter: https://twitter.com/nareshitek ► Follow us on Linkedin: https://goo.gl/CRBZ5F ► Follow us on Instagram: https://goo.gl/3UXYK3
Views: 40923 Naresh i Technologies
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: 69185 Manish Sharma
PL/SQL tutorial 15: DML Trigger With Before Insert, Update and Delete DML Examples
 
09:17
PL/SQL Tutorial 15 explaining DML Trigger with examples such as Before Insert, Update and Delete in Detail. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/dml-triggers Previous Tutorial ► Trigger Intro : https://youtu.be/R3fvX_xf5P4 ► SELECT-INTO : https://youtu.be/F5eMJhwmCQs ►IF-THEN-ELSIF: https://youtu.be/aW9XgUHSr0I ------------------------------------------------------------------------- ►►►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: 107900 Manish Sharma
How to convert number to text in Oracle SQL
 
06:02
How to convert number to text in Oracle SQL
Views: 493 Tanmun
Numeric and Date Data type  - Oracle SQL Certification Course
 
19:53
Full Playlist link : https://www.youtube.com/playlist?list=PLovUiB6V4l0qdB1MEnHXCUuW6qH5y4FMp Don’t just learn the SQL Language, Become Job-Ready and Launch Your Career as a Certified Oracle SQL Developer! What you’ll learn Become Job Ready to Start Contributing as Database Developer Day 1 Pass the Oracle SQL Fundamentals Examinations Program in the SQL Language to solve a variety of Database Problems Be a SQL Ninja and understand how the Oracle Database Works
Views: 0 UNIQLY TUT
Oracle tutorial : Object oriented programming in Oracle PL SQL
 
07:51
Oracle tutorial : Object oriented programming in Oracle PL SQL oracle tutorial for beginners This video Oracle tutorial will tell you how to implement object oriented concept in oracle CREATE OR REPLACE TYPE MyInput AS object ( num1 NUMBER, num2 NUMBER ); CREATE OR REPLACE TYPE MyCal AS object ( mynum MyInput, member FUNCTION Plus RETURN NUMBER , member FUNCTION Sub RETURN NUMBER, member FUNCTION Mul RETURN NUMBER, member FUNCTION Div RETURN NUMBER ); / CREATE OR REPLACE TYPE BODY MyCal as member FUNCTION Plus RETURN NUMBER AS result NUMBER ; BEGIN result := mynum.num1 + mynum.num2; RETURN result; END Plus ; member FUNCTION Sub RETURN NUMBER AS result NUMBER; BEGIN result := mynum.num2 - mynum.num1; RETURN result; END Sub; member FUNCTION Mul RETURN NUMBER AS result NUMBER ; BEGIN result := mynum.num1 * mynum.num2; RETURN result; END; member FUNCTION Div RETURN NUMBER AS result NUMBER (10, 3); BEGIN result := mynum.num1 / mynum.num2 ; RETURN result; END; END ; / DECLARE obj1 MyInput := MyInput(50, 100); obj2 MyCal := MyCal(obj1); BEGIN Dbms_Output.Put_Line(obj2.Plus); Dbms_Output.Put_Line(obj2.Sub); Dbms_Output.Put_Line(obj2.Mul); Dbms_Output.Put_Line(obj2.Div); END; #techquerypond https://techquerypond.com https://techquerypond.wordpress.com https://twitter.com/techquerypond object oriented database example
Views: 3808 Tech Query Pond
How to return multiple values from a function in oracle pl/sql ? (without using out parameter)
 
14:19
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: 20455 Kishan Mashru
HOW TO RETURN MULTIPLE VALUES FROM A PROCEDURE IN ORACLE PL/SQL? (USING OUT PARAMETERS)
 
04:46
This video tutorial explains how an oracle procedure can return multiple values with a proper example. The video tutorial shows how this problem can be tacked using simple and easy to understand out parameters!!!
Views: 13973 Kishan Mashru
How to find Oracle Service Name by sql command
 
01:40
If you have an Oracle database on your network which is able to connect to with Oracle SQL Developer, using hostname, port, username, password and the SID. you need to connect another application, however it uses the Service Name instead of the SID. it is the way for to you to determine the SERVICE_NAME of the database when you am connected in SQL Developer via the SID thanking you... just share this video to your friends...
Views: 17088 w3h
PL-SQL tutorial 13 - TABLE OF ANY NUMBER
 
09:39
hi guys today i am going to show you how to manipulate or represent table of any number,Oracle database Unbeatable,Unbreakable #TABLEOFANYNUMBER Platform..
Views: 358 Oracle World
Procedures in Oracle PL/SQL
 
23:50
This is a video tutorial on creating procedures, with input parameters types such as IN , OUT and IN OUT . Also the video demonstrates the way we can use default value with any parameter, and at the end the video demonstrates exception handling in PL/SQL procedures
Views: 8230 Kishan Mashru
MySQL 32 - FLOAT and DOUBLE Data Types
 
06:23
FLOAT and DOUBLE data types are data types that can be used to store numbers that can include decimal numbers. They are specifically used to store estimates. What do I mean? I mean that the precision of a FLOAT or DOUBLE value can be lost when doing math. The data types are only capable of maintaining a certain level of precision. The level of precision is usually adequate for most mathematical operations. If you need to store exact data, you will want to look into using the INT or DECIMAL data type instead. The numbers stored in a FLOAT or DOUBLE column are called floating point numbers, we'll see why in just a moment. Why are they called floating point numbers? let's look at a number. 150. This number could be represented as 150, or it could be represented as 1.5 * 10^2, or 1.5e2. With floating point numbers, scientific notation is used. These numbers are called floating point numbers because the decimal can float to different spots as we change the exponent. This means that the data type needs to store the number, how many decimal the number needs moved, and a sign bit. The benefit of floating point numbers is that they allow us to store pretty huge numbers. The down side is that they are not storing values exactly because they are limited in size. This means that only a certain level of precision is to be expected from a floating point data type. If you remember from the video of DECIMAL, precision is the number of digits in a number. As long as the precision for one of these data types exceeds the need for your specific data, the data type can work fine. For example, if you are storing a number like 15 trillion, you don't have to worry as much with precision as your number does not contain a lot of digits. This number can be represented as 1.5 x 10^13. This is a lot different than trying to store 1.5534534534 x10^13. Now we know both of these data types do not maintain a high number of digits correctly, but what is the difference between FLOAT and DOUBLE. The difference is the amount of storage they take up. Float takes up 4 bytes while DOUBLE takes up 8. The benefit in DOUBLE is that because it has more room to store data, it has a higher level of precision and can store bigger numbers. Now, what level of precision can you expect from either of these? FLOAT around 7 and DOUBLE around 15. Now, these data types are obnoxious because the exact values depend on your operating system and in general these monsters cannot be trusted. Especially when you start doing math with different numbers. In general, it is recommended to use the DOUBLE data type to have a higher level of precision and calculations in MySQL are done with DOUBLE. Always remember… prepare for trouble, make it double. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Support 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: 8242 Caleb Curry
Learn Oracle | What are the Different SQL Data Types
 
03:19
Pebbles present, Learn Oracle 10g with Step By Step Video Tutorials. Learn Oracle 10g Tutorial series contains the following videos : Learn Oracle - History of Oracle Learn Oracle - What is Oracle - Why do we need Oracle Learn Oracle - What is a Database Learn Oracle - What is Grid Computing Learn Oracle - What is Normalization Learn Oracle - What is ORDBMS Learn Oracle - What is RDBMS Learn Oracle - Alias Names, Concatenation, Distinct Keyword Learn Oracle - Controlling and Managing User Access (Data Control Language) Learn Oracle - Introduction to SQL Learn Oracle - Oracle 10g New Data Types Learn Oracle - How to Alter a Table using SQL Learn Oracle - How to Create a Package in PL SQL Learn Oracle - How to Create a Report in SQL Plus Learn Oracle - How to Create a Table using SQL - Not Null, Unique Key, Primary Key Learn Oracle - How to Create a Table using SQL Learn Oracle - How to Create a Trigger in PL SQL Learn Oracle - How to Delete Data from a Table using SQL Learn Oracle - How to Drop and Truncate a Table using SQL Learn Oracle - How to Insert Data in a Table using SQL Learn Oracle - How to open ISQL Plus for the first time Learn Oracle - How to Open SQL Plus for the First Time Learn Oracle - How to Update a Table using SQL Learn Oracle - How to use Aggregate Functions in SQL Learn Oracle - How to use Functions in PL SQL Learn Oracle - How to use Group By, Having Clause in SQL Learn Oracle - How to Use Joins, Cross Join, Cartesian Product in SQL Learn Oracle - How to use Outer Joins (Left, Right, Full) in SQL Learn Oracle - How to use the Character Functions, Date Functions in SQL Learn Oracle - How to use the Merge Statement in SQL Learn Oracle - How to use the ORDER BY Clause with the Select Statement Learn Oracle - How to use the SELECT Statement Learn Oracle - How to use the Transactional Control Statements in SQL Learn Oracle - How to use PL SQL Learn Oracle - Data Types in PL SQL Learn Oracle - Exception Handling in PL SQL Learn Oracle - PL SQL Conditional Logics Learn Oracle - PL SQL Cursor Types - Explicit Cursor, Implicit Cursor Learn Oracle - PL SQL Loops Learn Oracle - Procedure Creation in PL SQL Learn Oracle - Select Statement with WHERE Cause Learn Oracle - SQL Operators and their Precedence Learn Oracle - Using Case Function, Decode Function in SQL Learn Oracle - Using Logical Operators in the WHERE Clause of the Select Statement Learn Oracle - Using Rollup Function, Cube Function Learn Oracle - Using Set Operators in SQL Learn Oracle - What are the Different SQL Data Types Learn Oracle - What are the different types of Databases Visit Pebbles Official Website - http://www.pebbles.in Subscribe to our Channel – https://www.youtube.com/channel/UCNNjWVsQqaMYccY044vtHJw?sub_confirmation=1 Engage with us on Facebook at https://www.facebook.com/PebblesChennai Please Like, Share, Comment & Subscribe
Views: 1791 Pebbles Tutorials
12. DATE, DATATIME and TIMESTAMP Data Type in SQL (Hindi)
 
02:24
Please Subscribe Channel Like, Share and Comment Visit : www.geekyshows.com
Views: 31988 Geeky Shows
auto increment in sql oracle - ( Auto increment field )
 
03:07
auto increment in sql oracle ----------------------------------------------- CREATE table customers ( customer_id int not null, customer_name varchar(50), primary key (customer_id) ); create sequence customer_id minvalue 1 start with 1 cache 10; insert into customers values(customer_id.nextval,'maxwel'); -- to drop sequence drop sequence customer_id
Views: 7425 Data Disc
create report from package - pipeline pl/sql Oracle
 
02:15
12-march-2017 Oracle Apex create report from package - pipeline pl/sql steps 1. Create package on dept from HR 2. Package Specification create or replace PACKAGE r_deptinfo AS TYPE t_row IS RECORD ( DEPTNO NUMBER(2,0), DNAME varchar2(60), LOC varchar2(60) ); TYPE t_tab IS TABLE OF t_row; FUNCTION get_tab(p_DEPTNO number) RETURN t_tab PIPELINED; END; / 3. Package body create or replace PACKAGE BODY r_deptinfo AS FUNCTION get_tab(p_DEPTNO number) RETURN t_tab PIPELINED IS l_row t_row; cursor c1 is select DEPTNO, DNAME, LOC from dept where (DEPTNO = p_DEPTNO or 1=1); BEGIN FOR r1 IN c1 LOOP l_row.DEPTNO := r1.DEPTNO; l_row.DNAME := r1.DNAME; l_row.LOC := r1.LOC; PIPE ROW (l_row); END LOOP; RETURN; END; END; / 4. Call package select DEPTNO, DNAME, LOC from table(r_deptinfo.get_tab(10)); col DNAME for a30 col LOC for a30 drop package r_deptinfo / 5. now we can use it anywhere as a sql statement thats it Thanks . . .
Views: 685 Mostafiz Mitul
DIFFERENCE BETWEEN CHAR AND VARCHAR2 DATATYPE IN ORACLE SQL
 
04:36
This video tutorial explains the difference between similar looking and used char datatype and varchar2 datatypes with an simple example. This video will answer the question such as how is the data internally stored differently for char and vacchar2 datatype. Also why is varchar2 much better option to be used than char data type is explained. If you want more such videos of exciting and amazing 'difference between' concepts, check out the links below : union and union all : https://youtu.be/n9FqQOd8liY replace and translate : https://youtu.be/HKYF77BGzOE procedure and function : https://youtu.be/q3LmOenL120 in and exists : https://youtu.be/REX4IjRYlFw rank and dense_rank : https://youtu.be/WGSX998hZ9M delete and truncate : https://youtu.be/u76wMm2byXo %type and %rowtype : https://youtu.be/MlLUFeZ_3eM
Views: 3373 Kishan Mashru
PL/SQL Tutorial | Exception Handling in Oracle Database
 
08:58
Learn exception handling in oracle, understanding different types of exceptions and trapping exception with SQLERRM and SQLCODE. How to handle exception in oracle database, How to handle user defined exception in oracle database, What is Pragma in Exception Handling, What is Pragma Exception_INIT in oracle, Difference between named and unnamed exception in oracle, Types of exception available in oracle, How to use Raise_application_error in oracle, How to use custom exception in oracle, Details of System Exception: DUP_VAL_ON_INDEX ORA-00001 You tried to execute an INSERT or UPDATE statement that has created a duplicate value in a field restricted by a unique index. TIMEOUT_ON_RESOURCE ORA-00051 You were waiting for a resource and you timed out. TRANSACTION_BACKED_OUT ORA-00061 The remote portion of a transaction has rolled back. INVALID_CURSOR ORA-01001 You tried to reference a cursor that does not yet exist. This may have happened because you've executed a FETCH cursor or CLOSE cursor before OPENing the cursor. NOT_LOGGED_ON ORA-01012 You tried to execute a call to Oracle before logging in. LOGIN_DENIED ORA-01017 You tried to log into Oracle with an invalid username/password combination. NO_DATA_FOUND ORA-01403 You tried one of the following: You executed a SELECT INTO statement and no rows were returned. You referenced an uninitialized row in a table. You read past the end of file with the UTL_FILE package. TOO_MANY_ROWS ORA-01422 You tried to execute a SELECT INTO statement and more than one row was returned. ZERO_DIVIDE ORA-01476 You tried to divide a number by zero. INVALID_NUMBER ORA-01722 You tried to execute a SQL statement that tried to convert a string to a number, but it was unsuccessful. STORAGE_ERROR ORA-06500 You ran out of memory or memory was corrupted. PROGRAM_ERROR ORA-06501 This is a generic "Contact Oracle support" message because an internal problem was encountered. VALUE_ERROR ORA-06502 You tried to perform an operation and there was a error on a conversion, truncation, or invalid constraining of numeric or character data. CURSOR_ALREADY_OPEN ORA-06511 You tried to open a cursor that is already open. Linkedin: https://www.linkedin.com/in/aditya-kumar-roy-b3673368/ Facebook: https://www.facebook.com/SpecializeAutomation/
Views: 1144 Specialize Automation
SQL: Sequence Generator
 
04:41
In this tutorial, you'll learn how to make use of sequence generator. PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural extension for SQL and the Oracle relational database. PL/SQL is available in Oracle Database (since version 7), TimesTen in-memory database (since version 11.2.1), and IBM DB2 (since version 9.7).[1] Oracle Corporation usually extends PL/SQL functionality with each successive release of the Oracle Database. PL/SQL includes procedural language elements such as conditions and loops. It allows declaration of constants and variables, procedures and functions, types and variables of those types, and triggers. It can handle exceptions (runtime errors). Arrays are supported involving the use of PL/SQL collections. Implementations from version 8 of Oracle Database onwards have included features associated with object-orientation. One can create PL/SQL units such as procedures, functions, packages, types, and triggers, which are stored in the database for reuse by applications that use any of the Oracle Database programmatic interfaces. PL/SQL works analogously to the embedded procedural languages associated with other relational databases. For example, Sybase ASE and Microsoft SQL Server have Transact-SQL, PostgreSQL has PL/pgSQL (which emulates PL/SQL to an extent), and IBM DB2 includes SQL Procedural Language,[2] which conforms to the ISO SQL’s SQL/PSM standard. The designers of PL/SQL modeled its syntax on that of Ada. Both Ada and PL/SQL have Pascal as a common ancestor, and so PL/SQL also resembles Pascal in several aspects. However, the structure of a PL/SQL package does not resemble the basic Object Pascal program structure as implemented by a Borland Delphi or Free Pascal unit. Programmers can define public and private global data-types, constants and static variables in a PL/SQL package.[3] PL/SQL also allows for the definition of classes and instantiating these as objects in PL/SQL code. This resembles usage in object-oriented programming languages like Object Pascal, C++ and Java. PL/SQL refers to a class as an "Abstract Data Type" (ADT) or "User Defined Type" (UDT), and defines it as an Oracle SQL data-type as opposed to a PL/SQL user-defined type, allowing its use in both the Oracle SQL Engine and the Oracle PL/SQL engine. The constructor and methods of an Abstract Data Type are written in PL/SQL. The resulting Abstract Data Type can operate as an object class in PL/SQL. Such objects can also persist as column values in Oracle database tables. PL/SQL is fundamentally distinct from Transact-SQL, despite superficial similarities. Porting code from one to the other usually involves non-trivial work, not only due to the differences in the feature sets of the two languages,[4] but also due to the very significant differences in the way Oracle and SQL Server deal with concurrency and locking. There are software tools available that claim to facilitate porting including Oracle Translation Scratch Editor,[5] CEITON MSSQL/Oracle Compiler [6] and SwisSQL.[7] The StepSqlite product is a PL/SQL compiler for the popular small database SQLite. PL/SQL Program Unit A PL/SQL program unit is one of the following: PL/SQL anonymous block, procedure, function, package specification, package body, trigger, type specification, type body, library. Program units are the PL/SQL source code that is compiled, developed and ultimately executed on the database. The basic unit of a PL/SQL source program is the block, which groups together related declarations and statements. A PL/SQL block is defined by the keywords DECLARE, BEGIN, EXCEPTION, and END. These keywords divide the block into a declarative part, an executable part, and an exception-handling part. The declaration section is optional and may be used to define and initialize constants and variables. If a variable is not initialized then it defaults to NULL value. The optional exception-handling part is used to handle run time errors. Only the executable part is required. A block can have a label. Package Packages are groups of conceptually linked functions, procedures, variables, PL/SQL table and record TYPE statements, constants, cursors etc. The use of packages promotes re-use of code. Packages are composed of the package specification and an optional package body. The specification is the interface to the application; it declares the types, variables, constants, exceptions, cursors, and subprograms available. The body fully defines cursors and subprograms, and so implements the specification. Two advantages of packages are: Modular approach, encapsulation/hiding of business logic, security, performance improvement, re-usability. They support object-oriented programming features like function overloading and encapsulation. Using package variables one can declare session level (scoped) variables, since variables declared in the package specification have a session scope.
Views: 8666 radhikaravikumar
Oracle create table and auto number using sql developer - 02
 
23:17
Oracle create table and auto number using sql developer part-02. In this video show you how to create table, and how to create auto number on table in oracle using sql developer.
Views: 153 Ly Kimchrea
1-.Programacion PL/SQL Orientada a Objetos - Arrays
 
10:35
create or replace type ListaTipoArray as array(5) of varchar2(100); / create or replace type ListaNumTipoArray as array(5) of number(1); / declare --datos nombre1 varchar2(10):= 'Mario'; apellido1 varchar2(10):= 'ruiz'; apellido2 varchar2(10):= 'gonzalez'; pais varchar2(10):= 'Mexico'; Ciudad varchar2(10):= 'CDMX'; --declarar variable tipo array DatosPersonales ListaTipoArray; --declarar variable tipo array NumeroDato ListaNumTipoArray; begin --se abren instancias DatosPersonales:= ListaTipoArray(nombre1, apellido1, apellido2, pais, Ciudad); NumeroDato:= ListaNumTipoArray(1, 2, 3, 4, 5); for i in 1 .. 5 loop dbms_output.put_line(NumeroDato(i)||'.'|| DatosPersonales(i)||chr(13)); end loop; exception when others then dbms_output.put_line(sqlerrm); end; POO Programacion PL/SQL Orientada a Objetos oracle oracle sql oracle pl sql oracle sqlplus curso curso de oracle curso de sql curso de pl sql curso de sqlplus sql developer toad pl / sql developer desarrollo de aplicaciones programador desarrollador como ser programador como ser desarrollador certificacion certificacion oracle certificaciones 1z0-061 1z0-062 dba dba oracle administrador de base de datos administrador de base de datos oracle database oracle preparar certificacion oracle oracle expert oracle experto oramex el mundo de oracle mario ruiz mario ruiz marioruizcommx buenas practicas como usar pl sql como usar oracle como usar toad como usar sqlplus preguntas de la certificacion braindumps oracle linux linux batch awk perl shell scripting shell
Views: 814 Mario Ruiz
Overview of SQL Server Data Types: Numbers
 
15:13
This video is part of LearnItFirst's Transact-SQL Programming: SQL Server 2008/R2 course. More information on this video and course is available here: http://www.learnitfirst.com/Course161 In this video, Scott will start with integer-based numbers, and then move into decimal-based numbers. How many bytes does it take to represent each basic integer data type? To demonstrate decimal-based numbers, money is used as the example. When a number is too long, unlike when a string is too long, Management Studio will return an overflow error instead of truncating. Scott discusses how to specify the number of digits and decimal places in the output, and more in this video. Highlights from this video: - INT, TINYINT, SMALLINT, and BIGINT - The DATALENGTH function - What if your business operates using less than 4 decimal places? - Using FLOAT and much more...
Views: 2480 LearnItFirst.com
SQL 047 Data Types, Approximate Numeric, DOUBLE PRECISION
 
01:36
Explains the approximate numeric data type DOUBLE PRECISION. From http://ComputerBasedTrainingInc.com SQL Course. Learn by doing SQL commands for ANSI Standard SQL, Access, DB2, MySQL, Oracle, PostgreSQL, and SQL Server.
Views: 645 cbtinc
PL/SQL tutorial 34: Table Based Record datatype in Oracle Database Part 2
 
05:28
PL/SQL tutorial for beginners on Table Based Records Data types in Oracle Database By Manish Sharma at RebellionRider.com ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/table-based-record-2 Previous Tutorial ► Introduction To Records: https://youtu.be/1iHbZDuDbis ► Table Based Record Part 1: https://youtu.be/8WqpqKUj9l8 ------------------------------------------------------------------------- ►►►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/ ___Facebook Official Page___ https://www.facebook.com/RebellionRider.official/ 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: 24343 Manish Sharma
Oracle SQL Tutorial 18 - How to Create Foreign Keys
 
07:09
In this video we are going to be creating foreign keys. I highly recommend watching the previous video before you watch this one. Essentially, we are creating a very simple database for a system where we can create projects and add people to those projects. We started with the users table: --Delete the table if needed: --DROP TABLE users; CREATE TABLE users( user_id NUMBER, username VARCHAR2(50 CHAR) UNIQUE, CONSTRAINT users_pk PRIMARY KEY (user_id) ); Now we are going to create a table for projects with a column that is a foreign key to the username. We're going to want to make this match data types: CREATE TABLE projects( project_id NUMBER, project_name VARCHAR2(50 CHAR) UNIQUE, creator VARCHAR2(50 CHAR) ) Next, we need to add the column attributes we decided on last video: CREATE TABLE projects( project_id NUMBER, project_name VARCHAR2(50 CHAR) UNIQUE, creator VARCHAR2(50 CHAR) NOT NULL ) NOT NULL because we want every project to have a creator, but we are not labeling UNIQUE because that means we could only have a specific username once in the table. We want to allow a user to create multiple projects. We also need to add a primary key: CREATE TABLE projects( project_id NUMBER, project_name VARCHAR2(50 CHAR) UNIQUE, creator VARCHAR2(50 CHAR) NOT NULL, CONSTRAINT projects_pk PRIMARY KEY (username) ) Now, the question that remains is, how can I tell Oracle that I want the username to reference the username column of the other table? We have to make a foreign key constraint. As you've learned from the previous videos, there are about three ways to create constraints. You can do it inline at the column level, unnamed. You can do it at the column level, named, and you can do it at the Table level, named. Usually the table-level is preferred, but I will quickly remind you how to do all three again. CREATE TABLE projects( project_id NUMBER, project_name VARCHAR2(50 CHAR) UNIQUE, creator VARCHAR2(50 CHAR) NOT NULL REFERENCES users (username), CONSTRAINT projects_pk PRIMARY KEY (project_id) ) This works, but if we want to name it, we should do this: CREATE TABLE projects( project_id NUMBER, project_name VARCHAR2(50 CHAR) UNIQUE, creator VARCHAR2(50 CHAR) NOT NULL CONSTRAINT projects_users_fk REFERENCES users (username), CONSTRAINT projects_pk PRIMARY KEY (project_id) ) This works, but the preferred method is to do it at the table level: CREATE TABLE projects( project_id NUMBER, project_name VARCHAR2(50 CHAR) UNIQUE, creator VARCHAR2(50 CHAR) NOT NULL, CONSTRAINT projects_pk PRIMARY KEY (project_id), CONSTRAINT projects_users_fk FOREIGN KEY (creator) REFERENCES users (username) ) Great! So you've learned how to create a foreign key, now we can see it inside of Oracle SQL Developer. One important thing when it comes to foreign keys is what happens when have data in your database and you try to delete the parent row that a row in the child table references? In the next video we are going to configure that using ON DELETE. See you all then and if you enjoy this series, please do me a huge favor by liking the video and subscribing to my YouTube channel. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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: 24016 Caleb Curry
Data Types in SQL Server
 
18:40
Data Types in SQL Server CORRECTION: for storing DECIMAL you need to just count the numbers in precision and scale, like to store 100.55 you have to define like DECIMAL(5,2) Check my blog for more details and SQL Queries: https://sqlwithmanoj.com/2015/09/20/sql-basics-data-types-in-sql-server-video/ For more updates like my page in FB: https://www.facebook.com/sqlwithmanoj
Views: 30802 SQL with Manoj
Create new connection with new user in Oracle SQL Developer
 
10:28
This video shows you how to create a new connection using a new user account (other than the system user account) in Oracle SQL Developer, so that you have a clean workspace without all the clutter of system tables. It is NOT a general introduction to using Oracle SQL Developer.
Views: 361068 Chitu Okoli
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: 282643 Manish Sharma
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: 150933 BBarters
PL/SQL: Fibonacci series
 
06:51
In this tutorial, you'll learn how to write Fibonacci series code in plsql PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural extension for SQL and the Oracle relational database. PL/SQL is available in Oracle Database (since version 7), TimesTen in-memory database (since version 11.2.1), and IBM DB2 (since version 9.7).[1] Oracle Corporation usually extends PL/SQL functionality with each successive release of the Oracle Database. PL/SQL includes procedural language elements such as conditions and loops. It allows declaration of constants and variables, procedures and functions, types and variables of those types, and triggers. It can handle exceptions (runtime errors). Arrays are supported involving the use of PL/SQL collections. Implementations from version 8 of Oracle Database onwards have included features associated with object-orientation. One can create PL/SQL units such as procedures, functions, packages, types, and triggers, which are stored in the database for reuse by applications that use any of the Oracle Database programmatic interfaces. PL/SQL works analogously to the embedded procedural languages associated with other relational databases. For example, Sybase ASE and Microsoft SQL Server have Transact-SQL, PostgreSQL has PL/pgSQL (which emulates PL/SQL to an extent), and IBM DB2 includes SQL Procedural Language,[2] which conforms to the ISO SQL’s SQL/PSM standard. The designers of PL/SQL modeled its syntax on that of Ada. Both Ada and PL/SQL have Pascal as a common ancestor, and so PL/SQL also resembles Pascal in several aspects. However, the structure of a PL/SQL package does not resemble the basic Object Pascal program structure as implemented by a Borland Delphi or Free Pascal unit. Programmers can define public and private global data-types, constants and static variables in a PL/SQL package.[3] PL/SQL also allows for the definition of classes and instantiating these as objects in PL/SQL code. This resembles usage in object-oriented programming languages like Object Pascal, C++ and Java. PL/SQL refers to a class as an "Abstract Data Type" (ADT) or "User Defined Type" (UDT), and defines it as an Oracle SQL data-type as opposed to a PL/SQL user-defined type, allowing its use in both the Oracle SQL Engine and the Oracle PL/SQL engine. The constructor and methods of an Abstract Data Type are written in PL/SQL. The resulting Abstract Data Type can operate as an object class in PL/SQL. Such objects can also persist as column values in Oracle database tables. PL/SQL is fundamentally distinct from Transact-SQL, despite superficial similarities. Porting code from one to the other usually involves non-trivial work, not only due to the differences in the feature sets of the two languages,[4] but also due to the very significant differences in the way Oracle and SQL Server deal with concurrency and locking. There are software tools available that claim to facilitate porting including Oracle Translation Scratch Editor,[5] CEITON MSSQL/Oracle Compiler [6] and SwisSQL.[7] The StepSqlite product is a PL/SQL compiler for the popular small database SQLite. PL/SQL Program Unit A PL/SQL program unit is one of the following: PL/SQL anonymous block, procedure, function, package specification, package body, trigger, type specification, type body, library. Program units are the PL/SQL source code that is compiled, developed and ultimately executed on the database. The basic unit of a PL/SQL source program is the block, which groups together related declarations and statements. A PL/SQL block is defined by the keywords DECLARE, BEGIN, EXCEPTION, and END. These keywords divide the block into a declarative part, an executable part, and an exception-handling part. The declaration section is optional and may be used to define and initialize constants and variables. If a variable is not initialized then it defaults to NULL value. The optional exception-handling part is used to handle run time errors. Only the executable part is required. A block can have a label. Package Packages are groups of conceptually linked functions, procedures, variables, PL/SQL table and record TYPE statements, constants, cursors etc. The use of packages promotes re-use of code. Packages are composed of the package specification and an optional package body. The specification is the interface to the application; it declares the types, variables, constants, exceptions, cursors, and subprograms available. The body fully defines cursors and subprograms, and so implements the specification. Two advantages of packages are: Modular approach, encapsulation/hiding of business logic, security, performance improvement, re-usability. They support object-oriented programming features like function overloading and encapsulation. Using package variables one can declare session level (scoped) variables, since variables declared in the package specification have a session scope.
Views: 4467 radhikaravikumar
Oracle SQL Tutorial 25 - ASCII and Unicode
 
03:33
In the previous video we talked about some of the most popular data types. We are going to discuss them in more detail. The data type we are going to start with is CHAR and NCHAR. I told you of both of these but I never explained the difference. That's because there is some other stuff I need to explain before I can explain the difference. This has to deal with what is known as character sets. When you have a string, there are only so many characters you are allowed to store in that string. The characters you are allowed to store is determined by what is known as the character set. A common character set is ASCII. This character set allows you to store English characters, numbers, and some symbols. ASCII started with 127 characters, and then they came out with the ASCII extended, which allows for up to 255 characters. Even with 255 characters though, we are limited in what we can store using one character set. If the computer only allows ASCII, we are going to be limited when working with different languages. Of course it works for some situations, but globalization of software has been a big thing with the development of the interwebs …and the movement towards a new world order (Revelation 13:7). That means that ASCII is no longer the best character set. It has largely been replaced with a character set known as Unicode. Oracle has a few Unicode character sets that we can use when we work with string data. When you start studying character sets, I can promise that you will run across the word encoding. Encoding refers to the way that the allowed characters can be stored on the computer. A computer doesn't just store a letter, everything has to be stored in binary. Unicode is the character set, but it has numerous different encodings. Essentially, the computer can store the same characters in multiple different ways, depending on which encoding is used. The most popular encodings for Unicode are UTF-8 and UTF-16. UTF stands for Unicode Transformation Format. In the next video we will be discussing these in detail and express their differences. Once we got that down, we'll be able to loop back around to data types. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Support 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: 6055 Caleb Curry
Data Types Used in SQL Server 2012: Numbers
 
19:20
This video is part of LearnItFirst's SQL Server 2012: A Comprehensive Introduction course. More information on this video and course is available here: http://www.learnitfirst.com/Course170 In this second of three videos about data types, Scott will discuss the two categories of numeric data types as well as examples of when to use certain data types. Highlights from this video: - What are the two categories of numeric data types and when are each used? - Why is it important to choose the right numeric type? - What must you be concerned with when storing numbers with decimals? - The different integer-based numerics - When is it appropriate to use money and smallmoney data types for currency? and much more...
Views: 7597 LearnItFirst.com
Oracle SQL Tutorial 2 - Entities and Attributes
 
10:19
Entities and Attributes is a concept you will need to know for any relational database. Entities are the things we store data about and entities are the things that we store about the data. Each entity and attribute has a generic and a specific. So a generic entity (known as an entity type) gives a blue print for the specific entities to be based off of...watch the video, it will make sense. Same for the attributes, an attribute takes general attribute types (like phone number, name, etc), and gives you guidance on how to give specific values for other entities. 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: 97898 Caleb Curry