Home
Search results “If exists object oracle”
CHECKING IF EXISTS IN SQL SERVER
 
13:39
This video for the beginner of SQL server programmer who are not fully understand how to checking if data exists do the correct condition and if data not exists do other transaction
Views: 13394 Sourn Sarim
ORACLE SQL AND PL/SQL INTERVIEW QUESTION : SUBQUERY WITH NULL / NOT IN / NOT EXISTS OR OUTER JOIN
 
08:36
This video demonstrates the oracle sql interview question where one need to use either not in, not exists or an outer join to get the desired result. For example if one is asked to fetch records from department table where department_id is not present in employee table
Views: 1796 Kishan Mashru
Java & MySQL - Check if a value already exists
 
12:03
Easy tutorial on how to check if a value already exists in the database.
Views: 25491 Mozoran
SQL Error ORA-00942 Table or View Does Not Exist in Oracle Database
 
05:03
How to use Tab View (Data Dictionary) of Oracle Database to solve the SQL Error ORA-00942 Table or View Does Not Exist error in Oracle Database ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/ora-00942 Previous Tutorial ► ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! ------------------------------------------------------------------------- ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ ___Facebook Official Page of Manish Sharma___ https://www.facebook.com/TheRebellionRider/ ___Facebook Official Page of RebellionRider.com___ https://www.facebook.com/RebellionRider.official/ You can also Email me at for E-mail address please check the About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 5403 Manish Sharma
Oracle EMPTY_BLOB Function
 
01:58
https://www.databasestar.com/oracle-lob-functions/ The Oracle EMPTY_BLOB function is used to initialise a LOB column to an empty value. You can use it in an INSERT statement, an UPDATE statement, or with a variable in PL/SQL. The syntax of the EMPTY_BLOB function is: EMPTY_BLOB That’s it - no parameters. Why would you set a BLOB value to empty? It means you have initialised it but not given it a value. It’s good to know this function exists if you ever need to use it. For more information about the Oracle EMPTY_BLOB function, including all of the SQL shown in this video and the examples, read the related article here: https://www.databasestar.com/oracle-lob-functions/
Views: 63 Database Star
Entity Relationship Diagram (ERD) Tutorial - Part 1
 
06:58
Learn how to create an Entity Relationship Diagram in this tutorial. We provide a basic overview of ERDs and then gives step-by-step training on how to make an ER diagram with correct cardinality. Entity Relationship Diagrams are comprised of 3 main categories: entities, attributes, and relationships. Entities are objects or concepts that are associated with important data—like a customer, order, or product. Attributes represent properties or traits of an entity, such as a customer’s phone number or home address. Relationships demonstrate the link between entities. Another main aspect of of ERD's is cardinality, which further defines the relationship between entities in a numerical way. Certain symbols signify the minimum and maximum relationship between different entities. Additional ERD information: https://www.lucidchart.com/pages/entity-relationship-diagram-tutorial —— Learn more and sign up: https://www.lucidchart.com/users/register Follow us: Facebook: https://www.facebook.com/lucidchart Twitter: https://twitter.com/lucidchart Instagram: https://www.instagram.com/lucidchart LinkedIn: https://www.linkedin.com/company/lucidsoftware
Views: 480135 Lucidchart
SQL IF EXISTS in IBM i RPG Language
 
05:11
This video is about SQL IF EXISTS capabilities within the IBM i RPGIV Language
Views: 170 Bob Cozzi
DYNAMIC SQL WITH EXECUTE IMMEDIATE IN ORACLE PL/SQL WITH EXAMPLE
 
21:53
The audio and video now synced. Ever tried creating a table inside a PL SQL block, or a function or a procedure? If yes, then you would know that it would raise an error, as DDL statements are not allowed inside a PL/SQL Block. So the solution to such a case, where you want to generate tables, or sequences or want to execute any DDL statement on the fly, then use synamic sql. Dynamic SQL statment will allow you to create state statements on the fly and then you can execute them using the execute immediate statement. This video tutorial demonstrates on this topic of using synamic sql with execute immediate in a PL/SQL block.
Views: 4514 Kishan Mashru
Oracle sql and pl/sql Interview question : Difference between %type and %rowtype in oracle pl/sql
 
11:37
This video tutorial explains the usage of %type variable declaration and %rowtype variable declaration. It also states the advantages of using %type and %rowtype variable declaration. At the end the viewes can easily identify the difference between %type and %rowtype variable declaration If you want more such videos of exciting and amazing 'difference between' concepts, check out the links below : char and varchar2 : https://youtu.be/039qzwjWf4k 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
Views: 511 Kishan Mashru
Writing re runnable sql server scripts   Part 66
 
10:37
Text version of the video http://csharp-video-tutorials.blogspot.com/2013/06/writing-re-runnable-sql-server-scripts.html Slides http://csharp-video-tutorials.blogspot.com/2013/09/part-66-writing-re-runnable-sql-server.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists What is a re-runnable sql script? A re-runnable script is a script, that, when run more than, once will not throw errors. Let's understand writing re-runnable sql scripts with an example. To create a table tblEmployee in Sample database, we will write the following CREATE TABLE sql script. USE [Sample] Create table tblEmployee ( ID int identity primary key, Name nvarchar(100), Gender nvarchar(10), DateOfBirth DateTime ) When you run this script once, the table tblEmployee gets created without any errors. If you run the script again, you will get an error - There is already an object named 'tblEmployee' in the database. To make this script re-runnable 1. Check for the existence of the table 2. Create the table if it does not exist 3. Else print a message stating, the table already exists Use [Sample] If not exists (select * from information_schema.tables where table_name = 'tblEmployee') Begin Create table tblEmployee ( ID int identity primary key, Name nvarchar(100), Gender nvarchar(10), DateOfBirth DateTime ) Print 'Table tblEmployee successfully created' End Else Begin Print 'Table tblEmployee already exists' End The above script is re-runnable, and can be run any number of times. If the table is not already created, the script will create the table, else you will get a message stating - The table already exists. You will never get a sql script error. Sql server built-in function OBJECT_ID(), can also be used to check for the existence of the table IF OBJECT_ID('tblEmployee') IS NULL Begin -- Create Table Script Print 'Table tblEmployee created' End Else Begin Print 'Table tblEmployee already exists' End Depending on what we are trying to achieve, sometime we may need to drop (if the table already exists) and re-create it. The sql script below, does exactly the same thing. Use [Sample] IF OBJECT_ID('tblEmployee') IS NOT NULL Begin Drop Table tblEmployee End Create table tblEmployee ( ID int identity primary key, Name nvarchar(100), Gender nvarchar(10), DateOfBirth DateTime ) Let's look at another example. The following sql script adds column "EmailAddress" to table tblEmployee. This script is not re-runnable because, if the column exists we get a script error. Use [Sample] ALTER TABLE tblEmployee ADD EmailAddress nvarchar(50) To make this script re-runnable, check for the column existence Use [Sample] if not exists(Select * from INFORMATION_SCHEMA.COLUMNS where COLUMN_NAME='EmailAddress' and TABLE_NAME = 'tblEmployee' and TABLE_SCHEMA='dbo') Begin ALTER TABLE tblEmployee ADD EmailAddress nvarchar(50) End Else BEgin Print 'Column EmailAddress already exists' End Col_length() function can also be used to check for the existence of a column If col_length('tblEmployee','EmailAddress') is not null Begin Print 'Column already exists' End Else Begin Print 'Column does not exist' End
Views: 62644 kudvenkat
Check Last Modified DateTime for An Object (Table,Stored Procedure,Trigger etc.) in SQL Server
 
04:23
We as SQL Server developers send our DDL Scripts ( Add New Column, Drop some column from table, or Alter Stored Procedure) to DBA. After deployment we verify those changes and sometime it happens that the changes are not done. Maybe DBA has missed one of the script to run. If we can get the last modified date for object ( Table,Stored Procedure, View etc) that can confirm the changes are done on given date. blog post link for scripts used in this video http://sqlage.blogspot.com/2014/01/tsql-how-to-check-when-object-table.html
Views: 6744 TechBrothersIT
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: 168801 Manish Sharma
How To Check If Column Exists for a Table Or View in Database in SQL Server - SQL Server Tutorial
 
03:10
On daily basis, we come across this scenario when we have to find out if a column exists for a Table or View in Database. Specially if we are debugging SQL Server Reports/An application, we take a column name or part of it and want to know that from which table this column is used. We can query INFORMATION_SCHEMA.COLUMNS view to get this information. blog post link for scripts used in this video http://sqlage.blogspot.com/2014/01/tsql-how-to-check-if-column-exists-for.html
Views: 4780 TechBrothersIT
Oracle 12c Database New Features - Pluggable Database - Video 1
 
17:25
Oracle 12c Database New Features - Pluggable Database - Video 1 1. Pluggable Database * Oracle 12c introduces a new feature called 'Pluggable Database'. Here Oracle Metadata and user data are totally separated into two sections. One is Container DB (or CDB) which will hold Oracle Metadata. The other is Pluggable DB (or PDB) which will hold user data. How does a Pluggable Database work? In the regular database, Oracle's metadata and user's application data are integrated. For beginners, Oracle Metadata is the data that is present when you install a new Oracle Database (without any sample schemas). Even though it can be called as an empty database, it still has data provided by Oracle. This data is needed by the database to function. For example, the objects owned by SYS, SYSTEM are mostly metadata. Then user data is entered into that database. They will go under multiple user schemas. Now the database is being used by the users. Now a situation arises so that we need to create another database on the same server. Why? Let us say that you need to provide data to two clients. And you don't want one client to other's data. And your data is contained in an extensive set of application schemas. In this case, making a copy of those applications schemas into a different set of names and making them reside in the same database is very difficult. So, you provide two separate databases. This also ensures that there is no security violation. So, we install another new database, which comes with Oracle Metadata. Then we load the user data. In this method, which is currently being used (Year 2013), there will be a need for more memory for both the database instances. There will be two SGAs, two sets of smon, pmon and other background processes running. Then if we need to copy one database to another, we need to rely on extensive procedures which includes exporting the data from the source database first, then removing the data at the target and then finally loading the data in there. After that, we need to take care of the user security and object privileges etc. So, if you want to provide data for multiple tenants, that is multiple clients, then with the current set of features (till Oracle 11g), we have to create multiple databases. That is, one database for one client. In otherwords, there is no multi-tenancy. Multi-Tenancy is becoming an important requirement in cloud infrastructure, these days. You would like to have the ability of providing data to multiple clients from the same database system with full confidence in security. This can be achieved in Pluggable Database. In a Pluggable Database, Oracle basically separates its metadata entirely from the user data. Metadata is stored in a section called Container DB. Then the user data are stored in Pluggable DBs. It also stores user metadata in the Pluggable DB. By the way, what is user metadata? For example, earlier, the list of user accounts that exist in a database is tightly inegrated with Oracle Metadata. Now, with the separation of Container DB and Pluggable DB, the user accounts must exist in the Pluggable DB. So, the Pluggable DB not only contains user data, but also some user metadata. So, what are the benefits? * Multi-Tenancy - We can bring in two Pluggable DBs under one Container DB. Both will be totally segregated, but yet controlled by one instance. This is an important feature for SaaS (Software as a Service) platforms, Cloud, On-Demand and Vendor Managed Application solutions. * Easy cloning/copying. Now the cloning and copying the databases across servers would be much easier. Just clone a Pluggable DB and plug-it-in in a different server. * Very easy upgrades and patching.
Views: 76771 Sam Dhanasekaran
SQL Tutorial - 13: Inserting Data Into a Table From Another Table
 
07:00
In this tutorial we'll learn to use the INSERT Query to copy data from one table into another.
Views: 234648 The Bad Tutorials
PL/SQL tutorial 64: PL/SQL Collection Method Delete in Oracle Database by Manish Sharma
 
08:31
------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/delete-procedure Previous Tutorial ► Collection method Next & Prior https://youtu.be/5Ya35KboF1A ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! ------------------------------------------------------------------------- ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ ___Facebook Official Page of Manish Sharma___ https://www.facebook.com/TheRebellionRider/ ___Facebook Official Page of RebellionRider.com___ https://www.facebook.com/RebellionRider.official/ You can also Email me at for E-mail address please check the About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 4630 Manish Sharma
SQL: WITH Clause
 
06:11
In this tutorial, you'll learn will learn how to use with clause 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: 11459 radhikaravikumar
PL/SQL tutorial 65: PL/SQL Collection Method EXTEND in Oracle Database
 
08:49
RebellionRider presents the PL/SQL Collection Method Extend in Oracle Database with Example by Manish Sharma. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/col-method-extend ► PL/SQL Collection Method EXTEND https://youtu.be/QLP9xq5l_oA ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! ------------------------------------------------------------------------- ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ ___Facebook Official Page of Manish Sharma___ https://www.facebook.com/TheRebellionRider/ ___Facebook Official Page of RebellionRider.com___ https://www.facebook.com/RebellionRider.official/ You can also Email me at for E-mail address please check the About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 4464 Manish Sharma
SQL tutorial 38: How to create user using SQL Developer in Oracle database
 
06:52
How to create new user accounts using SQL Developer in oracle database. In This tutorial you will learn how to create a new user account. How to setup a database connection with SyS user. How to grant privileges to the user ----_Links_--- Blog :http://bit.ly/create_user_account Video Tut 4: http://youtu.be/wSqoXRlXDUU How to create database: http://youtu.be/enFFezPYhCg Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 Amazon Wishlist: http://bit.ly/wishlist-amazon 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 liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com
Views: 61170 Manish Sharma
Oracle Database Tutorial 63 : Introduction to Tablespace In Oracle Database
 
04:26
Introduction to tablespace in oracle database consist Brief intro of tablepsace, type of tablespace, Big and small file tablespace, intro of Data files in oracle By manish sharma RebellionRider ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/tablespace-introduction-rebellionrider Previous Tutorial ► Indexes https://youtu.be/F5NrQYD4a9g ------------------------------------------------------------------------- ►►►Help Me In Getting A Job◄◄◄ ►Help Me In Getting A Good Job By Connecting With Me on My LinkedIn and Endorsing My Skills. All My Contact Info is Down Below. You Can Also Refer Me To Your Company Thanks ------------------------------------------------------------------------- Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! -------------------------------------------------------------------------- Amazon Wishlist: http://bit.ly/wishlist-amazon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►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: 33291 Manish Sharma
Delete, Drop, and Truncate Statements in Hive
 
06:41
Delete, Drop, and Truncate Statements in Hive Delete Statement: Delete statement is used to delete certain rows from a table based on a condition specified using the WHERE clause. The syntax is in below as highlighted. DELETE FROM tablename [WHERE expression]; Note: DELETE statement is available from hive 0.14.0 version and above Drop Statement: The drop table statement is used to drop the table altogether. The syntax is highlighted here: DROP TABLE IF EXISTS TABLENAME; Let’s quickly see how the managed table and external table differs when dropping the table. We have already discussed this in the “Two different types of hive tables” video. Take a look at it if you haven’t. For the managed hive tables, the drop table statement removes the metadata information as well as the data. The data will be actually moved to .Trash/Current directory. metadata will be permanently deleted. However for external tables, only the metadata information is permanently deleted and the actual data remains intact in the hdfs directories. So in the case of external table, if the table was deleted accidentally, then the table can be re-created by using the same schema and specifying the same location for the hdfs data directory. If deleting the external table was the intention, then after deleting the table using the drop statement, you may also delete the underlying hdfs data directory by issuing the hdfs dfs -rm command. Truncate Statement: Truncate table statement is used to remove only the data from the table. The table structure with the schema remains intact. Truncate removes all the rows from a table or partition. The syntax is highlighted below. TRUNCATE table syntax TRUNCATE TABLE TABLENAME;
Views: 1102 BigDataElearning
Procedure Cursor Exists N IN keywords
 
27:47
Sql Server 2008 R2 Procedure Create & Using Cursor
Views: 23 Shivashwor Joshi
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: 52953 Manish Sharma
Oracle Database 12c: Introduction to a Multitenant Environment with Tom Kyte
 
10:47
Tom Kyte introduces Oracle Multitenant in Oracle Database 12c followed by a demo showing: multitenant architecture, moving a pluggable database (PDB) from one multitenant container database (CDB) to another, cloning a PDB, and creating a new PDB. For more information: "Multitenant Architecture" in Oracle® Database Concepts http://www.oracle.com/pls/topic/lookup?ctx=db121&id=CNCPT89233 "Managing a Multitenant Environment" in Oracle® Database Administrator's Guide http://www.oracle.com/pls/topic/lookup?ctx=db121&id=ADMIN13506 "About Common Users and Local Users" in Oracle® Database Security Guide http://www.oracle.com/pls/topic/lookup?ctx=db121&id=DBSEG573
Views: 79077 OracleDBVision
Solved!-Change Column Order in a Table - SQL Server.- Save Changes Not permitted
 
01:11
how to change column order in sql developer change column order mysql change column order sql query change column order oracle how to change column order in sql server 2012 alter table move column oracle sql reverse column order alter column position in sql table prevent saving changes that require the table re-creation saving changes is not permitted sql 2017 saving change is not permitted the changes you have made requires the following the following tables will be saved to your database prevent saving changes option sql can t save table sql server 2008 error were encountered during the save process sql server post save notification sql server
Views: 674 Maruti AIR Tech
MSSQL - Understanding Isolation Level By Example (Serializable)
 
08:46
Example SQL Statements below used in the video, you can Copy and Paste for Transaction Isolation Level of Serializable, Read Committed, Read Uncommitted, Repeatable Read --===================================== -- Windows/Session #1 --===================================== SELECT @@SPID IF EXISTS (SELECT 1 FROM sys.tables WHERE name = 'SampleTable') DROP TABLE SampleTable CREATE TABLE [SampleTable] ( [Id] [int] IDENTITY(1,1) NOT NULL, [Name] [varchar](100) NULL, [Value] [varchar](100) NULL, [DateChanged] [datetime] DEFAULT(GETDATE()) NULL, CONSTRAINT [PK_SampleTable] PRIMARY KEY CLUSTERED ([Id] ASC) ) INSERT INTO SampleTable(Name, Value) SELECT 'Name1', 'Value1' UNION ALL SELECT 'Name2', 'Value2' UNION ALL SELECT 'Name3', 'Value3' SELECT * FROM SampleTable BEGIN TRAN INSERT INTO SampleTable(Name, Value) VALUES('Name4', 'Value4') --UPDATE SampleTable SET Name = Name + Name --UPDATE SampleTable SET Name = Name + Name WHERE Name = 'Name1' UPDATE SampleTable SET Name = Name + Name WHERE ID = 2 DELETE FROM SampleTable WHERE ID = 4 WAITFOR DELAY '00:0:10' COMMIT TRAN --===================================== -- Windows/Session #2 --===================================== --------------------------------------------------- -- This window/session is default READ COMMITTED -- --------------------------------------------------- SELECT @@SPID BEGIN TRAN SELECT * FROM SampleTable WAITFOR DELAY '00:00:10' SELECT * FROM SampleTable WAITFOR DELAY '00:00:10' SELECT * FROM SampleTable ROLLBACK SELECT b.name, c.name, a.* FROM sys.dm_tran_locks a INNER JOIN sys.databases b ON a.resource_database_id = database_id INNER JOIN sys.objects c ON a.resource_associated_entity_id = object_id --===================================== -- Windows/Session #3 --===================================== ----------------------------------------------------- -- This window/session is REPEATABLE READ -- ----------------------------------------------------- SELECT @@SPID SET TRANSACTION ISOLATION LEVEL REPEATABLE READ BEGIN TRAN SELECT * FROM SampleTable WAITFOR DELAY '00:00:10' SELECT * FROM SampleTable WAITFOR DELAY '00:00:10' SELECT * FROM SampleTable COMMIT TRAN --===================================== -- Windows/Session #4 --===================================== ----------------------------------------------------- -- This window/session is SERIALIZABLE -- ----------------------------------------------------- SELECT @@SPID SET TRANSACTION ISOLATION LEVEL SERIALIZABLE BEGIN TRAN SELECT * FROM SampleTable WAITFOR DELAY '00:00:10' SELECT * FROM SampleTable WAITFOR DELAY '00:00:10' SELECT * FROM SampleTable COMMIT TRAN
Views: 11759 CodeCowboyOrg
The Oracle Next Door video series with Susan Marek #1 - Introduction
 
02:31
A video series dedicated to assisting you in uncovering your inner Oracle. The goal of this series is to empower you in using your divine gifts to be of service to yourself and others through the power of the Oracle. Susan Marek is a life-long intuitive who uses her gifts of claircognizance, clairvoyance, clairaudience, and clairsentience to be of Divine service. She works with angels, ascended masters, and elementals to provide healing, guidance, and insight to earthly issues. Trained as a Reiki Master and as an Angel Therapy Practitioner® and medium, certified by Doreen Virtue, PhD, Susan uses her knowledge to be of service to others through readings, speaking, and writing. She is the author of A Children's Guide to Chakras. For more information on Susan, please visit www.susanmarek.com.
Views: 24905 Susan Marek
Basics of jdbc programming Tutorial-7(inserting row in Resultset object)
 
09:12
this video deals with the insertion of a row in updatable ResulSet. I have shown the insertion using a java code. //Insertion of a row using updatable ResultSet import java.sql.*; import java.util.*; class Jdbc { public static void main(String[] args) throws Exception { Connection con=null; Statement st=null; ResultSet rs=null; String query=null; try { Class.forName("oracle.jdbc.OracleDriver"); con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","student","shubham123"); if(con!=null) { System.out.println("connection established"); st=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); } if(st!=null) { rs = st.executeQuery("select empid,ename,salary,comm,gender,city from emp026"); //Do not use * in oracle System.out.println("-----Current Records------"); while(rs.next()) { System.out.println(rs.getInt(1)+" "+rs.getString(2)+" "+rs.getDouble(3)+" "+rs.getDouble(4)+" "+rs.getString(5)+" "+rs.getString(6)); } System.out.println("\n-----------------------"); rs.moveToInsertRow(); rs.updateInt(1,60); rs.updateString(2,"ankit"); rs.updateDouble(3,3000); rs.updateDouble(4,40); rs.updateString(5,"male"); rs.updateString(6,"mumbai"); rs.insertRow(); //MySQL require primary key on table System.out.println("Data inserted"); rs=st.executeQuery("select empid,ename,salary,comm,gender,city from emp026"); while(rs.next()) { System.out.println(rs.getInt(1)+" "+rs.getString(2)+" "+rs.getDouble(3)+" "+rs.getDouble(4)+" "+rs.getString(5)+" "+rs.getString(6)); } } } catch(SQLException e) { e.printStackTrace(); } catch(ClassNotFoundException e) { e.printStackTrace(); } catch(Exception e) { e.printStackTrace(); } finally { st.close(); con.close(); } } }
Views: 144 Learn it by Fun
Oracle Reports | How to set Conditional Formatting | Bangla R-14
 
21:17
Oracle Reports | How to set Conditional Formatting | Bangla R-14 To See More Reports Tutorial Click here https://www.youtube.com/watch?v=y_0f_iILlmY&list=PLXXvCMuixAJUfU4ZISmPtHrmKe5qRvyVY To See More Forms Tutorial Click here https://www.youtube.com/watch?v=Zsu4CWo_vwk&list=PLXXvCMuixAJU3Ap_FE2zSEBicv8IC5kDU Dear viewer, In this tutorial you will know learn How to set Conditional Formatting in oracle reports. About Conditional formatting: -We can highlight or suppress objects using conditional formats. -Using the Conditional Formatting and Format Exception dialog boxes, you can specify output formatting attributes (font and color) for a selected layout object based on conditions that exist. -The conditions that you define are called format exceptions. Display Conditional formatting: You can display the Conditional Formatting dialog box from the Paper Layout view or Paper Design view in any of the following ways: Double-click the object to display the Property Inspector. Under the General Layout node, click the Conditional Formatting value field (labeled ...). Right click the object- Conditional Formatting from Display the pop-up menu. Select the object-then choose Format-Conditional Formatting. Questions-01: If the salary is between 9500 and 12500, a. make the text color blue. b. font size 14. c. print the field bold and italics. d. fill color gray Questions-02: If the salary is less than 10000 and job_id is SA_REP, That employee’s last_name is a. the text color red. b. font size 12. c. print the field bold. Questions-03: If the hire_date is less than 15-oct-07 and job_id is SA_MAN OR salary greater than 12500, That employee’s last_name is a. the text color yellow. b. font size 12. c. print the field bold. To Get more Tutorial Subscribe The Channel click here https://www.youtube.com/channel/UCQ3ea4zVCfnKBx1_7h8raGQ?sub_confirmation=1 To Get All Post Like The Facebook Page Click here https://www.facebook.com/oracledbsolutions Follow us: Facebook: https://www.facebook.com/oracledbsolutions Youtube link: https://www.youtube.com/channel/UCQ3ea4zVCfnKBx1_7h8raGQ?view_as=subscriber Facebook Group: https://www.facebook.com/groups/465557066961548 Contact us: email: [email protected] Skype: oracle26solutions Mob: 01734557080, 01627422780
Views: 62 OracleDB Solutions
QTP - Quick trick if QTP/UFT is not recognizing objects in your application.
 
02:05
http://www.joecolantonio.com/2013/09/26/qtp-uft-object-recognition-issues-with-net/ If you are like me the first thing I do when testing a new object with QTP is use the SPY to check out the files that I need to automate. If the QTP Spy has object recognition issues I rarely try to record against it. But in this case doing a quick throw away recording first actually helps.
Views: 17267 Joe Colantonio
SQL: Transaction Part-2
 
06:40
In this tutorial, you'll learn what are transaction and nature of transaction. 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: 1429 radhikaravikumar
Prevent SQL Injection with the 12c INHERIT PRIVILEGES Privilege - Lesson 1
 
01:28
Learn how the new 12c INHERIT PRIVILEGES fixes a PL/SQL security vulnerability - SQL Injection. In this introduction, Oracle Certified Master John Watson briefly recaps invokers rights code and explains why the problem exists - and has existed since Oracle 8i! See all lessons in this tutorial - free - at http://www.skillbuilders.com/12c-inherit-privileges-sql-injection.
Views: 383 SkillBuilders
17-SQL EXISTS and SEQUENCE
 
14:25
EXISTS and SEQUENCE رابط قاعدة البيانات المستخدمه : http://bit.ly/2epwzIe جروب الفيس بوك http://bit.ly/2eBlpzn صفحة فيس بوك http://bit.ly/2egqEBx
Views: 165 Ahmed Baidak
UNSETTLING Discoveries That Might Change History
 
10:19
You might not think so but history isn’t something that is set in stone. Subscribe to Talltanic http://goo.gl/wgfvrr #7 - Life On Mars Since it has been introduced, we as a society have gotten used to the idea that Mars and probably other planets once had life on them. Although this is something we’ve come to accept to be true, did you know that there is a whole new side of Mars’ history that we didn’t even know about? Although Mars doesn’t look like it now, NASA members have seen evidence on the planet’s surface that leads them to believe that there was once a massive ocean covering a large portion of the northern hemisphere. With that much water, they say that the planet could have been both warm and wet which is an even better breeding ground for life than previously thought. #6 - Akrotiri On Thera The preserved excavation site pictured here is Akrotiri on Thera, a rich ancient city that could possibly be the source of the famous Atlantis. Just like what had happened to the poor people of Pompeii, the Aegean city of Akrotiri was also coated in a thick layer of ash preserving it throughout the ages. The eruption occurred in 1620 BC and wasn’t truly discovered until the 1960s. This almost perfectly preserved city shows an abundance of wealth that include some astounding paintings depicting Bronze Age life. This discovery gave the world a whole new look and understanding of the Mediterranean sea trade as well as Minoan art. #5 - Oracle Bone Writing There has been a recent discovery that could mean the Chinese were among the first to discover the Americas. Scattered around the southern United States was a collection of 82 old stones that don’t look like they fit in with anything else from the surrounding native cultures. The messages on the rocks are messages written in Chinese oracle bone script. Oracle bone script is one of the oldest forms of Chinese writings known. When deciphering these messages, words describing a journey seems as though it was written by people exploring a new world. If this is true then that means that the Chinese landed in North America over 3,000 years ago. #4 - There Are More Mayan Cities The strange squarish platform pictured here is thought to be a huge Mayan city that was discovered by a 15-year-old named William Gadoury. This Canadian boy has a theory that Mayans chose to place their cities by following the constellations. After establishing this theory, he figured that there must be another undiscovered city in the Yucatan Peninsula in Mexico and judging by this picture, it looks like he may be right. The place in question hasn’t been seen in person yet but there have been curious sighting from space which is prompting an expedition. #3 - There’s More To King Tut’s Tomb Being lovers of ancient Egyptian history, we love the fact that there could possibly be more to King Tut’s tomb. When re-examining the chambers of the tomb with laser scans, Egyptologist Nicholas Reeves found what appeared to be not one but two additional, untouched chambers within the tomb. One of the chambers is thought to be hidden behind the wall you see in this picture. After being asked what he believed was behind door number one, Reeves said that he believes, and hopes, that it is the final resting place of Queen Nefertiti. Don’t worry, they aren’t going to just bring in a wrecking ball and smash in a wall, when they are ready to reveal what’s in the hidden tombs, they’ll most likely only drill tiny holes so they can insert cameras to look around. #2 - The Costa Rican Spheres If the sphere pictured here looks familiar it's because they have been a hot topic since they’ve been seen all around Costa Rica, sitting out in the sunshine, hanging out underwater, or like the one pictured here, almost buried completely under the dirt. It turns out that these spheres were left adorning certain towns and buildings depending on the person or people’s importance or title. The process it took to actually create these near perfect stones was such a lengthy and involved one that these stone couldn’t be given to just anyone, they had to have some sort of major social standing. #1 - Metal Books The two ancient books you see here are actually ancient texts in the form of metal books. The collection found was a total of 70 of these tiny books that measured to be about the size of a credit card. On the pages of these books are symbols, characters, and markings that are believed to possibly unlock some of the most questioned secrets of some of the first days of Christianity. The things these books say could end up changing the way we understand the Bible. Although it appears as though some of the markings refer to a Messiah, a Crucifixion, and possibly even a Resurrection, no one has been able to understand the full context of the language written.
Views: 7496315 Talltanic
Leveraging Oracle Multitenant from Visual Studio and .NET
 
10:08
.NET developers: Watch this video to learn how to take advantage of Oracle Multitenant, a new feature of Oracle Database 12c, while using Visual Studio. Oracle Multitenant makes it easy for developers to quickly make copies of existing databases, create/destroy new test databases quickly, and to share databases with other developers. If you would like to try out what you see in this video you will need access to an Oracle Database version 12.1 or later that was configured to use a container database. You will also need to download and install: 1) Oracle Developer Tools for Visual Studio version 12.1 or higher 2) Oracle Data Provider for .NET version 12.1 or higher This software can be found on the .NET Developer center (http://otn.oracle.com/dotnet) as part of the "ODTwithODAC" download packaging. For instructions on how to install this, see the Quick Start Video: https://www.youtube.com/watch?v=zrzDOk8gg5A Visual Studio 2012 and 2013 is supported - any edition except Express Edition (Community Edition is supported). Oracle Multitenant, introduced in Oracle Database 12c Release 1 (12.1), enables an Oracle database to function as a multitenant container database (CDB) that includes zero, one, or many customer-created pluggable databases (PDBs). A PDB is a portable collection of schemas, schema objects, and nonschema objects that appears to any Oracle client application as a non-CDB. Note: all Oracle database versions prior to Oracle Database 12c Release 1 (12.1) are known as non-CDBs. A CDB contains one seed database, which is a system-supplied template that the CDB can use to create new PDBs. The seed PDB is named PDB$SEED. You cannot add or modify objects in PDB$SEED. Because new PDBs are essentially copied from the seed rather than created from scratch, PDB creation time is generally much faster than creating a non-CDB. PDBs can also be cloned from other PDBs in a similarly fast amount of time. PDBs can be unplugged, which means they are removed from the CDB, and exist on the database server simply as a set of files: a metadata XML file along with some database files (.DBFs). This combination of metadata file and database files can then be easily plugged into any other CDB that is compatible with the PDB. From the point of view of .NET developers who have SYSDBA privileges, this makes testing a database configuration with your application as simple as cloning an existing PDB, or plugging in a PDB in the form of some provided database files. Similarly, a database configuration can be shared with other developers, either by cloning or through unplugging and sharing the database files. If a user with SYSDBA privileges makes a connection to a CDB in Visual Studio Server Explorer, a Pluggable Databases Node appears in the tree control. When that node is expanded, the seed PDB, along with any other available PDBs, appear as child nodes. From there, operations such as Create New, Plug, Unplug, Clone, Delete, Open, and Close can all be easily achieved.
Views: 956 Oracle .NET
Unsafe Deserialization Attacks In Java - Apostolos Giannakidis
 
45:26
Slides can be downloaded here: https://www.owasp.org/images/a/a3/OWASP-London-2017-May-18-ApostolosGiannakidis-JavaDeserializationTalk.pdf This talk was presented at OWASP London Chapter Meeting on 18-May-2017. A great number of Java applications utilize native Object Serialization to transfer or persist objects. Recently it has become popular the fact that the deserialization process in Java is flawed and if not used properly it can be easily abused by attackers. This talk provides an introduction and detailed overview of the problem of Java deserialization. You will understand the basic concepts of how Java deserialization exploits (gadget chains) work. Additionally, you will learn what solutions exist to the problem and the advantages and disadvantages of each. Finally, a new approach will be presented that protects the JVM from these attacks using a completely different approach than any other existing solution. Speaker Bio: Apostolos Giannakidis is the Security Architect at Waratek. Before joining Waratek in 2014, Apostolos worked in Oracle for 2 years focusing on Destructive Testing on the whole technology stack of Oracle and on Security Testing of the Solaris operating system. Apostolos has more than a decade of experience in the software industry and holds an MSc in Computer Science from the University of Birmingham.
Views: 1022 OWASP London
Identity Column: How to Check Identity Column in SQL Server
 
01:41
Here showing how to check identity columns in our SQL Server tables and finally get ready a complete list. Objects Used: Sys.Objects Sys.Columns
Views: 36 Technology Crowds
Creating functions with PostgreSQL
 
01:08
How to create and run functions in PostgreSQL Code used in the video ---- We're going to create a database to store the electronic documentation -- For each document we need to know -- file name (name + extension) -- who has created the document with some contact data -- version (example: 3.1, 5.2, ...) -- summary info -- date of creation DROP TABLE IF EXISTS tbl_docs; DROP TYPE IF EXISTS tp_file; DROP TYPE IF EXISTS tp_version; DROP TYPE IF EXISTS tp_fileName; DROP TABLE IF EXISTS tbl_author; DROP TYPE IF EXISTS tp_author; -- First we create the type for author CREATE TYPE tp_author as ( ID char(10), name varchar(100), telf varchar(12), email varchar(255) ); -- Creating the table to store the authors collaborators CREATE TABLE tbl_author OF tp_author ( PRIMARY KEY (ID) ); -- Inserting some authors INSERT INTO tbl_author VALUES ( '0000000001', -- ID, 'Joan Pi', -- NAME '659...', -- TELEPHONE '[email protected]' -- EMAIL ); SELECT * FROM tbl_author; -- We need to create version type -- version (example: 3.1, 5.2, ...) -- major and minor CREATE TYPE tp_version AS ( major int, minor int ); -- Creating filename and file types -- file name (name + extension) CREATE TYPE tp_fileName AS ( name varchar(200), extension varchar(10) ); -- Info related to type file -- file name (name + extension) -- who has created the document with some contact data -- version (example: 3.1, 5.2, ...) -- summary info -- date of creation CREATE TYPE tp_file AS ( name tp_filename, description text, -- summary info idAuthor char(10), -- field related to authors table. We associated on table creation createdDate timestamp with time zone, -- date of creation version tp_version -- Version of the document ); -- Creating the table to store the document's info CREATE TABLE tbl_docs of tp_file ( PRIMARY KEY (name,version), CONSTRAINT FK_AUTHOR -- Associating idAuthor with ID field of tbl_author FOREIGN KEY (idAuthor) REFERENCES tbl_author(ID) ); -- INSERTING SOME DATA ON tbl_docs INSERT INTO tbl_docs VALUES ( ROW('Requirements','odt')::tp_filename, -- name,extension. specify ::tp_filename is optional 'Requirements ....', -- description '0000000001', -- author identification. Must exist in tbl_author '2018-07-03 12:25:00', -- creation date ROW(3,1) -- version . In this case cast (::tp_version) not specified ); SELECT * FROM tbl_docs; -- With PostgreSQL we can create functions to add functionality to our database. You can execute from an external -- program for example using Java language or from a PostgreSQL client. -- In this video we're going to use a previous database. We've included the code above. -- The purpose of our function is to get the filename as string. The filename is composed in two parts: -- the name and the extension. -- f(x)=name + '.' + extension CREATE OR REPLACE FUNCTION fn_filename(name tp_filename) RETURNS text AS $$ BEGIN RETURN (name).name || '.' || (name).extension; -- concat operator in PostgreSQL is || END $$ LANGUAGE plpgsql; -- Getting name and description from tbl_docs SELECT name, description from tbl_docs; -- name column returns data in a format object -- Using the function we get the filename as name.extension (Requirements.dot) SELECT fn_filename(name) AS filename, description FROM tbl_docs; #FpInfor #Dam #DamMp02 #DamMp02Uf4
Views: 60 Miquel Boada
How to grant execute permissions on a SQL Server Database?
 
12:47
Learn how to grant execute permissions on a SQL Server Database. Also, while preparing this video I have experienced multiple issues and fixed them to achieve the task. Hope you like it. Check out my another article on, How to create Conflicts in Replication in SQL Server? https://youtu.be/nGuUPyla1Cw
Views: 13378 Srikanth Srikanth
Java Tutorial for Beginners | Java programming tutorial
 
10:31:06
Java Tutorial for Beginners | Java programming tutorial Learn More about JAVA @ https://goo.gl/Txghmq Java is a widely used robust technology. Let's start learning Java from basic questions like what is Java tutorial, Core Java, where it is used, what type of applications are created in Java, why use java and Java platforms etc. Our Java tutorial helps you to learn Java with easy and simple examples. This free java tutorial for complete beginners will help you learn the java programming language from scratch. visit Source Newboston playlist: https://www.youtube.com/watch?v=Hl-zzrqQoSE&list=PLFE2CE09D83EE3E28 Java is a general-purpose, high-level programming language developed by Sun Microsystems. The Java programming language was developed by a small team of engineers, known as the Green Team, who initiated the language in 1991. The Java language was originally called OAK, and at the time it was designed for handheld devices and set-top boxes. Oak was unsuccessful and in 1995 Sun changed the name to Java and modified the language to take advantage of the burgeoning World Wide Web. Later, in 2009, Oracle Corporation acquired Sun Microsystems and took ownership of two key Sun software assets: Java and Solaris. Today the Java platform is a commonly used foundation for developing and delivering content on the web. According to Oracle, there are more than 9 million Java developers worldwide and more than 3 billion mobile phones run Java. In 2014 one of the most significant changes to the Java language was launched with Java SE 8. Changes included additional functional programming features, parallel processing using streams and improved integration with JavaScript. The 20th anniversary of commercial Java was celebrated in 2015. Java is an Object-Oriented Language Java is defined as an object-oriented language similar to C++, but simplified to eliminate language features that cause common programming errors. The source code files (files with a .java extension) are compiled into a format called bytecode (files with a .class extension), which can then be executed by a Java interpreter. Compiled Java code can run on most computers because Java interpreters and runtime environments, known as Java Virtual Machines (VMs), exist for most operating systems, including UNIX, the Macintosh OS, and Windows. Bytecode can also be converted directly into machine language instructions by a just-in-time compiler (JIT). In 2007, most Java technologies were released under the GNU General Public License. #Java on the Web Java is a general purpose programming language with a number of features that make the language well suited for use on the World Wide Web. Small Java applications are called Java applets and can be downloaded from a Web server and run on your computer by a Java-compatible Web browser. Applications and websites using Java will not work unless Java is installed on your device. When you download Java, the software contains the Java Runtime Environment (JRE) which is needed to run in a Web browser. A component of the JRE, the Java Plug-in software allows Java applets to run inside various browsers Java Tutorial from Basics to Advance,java basics for beginners,advanced java tutorial,Java Programming Tutorial,java tutorials for beginners,java programming tutorial for beginners,Java Tutorial for Beginners,java,java programming,java programming for beginners,java tutorials,java (programming language),java video tutorial,java strings,advanced java tutorial for beginners,learn java programming examples,java programming for beginners tutorial #JavaTutorial #Javaprogramming
Views: 168010 Extern Code
Virtualbox error - Failed to create the hard disk storage, with UUID already exists
 
01:44
When trying to create a virtualbox (ubuntu), i get an error : -- Failed to create the hard disk storage /home/user/VirtualBox VMs/Ubuntu64bit.vdi Cannot register the hard disk '/home/duaz/VirtualBox VMs/Ubuntu64bit/Ubuntu64bit.vdi' {fb7edfb4-d1c7-41de-9e1d-e483f4663fed} because a hard disk '/home/duaz/VirtualBox VMs/Ubuntu64bit/Ubuntu64bit.vdi' with UUID {1ac61938-0ee5-428b-a29e-1c252dcdcbd4} already exists. -- See this video how to fix that.
Views: 5829 Ambar Hasbiyatmoko
Data Object ID and Last DDL Time
 
11:35
Examples of how to interpret DATA_OBJECT_ID and LAST_DDL_TIME (in any version (v7 and above) of Oracle, not just 12c)
Views: 53 Hemant K Chitale
Finding Database Columns By Name in Oracle SQL Developer
 
05:11
How to find all columns in your Oracle Database by searching on the name.
Views: 5557 Jeff Smith
SQL Server Error 26 (All versions)
 
02:33
------------- If you have any question please feel free to ask and Please Don't forget to SUBSCRIBE our channel and get watch our latest videos. ------------- In this video i'm going to help you "SQL Server Error 26 ". ------------- Keywords : SQL Server All versions How To Error Fix Drake In My Feelings Dance Challenge😍Compilation😍Best Ones kiki keke KiKi Do You Love Me Challenge Dance Compilation hoi an Low dh1.85 dh19.31 the hoxton dh2.00 dh14.32 howo dh2.19 dh8.17 geek 1K – 10K dh0.19 dh7.17 meditation dh0.09 dh3.87 to dh0.11 dh1.62 study skills 100 – 1K dh0.12 dh0.38 h to wikipedia page a hoe how to iphone how to for to com to do it how wiki howtogeek how is going wiki how to wikihow the how hot do ht to how to wikihow wiki ho howtowiki to hoe how to https wonder how to hmhome
Views: 298068 TAM
Oracle Database 12c Tutorial 3:Connect HR/SYS user with SQL Developer in Oracle12c Using TNS Service
 
05:24
Learn how to connect HR and Sys User of Oracle database 12c With SQL Developer using TNS service. Connect HR user which is in pluggable database to SQL Developer ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : Previous Tutorial ► Tut 61: How To Unlock HR schema in Oracle Database 12c http://youtu.be/F81gfUnznZY ------------------------------------------------------------------------- ►►►Help Me In Getting A Job◄◄◄ ►Help Me In Getting A Good Job By Connecting With Me on My LinkedIn and Endorsing My Skills. All My Contact Info is Down Below. You Can Also Refer Me To Your Company Thanks ------------------------------------------------------------------------- Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! -------------------------------------------------------------------------- Amazon Wishlist: http://bit.ly/wishlist-amazon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►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 [email protected] 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: 50895 Manish Sharma
Oracle Database 12c Tutorial  2: How To Unlock HR schema in Oracle Database 12c
 
07:18
Learn how to unlock HR user / Schema in Oracle Database 12c. Step by step procedure of unlocking the HR Schema in Oracle 12c By Manish Sharma a.k.a RebellionRider ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/how-to-unlock-hr-user-in-oracle-database-12c Previous Tutorial ► Tut 60: How To Install 12c On Windows 7: http://youtu.be/T-rCbe1MMG4 ------------------------------------------------------------------------- ►►►Help Me In Getting A Job◄◄◄ ►Help Me In Getting A Good Job By Connecting With Me on My LinkedIn and Endorsing My Skills. All My Contact Info is Down Below. You Can Also Refer Me To Your Company Thanks ------------------------------------------------------------------------- Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! -------------------------------------------------------------------------- Amazon Wishlist: http://bit.ly/wishlist-amazon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►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 [email protected] 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: 79106 Manish Sharma
SQL tutorial 60: SQL View in Oracle Database By Manish Sharma RebellionRider
 
07:30
SQL View in Oracle Database. In this tutorial you will learn how to create a vie as well as how to replace a view along with the examples of all the DML e.g. DESCRIBE, SELECT, UPDATE, INSERT and Delete on view by Manish Sharma RebellionRider ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/sql-view-in-oracle-database Previous Tutorial ► Tut 5: SELECT statement http://youtu.be/f_mVBVgnqmM ------------------------------------------------------------------------- ►►►Help Me In Getting A Job◄◄◄ ►Help Me In Getting A Good Job By Connecting With Me on My LinkedIn and Endorsing My Skills. All My Contact Info is Down Below. You Can Also Refer Me To Your Company Thanks ------------------------------------------------------------------------- Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! -------------------------------------------------------------------------- Amazon Wishlist: http://bit.ly/wishlist-amazon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►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 [email protected] 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: 39829 Manish Sharma
BI Connector | Can You Replace OBIEE With Tableau?
 
29:07
Many organizations are frustrated with OBIEE. What they are looking for is an ideal tool which can replace OBIEE like for like and also provide great visualization, blending, data wrangling, and speed of change. But does such a tool exist in the market today? A lot of organizations are looking towards Tableau and wondering if it can replace OBIEE entirely plus do what Tableau does best. In this presentation, we explore: 1. What are your options after OBIEE? 2. Is it possible to replace OBIEE with Tableau? 3. Should OBIEE and Tableau co-exist? 4. How BI Connector combines the best of Tableau and OBIEE to allow business users to gain Tableau visualization of OBIEE while repurposing the IT investment in OBIEE metadata model and security model. Download the free trial at https://www.biconnector.com/freetrial/ and visualize Oracle BI (OBIEE) Subject Area and Reports with your Tableau, Power BI or Qlik in minutes. For more information Visit: Website - http://www.biconnector.com LinkedIn - https://www.linkedin.com/showcase/bi-connector/ Facebook - https://www.facebook.com/biconnector Twitter - https://twitter.com/bi_connector?lang=en Don't forget to subscribe!
Views: 780 BI Connector
Crisis in the Foundation of Mathematics | Infinite Series
 
12:40
Viewers like you help make PBS (Thank you 😃) . Support your local PBS Member Station here: https://to.pbs.org/donateinfi What if the foundation that all of mathematics is built upon isn't as firm as we thought it was? Note: The natural numbers sometimes include zero and sometimes don't -- it depends on how you define it. Within logic, zero is always included as a natural number. Correction - The image shown at 8:15 is of Netwon's Principia and not Russell and Whitehead's Principia Mathematica as was intended. Tweet at us! @pbsinfinite Facebook: facebook.com/pbsinfinite series Email us! pbsinfiniteseries [at] gmail [dot] com Previous Episode How to generate Pseudorandom Numbers? | Infinite Series https://www.youtube.com/watch?v=C82JyCmtKWg Mathematics is cumulative -- it builds on itself. That’s part of why you take math courses in a fairly prescribed order. To learn about matrices - big blocks of numbers - and the procedure for multiplying matrices, you need to know about numbers. Matrices are defined in terms of - in other words, constructed from - more fundamental objects: numbers. References:: Probability website mentioned in comments: http://people.ischool.berkeley.edu/~nick/aaronson-oracle/index.html https://plato.stanford.edu/entries/philosophy-mathematics/ https://plato.stanford.edu/entries/logicism/ Ernst Snapper :: https://www.maa.org/sites/default/files/pdf/upload_library/22/Allendoerfer/1980/0025570x.di021111.02p0048m.pdf Philosophy of mathematics (Selected readings) edited by Paul Benacerraf and Hilary Putnam Written and Hosted by Kelsey Houston-Edwards Produced by Rusty Ward Graphics by Ray Lux Assistant Editing and Sound Design by Mike Petrow Made by Kornhaber Brown (www.kornhaberbrown.com) Thanks to Matthew O'Connor and Yana Chernobilsky who are supporting us on Patreon at the Identity level! And thanks to Nicholas Rose and Mauricio Pacheco who are supporting us at the Lemma level!
Views: 549876 PBS Infinite Series
12-How to generate scripts for complete Microsoft SQL Server database (including data)
 
04:22
Original high quality video: http://www.dotnetcodecentral.com/Post/131/microsoft-sql-server-quick-learn-how-to/How-to-generate-scripts-for-complete-SQL-Server-database All high quality videos on SQL Server (FREE to download): http://www.dotnetcodecentral.com/Technology/microsoft-sql-server-quick-learn-how-to Demonstrates the following: -Generate script (which contains all SQL commands for database objects) for entire database automatically using SQL Server Management Studio -Selecting various options while generating the script -Generating INSERT statements automatically for all tables in a database -Creating a new database and executing the script which was generated earlier (after executing the script, the new database should look almost identical to the previous database).
Views: 47406 Jagadish Pulakhandam

How to start a cover letter when you don't know the recipient
Free printable cover letter samples
Writing community service
Chcbp application letters
Research scientist cover letter examples