Home
Search results “Sql oracle type boolean”
15 Boolean Datatype in PL SQL
 
00:35
Oracle PL/SQL Tutorial - A Comprehensive Training Course https://www.youtube.com/channel/UCXLir0qvG4xDmgLtGZBd8qg
Views: 919 Satyam Rai
ORACLE SQL 10: BOOLEAN, AND, OR
 
06:16
http://studyandshare.wordpress.com/ http://www.facebook.com/groups/studyandsharevn/
Views: 1267 studyandsharevn
Function as Boolean expression in oracle
 
12:10
This video explains how to use function as a Boolean expression in any conditional expressions.
PLS-4: PL/SQL Variables
 
24:47
For Full Course Experience Please Go To http://mentorsnet.org/course_preview?course_id=5 Full Course Experience Includes 1. Access to course videos and exercises 2. View & manage your progress/pace 3. In-class projects and code reviews 4. Personal guidance from your Mentors ---------------------------------------------------------------------------------------- A variable is nothing but a name given to a storage area that our programs can manipulate. Each variable in PL/SQL has a specific data type, which determines the size and layout of the variable's memory; the range of values that can be stored within that memory and the set of operations that can be applied to the variable. The name of a PL/SQL variable consists of a letter optionally followed by more letters, numerals, dollar signs, underscores, and number signs and should not exceed 30 characters. By default, variable names are not case-sensitive. You cannot use a reserved PL/SQL keyword as a variable name. PL/SQL programming language allows to define various types of variables, which we will cover in subsequent chapters like date time data types, records, collections, etc. For this chapter, let us study only basic variable types. With PL/SQL you can declare variables and then use them in SQL and procedural statements anywhere that an expression can be used. Variables can be used for the following: • Temporary storage of data: Data can be temporarily stored in one or more variables for use when validating data input and for processing later in the data flow process. • Manipulation of stored values: Variables can be used for calculations and other data manipulations without accessing the database. • Reusability: After they are declared, variables can be used repeatedly in an application simply by referencing them in other statements, including other declarative statements. • Ease of maintenance: When using %TYPE and %ROWTYPE (more information on %ROWTYPE is covered in a subsequent lesson), you declare variables, basing the declarations on the definitions of database columns. If an underlying definition changes, the variable declaration changes accordingly at run time. This provides data independence, reduces maintenance costs, and allows programs to adapt as the database changes to meet new business needs. More information on %TYPE is covered later in this lesson. Types of Variables" All PL/SQL variables have a data type, which specifies a storage format, constraints, and valid range of values. PL/SQL supports four data type categories—scalar, composite, reference, and LOB (large object)—that you can use for declaring variables, constants, and pointers. • Scalar data types hold a single value. The main data types are those that correspond to column types in Oracle server tables; PL/SQL also supports Boolean variables. • Composite data types, such as records, allow groups of fields to be defined and manipulated in PL/SQL blocks. • Reference data types hold values, called pointers, that designate other program items. Reference data types are not covered in this course. • LOB data types hold values, called locators, that specify the location of large objects (such as graphic images) that are stored out of line. LOB data types are discussed in detail later in this course.
Views: 42191 Oresoft LWC
Символьные типы данных CHAR и VARCHAR в SQL и базах данных MySQL сервера
 
03:24
В данном видео уроке мы поговорим о символьном типе данных и его реализации в базах данных MySQL сервера. Отметим, что MySQL поддерживает стандартный набор символьных типов данных для SQL, который представлен типами данных CHAR и VARCHAR. Тип данных CHAR в базах данных MySQL севера позволяет хранить строки фиксированной длинны, а тип данных VARCHAR используется в базах данных для хранения строк переменной длины. Также стоит сказать, что количество символов, хранимых в столбцах CHAR и VARCHAR указывается при создании таблицы. Рубрика по базам данных: http://zametkinapolyah.ru/zametki-o-mysql/sqlite/ Рубрика MySQL: http://zametkinapolyah.ru/zametki-o-mysql/server-mysql Паблик блога в ВК: https://vk.com/zametkinapolyah Тематическая группа в ВК: https://vk.com/zametki_bd Помощь проекту: WMR: R28827266698 WMZ: Z293550531456 Яндекс.Деньги: 410011531129223
09- Oracle PL-SQL  Arabic Course - PL/SQL Records -%ROWTYPE   اوراكل ديفلوبر
 
15:44
أهلا بكم فى درس جديد من سلسلة دروس أوراكل ديفلوبر شرح PL/SQL فى درس اليوم نتحدث عن composite data type واللى بتنقسم الى: - PL/SQL records - PL/SQL collections فى الدرس ده هنتكلم عن PL/SQL Record و كيفية استخدام %ROWTYPE Attribute و نكمل ان شاء الله مع PL/SQL collections فى الدرس القادم .......................................­.................... تواصل معانا علي الفيس بوك من هنا : https://www.facebook.com/askgad .......................................­.................... تواصل معانا علي موقعنا من هنا : https://www.askgad.com
Views: 4919 Ask Gad
Oracle SQL Tutorial 12 - Intro to Constraints
 
06:13
As I believe I've mentioned in an earlier video, a constraint is basically a rule we can put in our database that prevents someone from putting the wrong data in. It protects our relationships and data integrity. Because the goal of these constraints are to protect our data integrity, you may hear them called integrity constraints. There are many integrity constraints we are going to talk about: NOT NULL UNIQUE PRIMARY KEY FOREIGN KRY CHECK There is also the DEFAULT attribute. These are all keywords we can add to our columns that will change the way the database works with our data and also prevents incorrect data. NOT NULL is a constraint you can put on a column that prevents nulls. A null is the absence of a value. When we say null, we are saying that every single row has to have a value for this column. UNIQUE is a constraint that makes every row have a unique value for this column. Now note, this does not require values to be put it, and it will allow multiple rows to be null. Next, we are going to talk about primary keys. What qualifies a column as a candidate key? First, not a single row should have a null for that column. Second, every row must be unique. The primary key constraint is essentially a combination of the NOT NULL constraint and the UNIQUE constraint. The foreign key constraint sets the requirement that any value in this column for any row must match a row in another column. Check constraints allow us to be more strict with what data is allowed in our database. NOT NULL and UNIQUE give some level of restriction, but what if we want something more specific? For example, what if we only want values between 0 and 100? That is where check constraints come in. When using check constraints, you give a boolean expression. A boolean expression is something that can be evaluated to true or false. It will only insert the row if the value you try to put into the row makes the expression evaluate to true. So if you put in a value too great or small, the expression will be false and the data is not allowed to be entered. The default constraint is a value you can give a column, and if for any reason when the row is created in the table a value is not provided, the default value will be given. So for example, we could have a bank account table where the balance defaults to 0. How do you actually implement these constraints when you are creating a table? In the next video we are going to be adding these to our users table. Please be sure to subscribe! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Support me on Patreon: 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: 24847 Caleb Curry
Boolean Data Type
 
05:09
Views: 125 iYezan
SQL Tutorial - 17: Logical Operators (Part-1)
 
10:42
In this tutorial we'll be checking out some of the most important logical operators.
Views: 59430 The Bad Tutorials
Boolean Variables 15
 
00:21
Please watch: "Install Oracle Database 12c Release 2 on Windows 10 Professional 64 bit" https://www.youtube.com/watch?v=5705VFJmku0 -~-~~-~~~-~~-~-
Views: 73 Solution Wizard
ORACLE SQL- 8. double ampersand
 
04:13
insead of repeating the same value always we can make it as a fixed value using double ampersand
Views: 1096 Ban3 GaiN
SAP HANA Academy - HANA SQL: Boolean Data Type
 
03:59
*** Important: please read this for prerequisites and links to code. In this video we'll look at the Boolean data type in SAP HANA. The three possible values of this data type are TRUE, FALSE and UNKNOWN, where UNKNOWN is the NULL equivalent for the Boolean type. The syntax used in this video is here: https://github.com/saphanaacademy/SQL/blob/master/BOOLEAN%20Data%20Type
Views: 4382 SAP HANA Academy
SQL 038 Data Types, Boolean Data, Compare Database Usage
 
01:27
Explains boolean data types with a comparison of usage by the major databases. From http://ComputerBasedTrainingInc.com SQL Course. Learn by doing SQL commands for ANSI Standard SQL, Access, DB2, MySQL, Oracle, PostgreSQL, and SQL Server.
Views: 1164 cbtinc
[FA] Boolean based SQL Injection step by step [pentesterschool.ir]
 
16:45
permalink : https://www.pentesterschool.ir/courses/web-security-course/05-boolean-based-blind-sql-injection-exploitation
Views: 667 Pentester School
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: 9073 Caleb Curry
Boolean Data Type
 
06:24
Views: 486 JHIGH Teacher
Curso de ORacle PL/SQL 12c- Cap7.Booleans
 
02:55
Puedes hacer el curso completo en este enlace por solo 10$, un gran descuento del precio oficial de 50$ https://www.udemy.com/aprende-oracle-plsql-12c-desde-cero/?couponCode=PROMO-PL 121 clases 8,5 horas de vídeo Múltiples prácticas y ejemplos ¡¡¡Con una máquina virtual ya preparada para trabajar¡¡¡. Aunque durante el curso veremos como instalarlo, para aquellos que queráis ir directamente al grano, hemos creado una máquina virtual en Fedora para que empezeis a trabajar desde el minuto 1.¡¡¡¡Con máquinas virtuales preparadas para el curso!!!! Como ya sabrás, PL/SQL es el lenguaje de desarrollo de Oracle y por tanto uno de los más demandados a nivel laboral en estos momentos. El curso es eminentemente práctico. Mediante ejemplos y ejercicios iremos viendo las características del lenguaje y como puedes utilizarlo. Hay una gran cantidad de prácticas para ayudarte a entender todos los conceptos No necesitas grandes conocimientos, más allá de saber algo de programación y de SQL. Comenzaremos por lo más básicos e iremos profundizando en los distintos capítulos que conforman el curso Aprovecha esta oportunidad
Views: 251 Apasoft Training
Data Type in PL/SQL | Part - 04 | In Hindi by Tech Talk Tricks
 
04:43
Welcome to techtalktricks and in this video, we will learn different - different data type of pl/sql.So stay tuned and watch data type of pl/sql like scalar data type(Numeric,boolean,char etc) #TechTalkTricks #RanaSingh SUBSCRIBE our channel at : https://www.youtube.com/techtalktricks ************************************************** Follow Tech Talk Trick on Facebook https://www.facebook.com/techtalktricks ************************************************** Follow tech talk trick on Twitter https://twitter.com/tecktalktrick ************************************************** Follow Tech Talk Tricks on Instagram https://www.instagram.com/techtalktricks ************************************************** Subscribe tech talk tricks on YouTube https://www.youtube.com/techtalktricks *************************************************** Channel tag : techtalktricks, tech talk tricks html, css, java, sql, computer tricks,
Views: 2310 TechTalkTricks
SQL AND/OR Operator with Example in Oracle 11g Database
 
09:56
SQL Tutorial for Beginners in Hindi and English SQL AND/OR Operator with Example in Oracle 11g Database
Learning SQL Tutorial - Part 12 -- Where Clause -- Boolean Logic with OR and NOT
 
05:01
http://www.essentialsql.com/get-ready-to-learn-sql-4-query-results-using-boolean-logic Use the Where Clause to filter your search results. In this video we cover Boolean logic, specifically how you can use the AND clause to string together multiple conditions.
Views: 694 Kris Wenzel
21- What Is Boolean Data Types In Scalar Data Types In Programming Languages In HINDI
 
05:50
What Is Boolean Data Types In Scalar Data Types In Programming Languages In HINDI: Scalar Data Types: Boolean in programming language: The Boolean data type is a data type, having two values(usually denoted true or false), intended to represent the truth values of logic and Boolean algebra. Website: http://www.tutorialsspace.com 19- Floating Point | Numeric Data Type- Floating Point in Programming Languages https://youtu.be/MIWU-QU0IQA 20- What is Enumeration | Scalar Data Type - Enumeration in Programming Languages https://youtu.be/AsuZ22J0WUM Instagram https://www.instagram.com/tutorialsspace/
Views: 636 tutorialsspace
PL/SQL tutorial 12: PL/SQL WHILE Loop in Oracle Database
 
06:33
Iterative statements/loop series learn the concepts of While Loop in PL/SQL or In Oracle Database with Examples. also learn how to handle boolean expression in while loop ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/while-loop-in-pl-sql Previous Tutorial ► Simple Loop: https://youtu.be/AFx6QYcY1CU ------------------------------------------------------------------------- ►►►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: 63727 Manish Sharma
PL SQL Case Statement | PL SQL Beginner Tutorials
 
05:56
Subscribe to stay connected https://www.youtube.com/channel/UC7sbHUgN8FnJEZkEjvKTwJg Like the IF statement, the CASE statement selects one sequence of statements to execute. However, to select the sequence, the CASE statement uses a selector rather than multiple Boolean expressions. A selector is an expression, whose value is used to select one of several alternatives.
Views: 92 Puzzle Guru
SQL Datatype: number, character, varchar, date, Boolean
 
03:53
Examples for SQL Datatype in sequence as mentioned above: 1.Contact into 2. Char (6) 3. Varchar (6) 4.'22-jan-2019'
Views: 7 sushant
004 char, boolean data types
 
07:31
My forum http://ankitbdesai.blogspot.in/ Ask me all questions there as well as view source code for the tutorials are coming soon!
Views: 156 Desai Ankit
Boolean Data Type Example
 
01:26
Boolean Data type Example
Views: 413 Trisect
Learning SQL Tutorial - Part 13 -- Where Clause -- Boolean Logic Order of Operations
 
09:31
http://www.essentialsql.com/get-ready-to-learn-sql-4-query-results-using-boolean-logic Use the Where Clause to filter your search results. In this video we cover Boolean logic, specifically what order AND and OR are evaluated and how you can use parenthesis to assist.
Views: 721 Kris Wenzel
05 Subtypes in PL SQL
 
03:55
Oracle PL/SQL Tutorial - A Comprehensive Training Course https://www.youtube.com/channel/UCXLir0qvG4xDmgLtGZBd8qg
Views: 512 Satyam Rai
Oracle Core, Лекция 5
 
53:46
Ссылка на файл с презентацией: https://docs.google.com/presentation/d/1xANFkC3tkFdby_HIFEEwtqInJqKlgx4ykiIbarK1EPE/edit?usp=sharing (презентация может быть с анимацией) Ссылка на краткий конспект лекции: https://docs.google.com/document/d/1x80R-XlWBI_zFzNN2JMmby2wIvBb7jnfshn9axNXEKs/edit?usp=sharing 1. Общие сведения, история возникновения PL/SQL 2. Среда исполнения 3. Структура PL/SQL блока (declare, begin, exception, end). Именованные/неименованные (анонимные) блоки pl/sql. Вложенные блоки pl/sql 4. Набор разрешенных символов. Требования к именованию идентификаторов. Представление v$reserved_words 5. Арифметические операторы. Логические операторы отношения. 6. Комментарии и метки 7. Основные типы и структуры данных (скалярный, составной, ссылка, lob) 8. Значение null 9. Числовые типы: Number, Number(n), Number(n, m), Pls_Integer/Binary_Integer, Binary_Float, Binary_Double, Natural, Naturaln, Positive, Positiven, Signtype, Simple_Integer, Simple_Float, Simple_Double) 10. Строковые типы: Char, Varchar2, NChar, NVarchar2, Raw, Long, Long Raw 11. Rowid и Urowid 12. Операции со строками. Взаимодействие строк со значением Null 13. Типы для моментов и интервалов времени: Date, Timestamp, Interval. Возможные операции 14. Тип Boolean 15. Типы Lob: BFile, BLob, CLob, NCLob 16. Объявление переменных и констант 17. Составные и динамические типы: Record, %RowType, %Type 18. Пользовательские подтипы Subtype 19. Выражения 20. Функции для работы с NULL: Decode, Nvl, Nvl2, Coalesce 21. Преобразование типов явное и неявное. 22. Таблица неявного преобразования типов. 23. Таблица явного преобразования типов 24. Основные управляющие структуры 25. Конструкция IF...THEN..ELSIF...ELSE 26. Конструкция выбора по условию CASE (простой и с поиском) 27. Циклы Loop... end loop, While loop, For loop, цикл по курсору 28. Оператор Goto Oracle Database, БД Oracle, вебинар Oracle, презентация Oracle, урок Oracle, лекция Oracle, обучение Oracle
Data Types and Conversion Functions (Introduction to Oracle SQL)
 
05:24
Find out about different data types and how to convert between them. The full Introduction to Oracle SQL course is available here: https://www.databasestar.com/introduction-to-oracle-sql-course/
Views: 186 Database Star
CREATE Command (DDL) in SQL with Implementation on ORACLE
 
10:57
#SQL#implementation#DDLCommands ► Link for All Types of SQL Commands (DDL, DML, DCL, TCL): https://www.youtube.com/watch?v=vUj-kUEC_oA ► Link for Computer Networks Playlist- https://www.youtube.com/playlist?list=PLxCzCOWd7aiGFBD2-2joCpWOLUrDLvVV_ ► Link for Operating System Playlist- https://www.youtube.com/playlist?list=PLxCzCOWd7aiGz9donHRrE9I3Mwn6XdP8p ► Link for Database Management System Playlist- https://www.youtube.com/playlist?list=PLxCzCOWd7aiFAN6I8CuViBuCdJgiOkT2Y ► Link for Graph Theory Playlist- https://www.youtube.com/playlist?list=PLxCzCOWd7aiG0M5FqjyoqB20Edk0tyzVt ► Last Minutes Preparation for UGC NET and GATE Playlist- https://www.youtube.com/playlist?list=PLxCzCOWd7aiE4LQMkIhAe9amWX_SPNMiZ ------------------------------------------------------------------------------------------------- Our Social Links: ► Subscribe to our YouTube channel: https://www.youtube.com/gatesmashers ► Like Our page on Facebook - https://www.facebook.com/gatesmashers/ ► For any Query and Suggestions- [email protected]
Views: 1951 Gate Smashers
5.1 Boolean Data Type (Hindi)
 
01:43
PHP in different type data type that including boolean data type. This data type holds two values TRUE and FALSE.
Views: 117 TechnicalSolution
MSSQL -  Fix Error  - Column, parameter, or variable Cannot find data type BOOL
 
00:08
Fix the following error Column, parameter, or variable #7: Cannot find data type BOOL. More info http://howtodomssqlcsharpexcelaccess.blogspot.ca/2017/12/mssql-fix-error-column-parameter-or.html
Views: 657 Vis Dotnet
oracle plsql | oracle plsql training | oracle sql and pl sql
 
01:16
oracle plsql is an Oracle Corporation's procedural extension for SQL and the Oracle relational database. we offer best Oracle SQL course with advanced syllubus For More Information You Can Contact Us @: Mail id: [email protected] phone: + 91 8121 020 111 Oracle plsql Course Content • Introduction to the PL/SQL • Understanding the benefits & structure of PL/SQL • Examining PL/SQL Blocks • Generating output messages in PL/SQL • Declaring the PL/SQL Variables • Identify valid & invalid identifiers • Declare & initialize variables • List & describe various data types • Identify the benefits of using the %TYPE attribute • Declare, use, & print bind variables • Writing the Executable Statements List Lexical Units in a PL/SQL Block • Use SQL Functions in PL/SQL • Use the Data Type Conversion • Use the Nested Blocks as Statements • Reference an Identifier Value in a Nested Block • Qualify an Identifier with a Label • Use the Operators in PL/SQL • Using Sequences in PL/SQL Expressions • Using the SQL Statements within a PL/SQL Block • Identify & use the SQL Statements in PL/SQL • Retrieve Data in PL/SQL with the SELECT statement • Avoid Errors by the Using Naming Conventions When Using Retrieval & DML Statements • Manipulate Data in the Server Using PL/SQL The SQL Cursor concept • Use the SQL Cursor Attributes to Obtain Feedback on DML • Save & Discard Transactions • Writing the Control Structures • Control PL/SQL Flow of Execution • Conditional processing Using IF & CASE Statements • Handle Nulls to Avoid Common Mistakes • Build Boolean Conditions with Logical Operators • Use Iterative Control with the Looping Statements • Working with Composite Data Types • Learn the Composite Data Types of PL/SQL Records & Tables • Use PL/SQL Records to Hold Multiple Values of Different Type • Inserting & Updating with PL/SQL Records • Use INDEX BY Tables to Hold the Multiple Values of the Same Data Type • Using Explicit Cursors • Define Cursors • Explain the Explicit Cursor Operations • Controlling Explicit Cursors • Use Explicit Cursors to Process Rows • Cursors & Records • Cursor FOR Loops Using Sub queries • Explicit Cursor Attributes • The %NOTFOUND & %ROWCOUNT Attributes • Handling Exceptions • Define the Exception • Handling Exceptions with PL/SQL • Predefined Exceptions • Trapping Predefined & the Non-predefined Oracle Server Errors • Functions that Return Information on Encountered Exceptions • Trapping User-Defined Exceptions • Propagate Exceptions • Basic RAISE Statement • Creating Stored Procedures & Functions • Overview of Stored Procedures & Functions • Differentiate between anonymous blocks & subprograms • Show the CREATE OR REPLACE PROCEDURE | FUNCTION • Understand the Header Area of a Stored Procedure & Function • Create Simple Procedures &
Views: 122 Oracle Trainings
SQL 036 Data Types, Character String Data, CLOB or Character Large OBject
 
01:33
Explains the SQL CLOB or Character Large OBject data type. From http://ComputerBasedTrainingInc.com SQL Course. Learn by doing SQL commands for ANSI Standard SQL, Access, DB2, MySQL, Oracle, PostgreSQL, and SQL Server.
Views: 1263 cbtinc
SAP HANA Academy - HANA SQL: Array Data Type
 
04:26
*** Important: please read this for prerequisites and links to code. In this video we'll look at the Array data type in SAP HANA. The array is a multi value type where each array member has an ordinal position. The syntax used in this video is here: https://github.com/saphanaacademy/SQL/blob/master/ARRAY%20Data%20Type
Views: 5636 SAP HANA Academy
Oracle 10g PL SQL اوراكل - تعليم اوراكل - مقدمة للغات البرمجة
 
04:54
Oracle 10g PL SQL اوراكل - تعليم اوراكل - مقدمة للغات البرمجة http://egylearn.com/learn-oracle-10g/ تعليم اوراكل العرب تعلم بي ال اس كيو ال pl sql سوف نتعرف علي لغة البرمجة بي ال اس كيو ال الخاصة ببرنامج أوراكل 10 جي ولغة بي ال اس كيو ال تستخدم لإنشاء تطبيقات قواعد البيانات والوصول إلى بيانات قواعد البيانات ومعالجتها والتفاعل مع خادم قواعد البيانات, تنسيق نتائج الاستعلامات, التعرف على أنواع البيانات, المؤشرات والمفاهيم المتقدمة للمؤشرات التصريحية, معالجة الاستثناءات, إنشاء الإجراءات, إنشاء الوظائف, إدارة البرامج الفرعية, إنشاء أنواع أخرى من التقارير واستخدام وظائف المجموعة البرمجية في الكود PL/SQL مقدمة للغة مقدمة للغات البرمجة مقدمة عن لغة البرمجة PL/SQL مزايا استخدام اللغة PL/SQL القوالب PL/SQL Blocks تركيبات البرامج Program Constructs قواعد كتابة الكود في اللغة PL/SQL تعريف المتغيرات وأنواع البيانات إرشادات عامة لتعريف المتغيرات Variables أنواع البيانات Data Types أنواع البيانات Scalar Data Types -1 أنواع البيانات Scalar Data Types -2 تعريف المتغيرات Declaring Variables استخدام الخاصية %TYPE المتغيرات Bind Variables Executable Section القسم التفاعل مع القسم Execution Section استخدام الدوال SQL Functions معالجة البيانات باستخدام المعاملات Operators القوالب المتداخلة ومجال استخدام المتغيرات إرشادات عامة التفاعل مع خادم قواعد البيانات استرجاع البيانات باستخدام الجملة SELECT معالجة البيانات باستخدام الجمل DML Statements تعديل البيانات باستخدام الجملة UPDATE حذف الصفوف باستخدام الجملة DELETE استخدام الجملة Merge المؤشرات Cursors استخدام الجمل Transaction control Control structure جمل التحكم الجمل الشرطية الجملة الشرطية I f ...... Then ...... Else الجمل IF المتداخلة الجملة الشرطية CASE المعاملات المنطقية Complex Boolean Conditions الحلقات التكرارية LOOP Statements الحلقات التكرارية WHILE-LOOP الحلقات التكرارية FOR-LOOP تنسيق نتائج الاستعلامات تنسيق النتائج وإنشاء التقارير (1) تنسيق النتائج وإنشاء التقارير (2) تقسيم النتائج لمجموعات وإجراء العمليات الحسابية إضافة رأس وتزيل الصفحة حفظ التقارير وحذف التنسيقات إنشاء التقارير باستخدام الملفات Scripts Composite أنواع البيانات اأنواع البيانات المركبة Composite Datatypes استخدام الخاصية ROWTYPE% نوع البيانات INDEX by Table مثال على استخدام نوع البيانات Index by Table الوظائف INDEX by Table Methods استخدام الخاصية %ROWTYPE مع INDEX BY table Explicit cursors المؤشرات مقدمة عن المؤشرات Cursors إنشاء وفتح المؤشرات استخلاص البيانات من المؤشرات إغلاق المؤشرات خصائص المؤشرات Cursors Attributes استخدام المتغيرات Records مع المؤشرات Cursors الحلقات التكرارية Cursor FOR-LOOPS قائمة فيديو برنامج تعليم اوراكل http://www.youtube.com/playlist?list=PLF64D8B7C745CE505 الصفحة الرئيسية للبرنامج http://egylearn.com/learn-oracle-10g/ المصرية للبرمجيات التعليمية - ايجي ليرن المبيعات : مصر - 39124762(202) - 01226809015(002) أتصل الآن http://egylearn.com http://www.youtube.com/egylearn http://www.facebook.com/egylearn http://twitter.com/egylearn
SQL 048 Data Types, BLOB Compare Database Usage
 
02:22
Explains the data type BLOB or Binary Large Object. From http://ComputerBasedTrainingInc.com SQL Course. Learn by doing SQL commands for ANSI Standard SQL, Access, DB2, MySQL, Oracle, PostgreSQL, and SQL Server.
Views: 2412 cbtinc
Oracle Tutorial - Logical Operator | AND OR NOT Operators
 
10:06
Oracle Tutorials - Logical Operators | AND OR NOT Operators
Views: 187 Tech Acad
Learn MySQL In Arabic #05 - Data Type - Numeric
 
20:01
Learn about The Numeric Data Type in MySQL with Examples Int TinyInt SmallInt MediumInt BigInt Float Decimal Real BIt Boolean
Views: 21125 Elzero Web School
Tutorial 53 : NESTED TABLE || Collections in PL SQL
 
09:10
Hi Friends, Here we are learning about NESTED TABLE, Collection in PL SQL. Hope the concept and example would be clear to you. For any confusion or doubt, let me know in comment box. Link (Introduction to Collection in PL SQL || Nested Tables || VARRAYs || Associative Arrays) : https://youtu.be/2giFZeEQqXY Link (User Defined Exception || RAISE_APPLICATIN_ERROR || SQLERRM) : https://youtu.be/RTq8VK7Vodw Link (Application from where you can get all code detail and example) : https://apex.oracle.com/pls/apex/f?p=ysc About Me : https://about.me/saurabhsagarsinha Thanks, Happy Coding.
Views: 331 YourSmartCode
How Many Different Values Can be Stored in Bit Data Type - SQL Server Tutorial
 
07:59
Bit is integer data type that can store 0,1 or Null. Bit take One byte ( 8 Bits) in memory to store these values for us. We often use this data type for the columns where we want to show if the record is active or In- Active. You can call those type of columns as status columns/ Flag Columns etc. As we know that bit can store only three possible values but when it comes to inserting that values it is Bit confusing. If you will insert 'TRUE' , It will take that as 1. If you will insert 'False', SQL Server will translate that to 0. There are more confusing part to it;) Watch the video and you will see what I am talking about BIT Data type in SQL Server. Blog post with scripts for this video: http://sqlage.blogspot.com/2015/03/how-many-different-values-can-be-stored.html
Views: 4154 TechBrothersIT
PL SQL 2   Databases and transactional applications
 
06:27
https://drive.google.com/file/d/0BxYoN5rLDBaRMUJuMWs0c1ZrbVU/edit?usp=sharing Course Objectives Variable declaration (again) operators Conversions of data types Nested blocks and variable scope Control Structures Example 1 DECLARE hours_worked INTEGER := 40; employee_count INTEGER := 0; pi CONSTANT REAL := 3.14159; radius REAL := 1; area REAL := (pi * radius**2); BEGIN NULL; END; --------------------------------- Exampl 2 SET SERVEROUTPUT ON DECLARE counter INTEGER; -- initial value is NULL by default BEGIN counter := counter + 1; -- NULL + 1 is still NULL IF counter IS NULL THEN DBMS_OUTPUT.PUT_LINE('counter is NULL'); END IF; END; --------------------------------- Example 3 DECLARE acct_id INTEGER(4) NOT NULL := 9999; a NATURALN := 9999; b POSITIVEN := 9999; c SIMPLE_INTEGER := 9999; BEGIN NULL; END; --------------------------------- Example 4 DECLARE null_string VARCHAR2(80) := TO_CHAR(''); address VARCHAR2(80); zip_code VARCHAR2(80) := SUBSTR(address,25,0); name VARCHAR2(80); valid BOOLEAN := (name != ''); BEGIN DBMS_OUTPUT.PUT_LINE('null_string is'||null_string); IF valid is null THEN DBMS_OUTPUT.PUT_LINE('name is NULL, not ""'); END IF; END; --------------------------------- Example 5 SET SERVEROUTPUT ON DECLARE name VARCHAR(25) NOT NULL := 'Smith'; surname name%TYPE := 'Jones'; BEGIN DBMS_OUTPUT.PUT_LINE('name=' || name); DBMS_OUTPUT.PUT_LINE('surname=' || surname); END; ---------------------------------- Example 6 BEGIN DBMS_OUTPUT.PUT_LINE ('Today is '||'&sv_day'); DBMS_OUTPUT.PUT_LINE ('Tomorrow will be '||'&sv_day'); END; Example 7 ---------------------------------- BEGIN DBMS_OUTPUT.PUT_LINE ('Today is '||'&&sv_day'); DBMS_OUTPUT.PUT_LINE ('The same day is '||'&sv_day'); END; ----------------------------------- Example 8 DECLARE a INTEGER := 2**2*3**2; BEGIN DBMS_OUTPUT.PUT_LINE('a = ' || TO_CHAR(a)); END; ---------------------------------- Example 9 SET SERVEROUTPUT ON -- outer_block DECLARE v_test NUMBER := 123; BEGIN DBMS_OUTPUT.PUT_LINE('Outer Block, v_test: '||v_test); -- inner_block DECLARE v_test NUMBER := 456; BEGIN DBMS_OUTPUT.PUT_LINE('Inner Block, v_test: '||v_test); DBMS_OUTPUT.PUT_LINE('In inner Block, ?outer_block.v_test is: '|| outer_block.v_test); END inner_block; ---------------------------------- Example 10 DECLARE v_num NUMBER := &sv_user_num; BEGIN IF MOD(v_num,2) = 0 THEN DBMS_OUTPUT.PUT_LINE (v_num|| ' is even number'); ELSE DBMS_OUTPUT.PUT_LINE (v_num||' is odd number'); END IF; DBMS_OUTPUT.PUT_LINE ('Done'); END; ---------------------------------- Example 11 SET SERVEROUTPUT ON DECLARE x NUMBER := 5; y NUMBER := NULL; BEGIN IF x != y THEN DBMS_OUTPUT.PUT_LINE('x != y'); ELSIF x = y THEN DBMS_OUTPUT.PUT_LINE('x = y'); ELSE DBMS_OUTPUT.PUT_LINE('impossible to define if = or not'); END IF; END; ---------------------------------- Example 12 SET SERVEROUTPUT ON DECLARE a NUMBER := NULL; b NUMBER := NULL; BEGIN IF a = b THEN DBMS_OUTPUT.PUT_LINE('a = b'); ELSIF a != b THEN DBMS_OUTPUT.PUT_LINE('a != b'); ELSE DBMS_OUTPUT.PUT_LINE('umm, it is not known'); END IF; END; ---------------------------------- Example 13 DECLARE x INTEGER := 2; y INTEGER := 5; high INTEGER; BEGIN IF (x mayor y) THEN high := x; ELSE high := y; END IF; IF NOT (x menor y) THEN high := y; ELSE high := x; END IF; DBMS_OUTPUT.PUT_LINE('high is: '||to_char(high)); END; ---------------------------------- Example 14 DECLARE grade CHAR(1); -- NULL by default appraisal VARCHAR2(20); BEGIN appraisal := CASE grade WHEN NULL THEN 'No grade assigned' WHEN 'A' THEN 'Excellent' WHEN 'B' THEN 'Very Good' WHEN 'C' THEN 'Good' WHEN 'D' THEN 'Fair' WHEN 'F' THEN 'Poor' ELSE 'No such grade' END; DBMS_OUTPUT.PUT_LINE ('Grade '||grade||' is '||appraisal); END; ---------------------------------- Example 15 DECLARE grade CHAR(1); -- NULL by default appraisal VARCHAR2(20); BEGIN appraisal := CASE WHEN grade IS NULL THEN 'No grade assigned' WHEN grade = 'A' THEN 'Excellent' WHEN grade = 'B' THEN 'Very Good' WHEN grade = 'C' THEN 'Good' WHEN grade = 'D' THEN 'Fair' WHEN grade = 'F' THEN 'Poor' ELSE 'No such grade' END; DBMS_OUTPUT.PUT_LINE ('Grade ' || grade || ' is ' || appraisal); END;
Views: 210 Fdo Luis
22- What Is Characters In Scalar Data Types In Programming Languages In HINDI | Scalar Data Types
 
08:10
What Is Characters In Scalar Data Types In Programming Languages In HINDI : A character data type provides data objects that have a single character as their value. website: http://www.tutorialsspace.com 20- What is Enumeration | Scalar Data Type - Enumeration in Programming Languages https://youtu.be/AsuZ22J0WUM 21- Boolean Data Types | Scalar Data Type - Boolean in Programming Languages https://youtu.be/elHrH7KXyBU Instagram https://www.instagram.com/tutorialsspace/
Views: 595 tutorialsspace
MySQL 25 - CHAR Data Type
 
04:47
The first category of data types that we are going to cover in this MySQL series are the string data types, or character data types. There are two that I am going to talk about in this video, CHAR and VARCHAR. We'll start with CHAR. CHAR is a string data type where you specify how many characters are allowed in parenthesis after you declare the column as this type. For example, we can say CHAR(50) to allow up to 50 characters for each value in that column. The thing to know about CHAR though is that it is a fixed-length string. That means every single value inside of that column is actually going to be whatever you declare the length as. So if you say CHAR(50), every string is going to be 50 characters long. If, for example, you have a row that only uses 40 characters, MySQL will pad the right side of the string with spaces until it fills 50 characters. Now, the highest value you can put in here is 255. The 255 refers to characters. This means that you can have strings with up to 255 characters. How does the computer know how to store these characters? That has to deal with the character set and the encoding of the characters. By default, MySQL is going to use UTF-8. We are not going to discuss UTF-8 in detail for a while but essentially UTF-8 says that each character can take up to 3 bytes of storage. 255 comes from the max number you can count to using binary. So if we are keeping track of how many values are in this column in an 8 bit number, 255 is the highest. If you don't know what I'm talking about it, we'll worry about it later. You can actually make the column CHAR(0). In this situation, the only thing you could put in as a value for this column is an empty string (''). When retrieving variable length CHAR data from a database it may not look like the database pads the value. That's because MySQL actually strips spaces from the value when presented. If you want to keep all of the spaces that have been added when you retrieve the value, you can do that. Look up PAD_CHAR_TO_FULL_LENGTH online. In the next video we are going to discuss VARCHAR. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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: 5252 Caleb Curry
Oracle SQL 3
 
15:33
Views: 500 khaled ahmed