Home
Search results “Oracle select from dual into”
Oracle SQL Tutorial 9 - Intro to Queries
 
04:55
This video is for beginners who have never worked with SQL Developer, and we are going to teach how to begin writing queries. So the queries we are going to start with are queries when we give the database an expression and it will return back some kind of value. The most common keyword you are going to need to know for Oracle is SELECT. SELECT is the command we use to get data from the database. Even though we have not really put any data in our database, we can still use the SELECT statement to get data. That's because the database is capable of doing more than just creating tables and retrieving data from tables. So our first goal is to essentially write a Hello World, which just displays the text hello world to us. A good place to start is with: SELECT 'Hello World' This would actually work for many database management systems, but when you run it you will get an error. This actually doesn't work with Oracle, it will tell us we always need the FROM keyword. To get around this, there is a magical table called DUAL. We can put anything we want to SELECT and then say FROM DUAL and it will work. SELECT 'Hello World' FROM DUAL We can also do math: SELECT 1+1 FROM DUAL And we can run even run functions: SELECT SYSTIMESTAMP FROM DUAL To put all of this together, you can grab all of this data at the same time using commas to separate different columns from our generated table: SELECT 'Hello World', 1+1, SYSTIMESTAMP FROM DUAL 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: 26274 Caleb Curry
SQL, Oracle, Dual table, 3e62
 
07:37
Understanding Dual table. Most SQL videos are available on www.my-uni.net also. Feel free to visit
Views: 2730 hammadshams
PL/SQL Tutorial 3 (Oracle): Using an Alias
 
01:44
PL/SQL Tutorial 3 (Oracle): Using an Alias In this tutorial I show you how to use an Alias in PL/SQL. Source Code: https://github.com/mitchtabian/SQL-tutorials Subscribe to my Blog and YouTube channel to get notifications when new FREE coding tutorials are posted! Blog: http://www.codingwithmitch.com/
Views: 198 CodingWithMitch
Oracle Database11g tutorials 13 || SQL substr function / SQL substring function
 
06:34
link of SQL substr blog : http://www.rebellionrider.com/SQL-substr-function.htm SQL substr function SQL Substr function will return a sub string of a specified length from the source string beginning at a given position. 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 RebellionRi[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 ---------------------------------------------------------------------------- As the name suggests SQL Substr function will return substring from a given source string. Let's see the Syntax Substr (source_string, start_pos, Substr_length) As we can see SQL substr function takes 3 parameters. First one is Source string from which you want to extract the segment. Second parameter is Starting position for sub string from the Source string. And the third parameter is Substr_length which is the length for the substring. First two parameters are mandatory to specify while third one is optional. So we can say. SQL Substr function will return a sub string of a specified length from the source string beginning at a given position. First parameter source string can be of any data type CHAR, VARCHAR2, NCHAR, NVARCHAR2, CLOB, or NCLOB whereas both start_pos, Substr_length parameters must be number data type. The returning result of SQL Substr function is of same data type of source string. Let's see an example of SQL Substr function. SELECT substr('www.RebellionRider.com',5,14) FROM dual; Here in this query url of my website www.RebellionRider.com is our source string with the total length of 22 characters, Now, I want to extract the name of my website that is, RebellionRider. So if you count the total length of the name of the website, it is 14. That's why I have specified 14 as my third parameter of SQL Substr function which is substr_length. Also the name of the website RebellionRider is starting from 5th position therefore I have specified 5 at second parameter of SQL substr function which is strt_pos or starting position. Execute it. Here is our result RebellionRider When starting position is larger than the length of source string. In this case SQL Substr function will return NULL as a result. Let's do an example. SELECT substr('www.RebellionRider.com',23,14) FROM dual; As you can see here I have specified 23 at starting position and the total length of our source string is 22 characters Let's execute And the result is Null. Second scenario When the Substr_length is greater than source string In this case the segment return is the substring from starting position to the end of the string. For example SELECT substr('www.RebellionRider.com',5,23) FROM dual; Our starting position is at 5 means at the first R of RebellionRider and length of substring is set to 23 which is greater than the length of source string that is 22. Execute. As you can see we get a substring from first R of RebellionRider till the end of the source String. Third scenario When you supply numeric or arithmetic expression or a DATE instead of character as Source string to SQL Substr function In this scenario If you have supplied a numeric string instead of character as source string, the oracle engine casts them as a character when they occur as parameter to SQL Substr function. And if you have supplied Arithmetic expression or a DATE then The Oracle engine first solves or evaluates the Arithmetic expression or the DATE Then casts them as a character. Means if you have arithmetic expression in your source string then oracle will first solve it and then change or say cast the value of its result into character. Let's see some example. SELECT substr(50000-7,2,4) FROM dual; Oracle first evaluates the arithmetic expression that is 50000-7 equals to 49993. And then oracle engine casts this result 49993 into a character string. Means 49993 will be a 5 characters string. Starting position of substring is 2, that means from the first 9 of 49993 We specified the length of substring is 4 so we must get 9993 as our result. Let's check execute
Views: 79678 Manish Sharma
Oracle tutorial : How to create Id with AUTO INCREMENT in Oracle PL SQL
 
08:43
Oracle tutorial: How to create Id with AUTO INCREMENT in Oracle oracle tutorial for beginners sequence in oracle identity key in sql In this Oracle tutorial , we can create an auto increment field using ‘sequence’ object that can be assigned as primary keys. Using Oracle ‘sequence’ object, you can generate new values for a column. An Oracle sequence is an object like a table or a stored procedure. Examples CREATE SEQUENCE SYSTEM.MYSEQ START WITH 1 MAXVALUE 999999999999999999999999999 MINVALUE 1 NOCYCLE CACHE 20 NOORDER; CREATE OR REPLACE TRIGGER TR_CITY BEFORE INSERT ON CITY FOR EACH ROW BEGIN SELECT LPAD(LTRIM(RTRIM(TO_CHAR(myseq.NEXTVAL))),10,'0') INTO :NEW.id FROM DUAL; END; / Subscribe on youtube: https://www.youtube.com/channel/UCpiyAesWNYOXSz5GPq8lbkA For more tutorial please visit #techquerypond https://techquerypond.wordpress.com https://twitter.com/techquerypond identity column
Views: 9331 Tech Query Pond
How to insert multiple rows in just one query ?
 
01:53
This works in Oracle: insert into pager (PAG_ID,PAG_PARENT,PAG_NAME,PAG_ACTIVE) select 8000,0,'Multi 8000',1 from dual union all select 8001,0,'Multi 8001',1 from dual The thing to remember here is to use the from dual statement.
Views: 124 Houssine Formation
Oracle Database11g tutorials 11: SQL case manipulation function in Oracle Database
 
04:38
Part 2 SQL functions- character function -case manipulation functions Previous Video Link :: http://youtu.be/5rx8Q4x4-qI 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 ------------------------------------------------------------------------------------- As discuss in last video we have 3 case manipulation functions. In case you miss the SQL functions intro video you can find the link in the description below. First let's see what these functions are. Upper (): This function takes a parameter converts it into uppercase and returns the new string. Initcap (): this function also takes parameter and converts the initial letter of or parameter into uppercase and returns the new string. Lower (): This function takes a parameter converts it into lowercase and returns the new string. Ok let's do some practical For this practical we will be using 2 tables First is dual table Which is a dummy table provided by oracle? And I have created another table again by the name of example. This will be our second table. Let's start with SQL function upper ( ); SELECT upper('hello world') FROM dual; As you can see I have used "hello world" completely in lowercase as parameter to SQL upper function. Execute it. Here, our result has given us a completely new hello world string which is in uppercase. Similarly you can also use SQL upper function to perform other DML Let's try This time we will work on our second table EXAMPLE; insert into example values (upper('manish')); first parentheses for values and second for SQL function upper. Let's check the result. As you can see here inserted value is in upper case. Lets compare it with simple insert query Insert into example values ('manish'); Execute it, i think now it's clear that when we perform simple insert DML the inserted value will be the same you provide. Similarly let's try SQL function initcap(); SELECT initcap('hello world') FROM dual; As you see here in result the initial letters of string hello world are in uppercase. Let's do the insert query insert into example values (initcap('hello world')); initial letters of string also are in uppercase. Let's try SQL function lower(); This time we have to write our hello world in all caps. SELECT lower('HELLO WORLD') FROM dual; Execute String totally in lower case. Similarly you can user SQL function lower in other DML like insert and all.
Views: 85630 Manish Sharma
Every VARCHAR2(N) Declaration a Bug!? (HC-4)
 
07:51
That's right. VARCHAR2 declarations mean that you have to provide an "N" or constraint on the size of the variable. If you have such declarations all over your code, that's a form of hard-coding and you are likely to get hammered by VALUE_ERROR exceptions. This video shows you how to fix this problem, focusing in on the very helpful SUBTYPE feature of PL/SQL. ============================ Practically Perfect PL/SQL with Steven Feuerstein Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
ORACLE SQL 22: SYSDATE
 
07:06
http://studyandshare.wordpress.com/ http://www.facebook.com/groups/studyandsharevn/
Views: 1465 studyandsharevn
MySQL: How to select and change database and show tables in mysql
 
02:28
MySQL: How to select and change database and show tables in mysql To login : mysql -uusername -ppassword Show databases: show databases; show tables: show tables; To see which database you are using currently : select database() from dual Show all databases: show databases; Access database: mysql -u [username] -p [database] (will prompt for password) Create new database: create database [database]; Select database: use [database]; Determine what database is in use: select database(); Show all tables: show tables; Show table structure: describe [table]; List all indexes on a table: show index from [table]; Create new table with columns: CREATE TABLE [table] ([column] VARCHAR(120), [another-column] DATETIME); Adding a column: ALTER TABLE [table] ADD COLUMN [column] VARCHAR(120); Adding a column with an unique, auto-incrementing ID: ALTER TABLE [table] ADD COLUMN [column] int NOT NULL AUTO_INCREMENT PRIMARY KEY; Inserting a record: INSERT INTO [table] ([column], [column]) VALUES ('[value]', [value]'); MySQL function for datetime input: NOW() Selecting records: SELECT * FROM [table]; Explain records: EXPLAIN SELECT * FROM [table]; Selecting parts of records: SELECT [column], [another-column] FROM [table]; Counting records: SELECT COUNT([column]) FROM [table]; My website: http://learnersglobe.com/
Views: 15 Learners globe
Flashback Version Query
 
03:15
This video gives an overview of the Flashback Version Query functionality in Oracle, which can be used to display how data in a row has changed over time. For more information see: https://oracle-base.com/articles/10g/flashback-10g Website: https://oracle-base.com Blog: https://oracle-base.com/blog Twitter: https://twitter.com/oraclebase Cameo by Tanel poder : Website: https://gluent.com/ Blog: http://blog.tanelpoder.com/ Twitter : https://twitter.com/TanelPoder Cameo appearances are for fun, not an endorsement of the content of this video. All trademarks, product names and logos are the property of their respective owners.
Views: 988 ORACLE-BASE.com
Oracle DBA Justin - How to disable variable substitutions in Sqlplus
 
07:21
How to disable variable substitutions in Sqlplus
Views: 1114 jbleistein11
SQL tutorial 74: SQL COALESCE Function In oracle Database Manish Sharma
 
04:44
Third tutorial in SQL Null Series. Coalesce Null function with example in oracle Database. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/sql-coalesce Previous Tutorial ► NVL https://youtu.be/aRoTR5Jn6K0 ► NVL2 https://youtu.be/SCwc0HcS1-U ------------------------------------------------------------------------- ►►►Let's Get Free Uber Cab◄◄◄ Use Referral Code UberRebellionRider and get $20 free for your first ride. ------------------------------------------------------------------------- ►►►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 -------------------------------------------------------------------------- ►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: 26602 Manish Sharma
How to insert records in multiple tables at same time
 
06:12
How to insert records in multiple table at same time step by step, In this video i'm discus two methods for inserting records in multiple table at same time. #insert #ocptechnology #oracle12c
Views: 43545 OCP Technology
External Table in ORACLE Creating and Loading data from external tables
 
24:30
External Table in ORACLE Creating and Loading data from external tables. To Learn or Teach Linux visit www.theskillpedia.com, A Marketplace for Learners and Trainers. Creating and Loading an External Table Using ORACLE_LOADER The steps in this demonstration show an example of using the ORACLE_LOADER access driver to create and load an external table. A traditional table named emp_list is defined along with an external table named emp_load. The external data is then loaded into an internal table. Step 1. Log in as oracle user and create a Directory to place the data file /u01/app/datafiles: $ mkdir –p /u01/app/datafiles Step 2 Create a file emp_data.dat file with some sample records in /u01/app/datafiles: 45 october, 25, 1968 Sangwan Ram N 09/01/1993 67 december, 25, 1971 Dahiya Sunil D 01/01/1994 Step 3. Execute the following SQL statements to set up a default directory. Notes about this example: • The employee_number field in the datafile is converted to a character string for the employee_number field in the external table. • The datafile contains an employee_dob field that is not loaded into any field in the table. • The substr function is used on the employee_middle_name column in the external table to generate the value for middle_initial in tableemp. • The character string for employee_hire_date in info.dat is automatically converted into a DATE datatype at external table access time, using the format mask specified in the external table definiition. • Unlike employee_hire_date, the DATE datatype conversion for employee_dob is done at SELECT time and is not part of the external table definition.
Views: 4690 TheSkillPedia
Flashback Query Oracle Database||  Recovery Deleted Row
 
05:41
MD.Rahim Uddin Shohag Founder - Oracle Bangla https://www.oraclebangla.com/ fb :: https://www.facebook.com/oracle.shohag email: [email protected] Recovery Deleted Row in Oracle using Flashback Query ============================================ i'm show you how to recovery Deleted row in oracle database following Step :: ================== /* FLASHBACK QUERY NO NEED DBA */ CREATE TABLE DEMO_CUSTOMER ( CUST_ID NUMBER CONSTRAINT DEMO_CUSPRIMARY PRIMARY KEY, CUST_NAME VARCHAR2(100 BYTE), CUST_ADDRESS VARCHAR2(200 BYTE), CUST_PHONE VARCHAR2(15 BYTE), CUST_WEBSITE VARCHAR2(100 BYTE), CREATE_DATE DATE DEFAULT SYSDATE ); SELECT SYSDATE FROM DUAL; --------------- INSERT RECORD --------- INSERT INTO DEMO_CUSTOMER VALUES(100,'SHOHAG','DHAKA','121212','www.oraclebangla.com',SYSDATE); INSERT INTO DEMO_CUSTOMER VALUES(101,'RAHIM','Feni','121212','www.google.com',SYSDATE); INSERT INTO DEMO_CUSTOMER VALUES(103,'Rubel','karwan bazar','121343','www.obn.com',SYSDATE); INSERT INTO DEMO_CUSTOMER VALUES(104,'Karim','DHAKA','1212432','www.OCA.com',SYSDATE); COMMIT; SELECT * FROM DEMO_CUSTOMER; SELECT COUNT(*) FROM DEMO_CUSTOMER SELECT SYSDATE FROM DUAL; ---- AFTER FEW MINUTE -------- DELETE FROM DEMO_CUSTOMER WHERE CUST_ID = 100; DELETE FROM DEMO_CUSTOMER WHERE CUST_ID = 101; DELETE FROM DEMO_CUSTOMER WHERE CUST_ID = 103; COMMIT; SELECT * FROM DEMO_CUSTOMER; SELECT COUNT(*) FROM DEMO_CUSTOMER -----Way No 1 AFTER 1 MINIUTE ---------- SELECT * FROM DEMO_CUSTOMER AS OF TIMESTAMP (SYSTIMESTAMP -INTERVAL '1' MINUTE) ; SELECT COUNT(*) FROM DEMO_CUSTOMER; SELECT * FROM DEMO_CUSTOMER; /* IF SPECIFIC TIME FINDE DATA HISTORY */ ---- why no 2 SELECT * FROM DEMO_CUSTOMER AS OF TIMESTAMP TO_TIMESTAMP('21-02-2018 04:24:40 PM','DD-MM-RRRR HH:MI:SS AM'); ---============== recovery data ============= SELECT * FROM DEMO_CUSTOMER; --------------------------- SPECIFIC DATA RECOVERY -------------------------- SELECT * FROM DEMO_CUSTOMER AS OF TIMESTAMP (SYSTIMESTAMP -INTERVAL '2' MINUTE); INSERT INTO DEMO_CUSTOMER (SELECT * FROM DEMO_CUSTOMER AS OF TIMESTAMP (SYSTIMESTAMP -INTERVAL '2' MINUTE) WHERE CUST_ID = 101); COMMIT; SELECT * FROM DEMO_CUSTOMER; --- RECOVERY SINGEL RECORD FLASHBACK 2ND WAY SELECT * FROM DEMO_CUSTOMER AS OF TIMESTAMP TO_TIMESTAMP('21-02-2018 04:24:40 PM','DD-MM-RRRR HH:MI:SS AM'); INSERT INTO DEMO_CUSTOMER ( SELECT * FROM DEMO_CUSTOMER AS OF TIMESTAMP TO_TIMESTAMP('21-02-2018 04:24:40 PM','DD-MM-RRRR HH:MI:SS AM') WHERE CUST_ID = 100 ); COMMIT; SELECT * FROM DEMO_CUSTOMER; ---IF YOU RECOVERY DATA ALL DELETE RECORD JUST SIMPLE TECHNIC ----- SELECT * FROM DEMO_CUSTOMER AS OF TIMESTAMP TO_TIMESTAMP('21-02-2018 04:24:40 PM','DD-MM-RRRR HH:MI:SS AM') MINUS SELECT * FROM DEMO_CUSTOMER INSERT INTO DEMO_CUSTOMER( SELECT * FROM DEMO_CUSTOMER AS OF TIMESTAMP TO_TIMESTAMP('21-02-2018 04:24:40 PM','DD-MM-RRRR HH:MI:SS AM') MINUS SELECT * FROM DEMO_CUSTOMER); COMMIT; SELECT * FROM DEMO_CUSTOMER; SELECT COUNT(*) FROM DEMO_CUSTOMER; ------ IF YOU UPDATE RECORD FLASHBACK QUERY CHECK --- UPDATE DEMO_CUSTOMER SET CUST_NAME = 'Oracle' WHERE cust_id = 104; commit; SELECT * FROM DEMO_CUSTOMER; SELECT * FROM DEMO_CUSTOMER AS OF TIMESTAMP TO_TIMESTAMP('21-02-2018 04:24:40 PM','DD-MM-RRRR HH:MI:SS AM') WHERE CUST_ID = 104 SELECT * FROM DEMO_CUSTOMER AS OF TIMESTAMP TO_TIMESTAMP('21-02-2018 04:30:00 PM','DD-MM-RRRR HH:MI:SS AM') WHERE CUST_ID = 104
Views: 690 Oracle Bangla
Oracle SQL Tutorial 20 - How to Create Composite Primary Keys
 
07:02
This video is going to be a tutorial on how to create composite and compound keys. The difference between a composite and compound key is that a composite key can consist of any columns while a compound key has to consist of columns that are all keys themselves. We will be working with a compound key because we are going to be using the an intermediary table that has two foreign keys. The combination of both of the keys have to be unique. First, if we have any other CREATE TABLE commands, we are going to comment those out. We will space out the CREATE TABLE to have each column on a line, then we will add constraints as needed. CREATE TABLE project_users( project_id, user_id ) Now, let's add the data types: CREATE TABLE project_users( project_id NUMBER, user_id NUMBER } Now, what about some column attributes? I'm going to make both of the columns NOT NULL because we always want the rows to have a user and a project: CREATE TABLE project_users( project_id NUMBER NOT NULL, user_id NUMBER NOT NULL } Now, let's add the foreign key constraints. Now, what do we name these? We are going to add a primary key that covers both of these columns, so I'm going to be a sinner and not give these constraints names: CREATE TABLE project_users( project_id NUMBER NOT NULL REFERENCES projects (project_id), user_id NUMBER NOT NULL REFFERENCES users (user_id) ) Now, the way we have it now is that if we delete a project in the project table, and there are any rows in the project_users table, it will throw an error and prevent deletion. I would prefer for it to also delete any project members. That would make sense because if you delete a project we want it to delete the associate between that project and certain users. The same goes for if we delete a user, we want their association with a certain project to be deleted. To do this, we need to add the ON DELETE command: CREATE TABLE project_users( project_id NUMBER NOT NULL REFERENCES projects (project_id) ON DELETE CASCADE, user_id NUMBER NOT NULL REFERENCES users (user_id) ON DELETE CASCADE, ) Finally, let's learn how to create a compound or composite key. literally, the only difference is that you put a comma and add the second table inside of the parenthesis. CREATE TABLE project_users( project_id NUMBER NOT NULL REFERENCES projects (project_id) ON DELETE CASCADE, user_id NUMBER NOT NULL REFERENCES users (user_id) ON DELETE CASCADE, CONSTRAINT project_users_pk PRIMARY KEY (project_id, user_id) ) Now, the combination of project_id and user_id cannot be null, is always unique, and has an index. The only thing we should do now is add a few indexes. We aren't done yet...In the next video we are going to figure out what columns would benefit from indexes and we'll add them to it. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ HELP ME! http://www.patreon.com/calebcurry Subscribe to my newsletter: http://bit.ly/JoinCCNewsletter Donate!: http://bit.ly/DonateCTVM2. ~~~~~~~~~~~~~~~Additional Links~~~~~~~~~~~~~~~ More content: http://CalebCurry.com Facebook: http://www.facebook.com/CalebTheVideoMaker Google+: https://plus.google.com/+CalebTheVideoMaker2 Twitter: http://twitter.com/calebCurry Amazing Web Hosting - http://bit.ly/ccbluehost (The best web hosting for a cheap price!)
Views: 10491 Caleb Curry
Oracle SQL Developer Tutorial For Beginners   88   Dual Examples
 
00:58
Oracle SQL Developer Tutorial For Beginners Series. This course introduces Oracle SQL Development for its subscribers. Currently this is based on Oracle 12c. The test environment is in Windows 10.
Views: 680 Sam Dhanasekaran
Oracle tutorial : Conversion Functions In Oracle
 
09:30
Oracle tutorial : Conversion Functions In Oracle. oracle tutorial for beginners sql convert This Oracle tutorial video will show how to use conversion function in sql oracle TO_CHAR() , TO_DATE() , TO_NUMBER() these are mostly used functions. Conversions functions are used to convert one data type to another type. 1)To_CHAR ( number | date, [fmt], [nlsparams] ) The TO_CHAR function converts the number or date to VARCHAR2 data type in the specified format (fmt). 2)TO_NUMBER( char, [‘fmt’] ) The TO_NUMBER function converts the characters to a number format. 3)TO_DATE( char, [‘fmt’] ) The TO_DATE function converts the characters to a date data type. — TO_CHAR() fmYYYY YYYY/MM/DD SELECT TO_CHAR(SYSDATE, ‘YYYY/MM/DD’) FROM DUAL; — SO USING TO_CHAR U CAN GET FORMATE OF DATE ACCORDING TO UR REQURMENTS —- $99,999 99.99 99,00 SELECT TO_CHAR(487, ‘$99,0’) FROM DUAL; — U CAN GET DATA IN CURRENCY FORMAT —- TO_NUMBER() SELECT TO_NUMBER(‘1745′,’99999’) FROM DUAL; SELECT TO_NUMBER(‘1,47,982′,’9,99,999′) FROM DUAL; —- TO_DATE() — THIS CONVERT VARCHAR DATE TO PROPER DATE FORMAT SELECT TO_DATE(’30-JAN-1995′,’DD-MON-RRRR’) FROM DUAL; For more tutorial please visit #techquerypond https://techquerypond.com https://techquerypond.wordpress.com https://twitter.com/techquerypond sql convert convert function in sql
Views: 3825 Tech Query Pond
SQL tutorial 61: SEQUENCE in Oracle Database By Manish Sharma RebellionRider
 
08:05
This tutorial is all about Sequence In Oracle Database. In this SQL Tutorial you will learn How to create a sequence How to populate a Primary key column (auto increment in Oracle) using Sequence How to drop a sequence ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/sql-sequence-in-oracle-database-rebellionrider-manish-sharma Previous Tutorial ► How To Insert Data into Table using SQL Developer http://youtu.be/YYQCSV6MzTk ► INSERT INTO Command http://youtu.be/uQXgqFtxI_k ► How to copy /Insert data into a table from another table http://youtu.be/m3Ep8tAMqok ------------------------------------------------------------------------- ►►►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: 42482 Manish Sharma
CONCAT & PIPE "||" Operators in Oracle | Oracle Tutorials for Beginners
 
07:13
CONCAT & PIPE "||" Operators in Oracle | Oracle Tutorials for Beginners Oracle Tutorials for Beginners CONCAT Operators in Oracle SQL CONCAT Operators in Oracle Database CONCAT Operators in Oracle SQL Database || Operator in Oracle concatenate in oracle sql developer oracle concatenate columns with space oracle concatenate rows into string oracle concatenate string and number oracle concatenate all columns into string oracle concatenate columns with comma using concat function in oracle concatenate function in oracle 11g concatenate in oracle sql developer oracle sql concatenate column values concatenation operator in oracle concatenation operator in sql server oracle concatenate columns with space oracle concatenate string and number oracle concatenate rows into string concatenate in oracle sql query concatenate sql query concat sql server 2008 sql concatenate columns concatenate sql oracle sql concatenate rows mysql concatenate string sql concatenate string and int sql concatenate column values
Views: 618 Oracle PL/SQL World
PL/SQL tutorial 15: DML Trigger With Before Insert, Update and Delete DML Examples
 
09:17
PL/SQL Tutorial 15 explaining DML Trigger with examples such as Before Insert, Update and Delete in Detail. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/dml-triggers Previous Tutorial ► Trigger Intro : https://youtu.be/R3fvX_xf5P4 ► SELECT-INTO : https://youtu.be/F5eMJhwmCQs ►IF-THEN-ELSIF: https://youtu.be/aW9XgUHSr0I ------------------------------------------------------------------------- ►►►Let's Get Free Uber Cab◄◄◄ Use Referral Code UberRebellionRider and get $20 free for your first ride. ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ You can also Email me at for E-mail address please check About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 101533 Manish Sharma
Oracle Sql SELECT statement & Drl command ,where clause, Arithmetic Expressions
 
14:46
SQL Where clause with example on Oracle 11g Database -Oracle Sql Arabic Course Basic SELECT statement & Arithmetic Expressions اوراكل ديفيلوبر SQL tutorial 49: CASE - Simple Case Expression in Oracle Database The WHERE Clause: Case Sensitivity and Collations ORACLE 11g Course Details - Using TOAD (Tool For Oracle Application Development) in training ... Clause; Comparison and conditional operations; Arithmetic and logical operations ... Using group by and having clause of DRL statement ... Understanding the practical approach to sub queries/nested select/sub select/inner ... SQL Editor commands Oracle 12C /Oracle12C-Wilson.asp About SQL&SQL*PLUS; Constraints; Normalization and De-Normalization; ER Diagrams ... Working with DML, DRL Commands; Operators Support. DML-Insert, update, delete; DQL-SELECT Statements using WHERE clause; Comparison and Conditional Operators; Arithmetic and Logical Operators; Set Operators (UNION, ... [PDF]Oracle SQL(Structured Query Language) www.isashitsolution.com/pdf/ORACLE.pdf. Oracle. SQL(Structured Query Language) ... Working with DML, DRL Commands. • Operators Support. Build In Function. • Arithmetic Functions, Character Functions, ... Grouping the Result of a Query. • Using Group by and Having Clause of DRL. Statement ... Using VIEWS for DML Operations. SQL select statement and functions - Nov 20, 2013 - SQL Statements ... SQL as the standard language Oracle SQL complies with ... SQL Statements DRL - Retrieves data from the database DML ... If any column value in an arithmetic expression is null, the result is null. .... The DUAL table is generally used for SELECT clause syntax ... [PDF]SQL Basics & PL-SQL - SQL School sqlschool.com/downloads/PLSQL-Training-SQLSchool.pdf SQL Basics & Oracle PL/SQL Developer Training. All Our Training ... COMMANDS. ✓ Structured Query Language (SQL) Basics ... Returning into clause, Bulk Collect. ✓ For All ... Recycle Bin, Regular Expressions in PLSQL ... DML Command DRL Commands Operators. ✓ INSERT ... Arithmetic and Logical Operators. Operators in SQL.... - PL/SQL-Developer plsql/2011/10/operators-in-sql.html Oct 26, 2011 - If we select the data using select statement from dual ... Arithmetic Operators are used to perform arithmetic operations on numeric ... This is the syntax for using the IN operator. ... Unlike In condition where we will match selective multiple values, we will match .... SQL Statements Part3 (DRL,TCL and DCL). learn oracle - Curly Brackets learn-oracle/ Oracle Pre Defined Data types; DDL Commands; Create, Alter (add, modify, rename, ... Arithmetic Functions, Character Functions, Date Functions, Conversion ... a Query. Using Group by and Having Clause of DRL Statement; Using Order by clause ... Understanding the practical approach to Sub Queries/Nested Select/Sub ... Oracle PL-SQL - SequelGate oracle-plsql-training.html Arithmetic Functions; Character Functions; Date functions; Conversion Functions ... Using Group by and Having Clause of DRL Statement; Using Order by clause ... CASE expression of Select Command, Temporary Tables/Global Tables; New ... : DRL, DDL, DML, TCL and DCL commands /2014/12/drl-ddl-dml-tcl-and-dcl-commands.html DRL, DDL, DML, TCL and DCL commands. DRL (Data Retrieval Language):. Select. DDL (Data Definition Language):. Create. Alter. Drop. Truncate. Missing: expressions SQL Count - Wikitechy https://www.wikitechy.com/tutorials/sql/sql-count Tags : sql tutorial , pl sql tutorial , mysql tutorial , oracle tutorial , learn sql , sql server tutorial. Syntax ... expression can be a column name, an arithmetic operation, or a star . ... In addition to the COUNT function in the SELECT statement. In those cases, these columns need to be part of the GROUP BY clause as well
Views: 41 Muo sigma classes
Learning PL/SQL programming
 
29:21
Download the session ppts @ https://drive.google.com/file/d/0B_2D199JLIIpLXp5cm9QMFpVS00/view?usp=sharing 3:05 - Procedures 6:48 - Cursors 15:13 - Functions 16:36 - Triggers 21:35 - Package 23:59 - Exceptions
Views: 133687 BBarters
Session7 INSERT Statement
 
24:08
Session 7: Populating(INSERT) data into database table in Oracle. 1. Insert data into all columns(complete record) in a table. 2. Insert data into a table in same/random order of column. 3. Insert data into selective columns of a table. 4. Inserting NULL value into table. 5. Prompt the column to insert values in runtime using ‘&' and ‘&&'. 6. Insert data using select statement. 7. Create table as select.(create table with/without data). 8. Insert huge amount of dummy data using a PL/SQL block. — Create a table. CREATE TABLE emp (EmpID NUMBER(4) PRIMARY KEY, EName VARCHAR2(20) NOT NULL, Job VARCHAR2(20), DeptNo NUMBER(3), Sal NUMBER(7,2)); Insert data into all columns(complete record) in a table. same order of column: INSERT INTO emp VALUES(111, 'SCOTT', 'MANAGER', 10, 50000); INSERT INTO emp(EmpID, EName, Job, DeptNo, Sal) VALUES(112, 'JONES', 'DESIGNER', 20, 40000); Random order of column values: INSERT INTO emp VALUES(113, 45000, 10, 'SMITH', 'MANAGER'); — show error, why ?? INSERT INTO emp(EmpID, Sal , DeptNo, EName, Job) VALUES(113, 45000, 10, 'SMITH', 'MANAGER'); Insert data into selective columns of a table. INSERT INTO emp VALUES(122, 10, 'SMITH'); — show error INSERT INTO emp(EmpID, DeptNo, EName) VALUES(222, 10, 'SMITH'); Inserting NULL value into table. INSERT INTO emp VALUES(214, 'JONES', NULL, NULL, 40000); INSERT INTO emp(EmpID, EName, Sal) VALUES(215, 'ADEMS', 40000); Prompt the column to insert values in runtime using ‘&' and ‘&&'. INSERT INTO emp VALUES(&empid, '&ename', '&job', &deptno, &sal); INSERT INTO emp VALUES(&empid, &ename, &job, &deptno, &sal); INSERT INTO emp(EmpID, EName, Job, DeptNo, Sal) VALUES (&empid, '&ename', '&job', &deptno, &sal); INSERT INTO emp(EmpID, DeptNo, EName) VALUES (&empid, &deptno, '&ename'); INSERT INTO emp(EmpID, DeptNo, EName, Sal) VALUES (&empid, &&deptno, '&ename', &&sal); Insert data using select statement. INSERT INTO emp (SELECT 222, 'SATISH', 'MANAGER', 30, 60000 FROM DUAL); INSERT INTO emp VALUES(SELECT 223, 'RAHUL', 'SALESMAN', 30, 30000 FROM DUAL); — show error. Create table as select.(create table with/without data). CREATE TABLE emp_copy AS SELECT * FROM emp; — create table with same table structure, with data. SELECT * FROM tab; SELECT * FROM emp_copy; CREATE TABLE emp_copy2 AS SELECT * FROM emp where 1 != 1; — create table with same table structure, without data. SELECT * FROM tab; SELECT * FROM emp_copy2; Insert huge amount of dummy data using a PL/SQL block. BEGIN FOR i IN 1..100 LOOP INSERT INTO emp VALUES(i, 'Ename_'||i, 'Job_'||i, (MOD(i,5)+1)*10, (MOD(i,5)+1)*10000); END LOOP; END; / SELECT * FROM emp;
Views: 30 Prabhat Sahu
PL/SQL tutorial 88: PL/SQL Block using Execute Immediate of Dynamic SQL by Manish Sharma
 
07:51
Manish Sharma from RebellionRider.com presents how to create a PL/SQL block using Execute Immediate of Dynamic SQL in Oracle Database. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/nds-9 Previous Tutorial ► Bulk Collect Into with Execute Immediate https://youtu.be/5DgaUGGXyY4 ►SELECT INTO statement https://youtu.be/F5eMJhwmCQs ------------------------------------------------------------------------- ►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: 2451 Manish Sharma
SQL Oracle Greatest and Least Functions
 
07:50
SQL Oracle Greatest and Least Functions You can use https://livesql.oracle.com to run you r sample queries and learn. Commands used: /*List Functions – GREATEST and LEAST*/ SELECT GREATEST(employee_id, department_id,salary), employee_id, department_id,salary from hr.employees; SELECT GREATEST(5, 18, 21, 3, 65) AS GREATEST_CHECK, LEAST(5, 18, 21, 3, 65) AS LEAST_CHECK FROM dual; SELECT GREATEST('Fred', 'Edward', 'Ruby', 'Jane') AS GREATEST_CHECK, LEAST('Fred', 'Edward', 'Ruby', 'Jane') AS LEAST_CHECK FROM dual; SELECT GREATEST('9', '12', '73', '15') AS GREATEST_CHECK, LEAST('9', '12', '73', '15') AS LEAST_CHECK FROM dual; SELECT GREATEST('45', 'apple', 'banana', 100) AS GREATEST_CHECK, LEAST('45', 'apple', 'banana', 100) AS LEAST_CHECK FROM dual; SELECT GREATEST( TO_DATE('25-MAR-2017'), TO_DATE('14-APR-2017'), TO_DATE('7-JAN-2017')) AS GREATEST_CHECK, LEAST( TO_DATE('25-MAR-2017'), TO_DATE('14-APR-2017'), TO_DATE('7-JAN-2017')) AS LEAST_CHECK FROM dual; SELECT GREATEST('Fred', 'Edward', NULL, 'Jane') AS GREATEST_CHECK, LEAST('Fred', 'Edward', NULL, 'Jane') AS LEAST_CHECK FROM dual; SELECT GREATEST('x', 'w','y', 'a', 'q', 'u', 'i', 'a', 'd', 's', 'g', 'k', 'e', 'w', 'i', 'p','a', 'z', 'b', 'c', 'm','w', 'r', 'y', 'n', 'Z') AS GREATEST_CHECK, LEAST('x', 'w','y', 'a', 'q', 'u', 'i', 'a', 'd', 's', 'g', 'k', 'e', 'w', 'i', 'p','a', 'z', 'b', 'c', 'm','w', 'r', 'y', 'n') AS LEAST_CHECK FROM dual;
Views: 46 Nids Dixit
PL SQL 3   Databases and transactional applications
 
08:10
https://drive.google.com/file/d/0BxYoN5rLDBaRYnVOanBvUEk1cmM/edit?usp=sharing Course Objectives Bucles Modify data in PL / SQL Transactions and SAVEPOINT in PL / SQL blocks create table student (student_id number primary key, last_name varchar2(50) not null, zip number, registration_date date not null, created_by varchar2(20) not null, created_date date not null, modified_by varchar2(20) not null, modified_date date not null); Create table zipcode (ZIP number primary key, city varchar(20) , CREATED_BY varchar2(20) not null, CREATED_DATE date not null, MODIFIED_BY varchar2(20) not null, MODIFIED_DATE date not null); insert into zipcode values(43224,null,'OPER1',sysdate,'OPER1',sysdate); insert into zipcode values(96864,'PARIS','OPER1',sysdate,'OPER1',sysdate); insert into zipcode values(6325,'BREMEN','OPER1',sysdate,'OPER1',sysdate); BEGIN INSERT INTO student (student_id, last_name, zip, registration_date, created_by, created_date, modified_by, modified_date) VALUES (10, 'Tashi', 10015,'01-JAN-2013', 'STUDENTA', '01-JAN-99','STUDENTA','01-JAN-2013'); END; DECLARE v_zip zipcode.zip%TYPE; v_user zipcode.created_by%TYPE; v_date zipcode.created_date%TYPE; BEGIN SELECT 43438, USER, SYSDATE INTO v_zip, v_user, v_date FROM dual; INSERT INTO zipcode (ZIP, CREATED_BY ,CREATED_DATE, MODIFIED_BY, MODIFIED_DATE) VALUES(v_zip, v_user, v_date, v_user, v_date); END; ------------------------ DECLARE v_max_id number; BEGIN SELECT MAX(student_id) INTO v_max_id FROM student; INSERT into student (student_id, last_name, zip, created_by, created_date, modified_by, modified_date, registration_date) VALUES (v_max_id + 1, 'Rosenzweig', 11238, 'BROSENZ ', '01-JAN-99', 'BROSENZ', '01-JAN-99', '01-JAN-99' ); END; ------------------------ CREATE SEQUENCE test_seq INCREMENT BY 5; DECLARE v_max_id number; BEGIN SELECT test_seq.NEXTVAL INTO v_max_id FROM dual; INSERT into student (student_id, last_name, zip, created_by, created_date, modified_by, modified_date, registration_date) VALUES (v_max_id, 'Rosenzweig', 11238, 'BROSENZ ', '01-JAN-99', 'BROSENZ', '01-JAN-99', '01-JAN-99' ); END; ------------------------ CREATE SEQUENCE student_id_seq START WITH 1 INCREMENT BY 1; BEGIN INSERT INTO student ( student_id, Last_name, zip, registration_date, created_by, created_date, modified_by, modified_date) VALUES ( student_id_seq.nextval, 'Tashi', 10015, '01-JAN-99', 'STUDENTA', '01-JAN-99', 'STUDENTA','01-JAN-2013'); SAVEPOINT A; INSERT INTO student ( student_id, Last_name, zip, registration_date, created_by, created_date, modified_by, modified_date) VALUES (student_id_seq.nextval, 'Sonam', 10015, '01-JAN-99', 'STUDENTB','01-JAN-2013', 'STUDENTB', '01-JAN-99'); SAVEPOINT B; INSERT INTO student ( student_id, Last_name, zip, registration_date, created_by, created_date, modified_by, modified_date) VALUES (student_id_seq.nextval, 'Norbu', 10015, '01-JAN-99', 'STUDENTB', '01-JAN-2013', 'STUDENTB', '01-JAN-99'); SAVEPOINT C; ROLLBACK TO B; END;
Views: 340 Fdo Luis
Oracle Date Format
 
07:13
http://www.databasestar.com/oracle-to_date/ - A video that explains the different date formats in the Oracle SQL database.
Views: 3436 Database Star
Função Oracle FLOOR
 
03:59
Acesse o desafio: http://novidades.aprendaplsql.com/15-dias-de-funcoes-oracle A função FLOOR retornar o menor valor inteiro do parâmetro do tipo NUMBER que é passado. Abaixo exemplos da utilização da Função ORACLE FLOOR SELECT FLOOR(TO_NUMBER('10.2')) AS FLOOR FROM DUAL; SELECT FLOOR(-4.7) AS FLOOR FROM DUAL; SELECT FLOOR(TO_NUMBER('7.3')) AS FLOOR FROM DUAL; SELECT FLOOR(TO_NUMBER('7.9')) AS FLOOR FROM DUAL; https://www.youtube.com/playlist?list=PLMaqczuL07LkjrX6Rvx6TdNM-1nbUKG8p
Views: 833 Aprenda PL/SQL
Oracle SQL Lecture 23: BETWEEN and NOT BETWEEN
 
02:33
Oracle Sql: BETWEEN and NOT BETWEEN https://www.youtube.com/channel/UCnBpiBIOtRgMsk4G7Ri1jbQ
Views: 627 Oracle SQL
SQL JOINing Multiple Tables
 
11:03
Jamie King of Neumont University demonstrating how to join several tables together.
Views: 136794 Jamie King
Oracle Sql Step by Step Approach (065 dual what is this)
 
02:38
Oracle Sql Step by Step Approach (065 dual what is this) Discover essential SQL skills necessary to transform you into SQL developer which can earn you $70k+ in the IT Industry Learn to become a fee-earning SQL developer in just seven weeks. This fast, easy and effective course will take you from zero sql writing skills to being able to make money as a SQL developer. This one-stop-shot-style SQL course will teach you everything you need to know about SQL, from learning various database concepts to writing SQL to interact with the database. Throughout this SQL course I will be using the below methodology to make you think and help in forming the SQL statement. Like,Comment,Share
Installing Linux & Windows in Dual Boot: CORRECT PARTITION SCHEME & BOOT LOADER SETUP
 
16:12
In this video, I will cover two important steps of Installing Linux alongside your windows OS. 1) Choosing the correct Partition scheme 2) Setting up your Windows Boot loader to boot to Linux instead of Linux bootloader (e.g : GRUB) During a standard Linux installation, a user do not have to worry about this. But when you are trying to install Linux in separate partition, keeping your current OS, it gets little trickier. If you do not configure these two options correctly, you might end up corrupting your bootloader or previous OS installation. I will also show how you can add your Linux os option to the Windows 8 bootloader using BCDedit. This is important so that in case in future if you decide to get rid of Linux OS, your computer boots normally without any issues.
Views: 82551 XPSTECH
How to add Hard Disks in Oracle VirtualBox
 
02:53
We will learn how to add hard disks into an existing virtual machines. This is identical to adding hard disks to a physical machine and can be used for a variety of reasons: more data storage, better performance or increased reliability via RAID setup and others. Dynamic Storage Terms: http://www.avoiderrors.net/?p=4034
Views: 38404 AvoidErrors
Test Data Generation in SQL with in 1 minute
 
21:26
This tutorial explains how can you generate test data for tables with in 1 minute using only sql queries. It explains the 3 components used in data generation. 1.Dual table 2.DBMS_RANDOM 3.Connect by level and how you can combine them easily to generate huge amount of data with in seconds. The video touches on how to handle constraints but doesn't go in depth. If all of you find it useful and give me a thumbs like. I will prepare a detailed video explaining everything in simple manner with real projects examples. If you require any clarifications for the video content.Drop a comment and I will try to resolve asap. Please don't forget to like the video and do subscribe to my channel
Views: 2107 Tech Coach
Oracle SQL Data Conversion-Implicit Explicit
 
19:23
Oracle SQL Data Conversion Implicit Explicit Online console used -- https://livesql.oracle.com Implicit and Explicit data conversion to_char, to_number, to_date and cast functions Queries: /*IMPLICIT DATA CONVERSION EXAMPLES*/ SELECT salary + '10' FROM hr.employees; SELECT last_name FROM hr.employees WHERE employee_id = '200'; SELECT last_name FROM hr.employees WHERE employee_id = 200; SELECT last_name FROM hr.employees WHERE hire_date = '03-MAR-97'; Create table birth(name varchar2(15), dob date); Insert into birth values ('nids', '12/jan/58'); Insert into birth values ('panda', '14/feb/48'); Insert into birth values ('Spider', '14/feb/1958'); Insert into birth values ('agnes', '14/feb/2048'); Select * from birth; SELECT to_date('12-jan-58') - to_date('14-feb-48') from DUAL; '01/01/2058','MM/DD/RRRR' 01/01/2058 '01/01/2048','MM/DD/RRRR' 01/01/2048 '01/01/48','MM/DD/RRRR' 01/01/2048 '01/01/58','MM/DD/RRRR' 1/01/1958 '01/01/48','MM/DD/YYYY' 01/01/0048 '01/01/58','MM/DD/YYYY' 01/01/0058 '01/01/58','MM/DD/YY' 01/01/2058 '01/01/48','MM/DD/YY' 01/01/2048 SELECT * FROM NLS_SESSION_PARAMETERS WHERE PARAMETER = 'NLS_DATE_FORMAT'; Alter session set nls_date_format = 'DD-MM-RRRR'; Select * from birth; alter session set nls_date_format = 'DD-MON-YYYY'; Select * from birth; ALTER session set nls_date_format = 'DD-MON-YY'; SELECT to_date('12-jan-58') - to_date('14-feb-48') from DUAL; ALTER session set nls_date_format = 'DD-MON-RR'; /*EXPLICIT DATA CONVERSION EXAMPLES*/ /*TO_CHAR, TO_DATE, TO_NUMBER*/ SELECT first_name, TO_CHAR (hire_date, 'MON DD, YYYY') HIRE_DATE, TO_CHAR (salary, '$99999.99') Salary FROM hr.employees; SELECT TO_CHAR('01110') FROM DUAL; SELECT TO_CHAR('01110' + 1) FROM DUAL; SELECT TO_DATE('2012-06-05', 'YYYY-MM-DD') FROM dual; SELECT TO_DATE( '5 Jan 2017', 'DD MON YYYY' ) FROM dual; SELECT TO_NUMBER('1210.73', '9999.99') from DUAL; SELECT TO_NUMBER('$65.169', 'L99.999') FROM DUAL; SELECT TO_NUMBER('123,456,789', '999,999,999') FROM DUAL; /*This example takes a complicated string, determines that it is in certain format, and specifies the numeric characters to use*/ SELECT TO_NUMBER('$17 218,00', 'L999G999D00',' NLS_NUMERIC_CHARACTERS='', ''') FROM DUAL; /*CAST*/ SELECT CAST( '22-Aug-2003' AS varchar2(30) ) from dual; SELECT CAST('245.205' AS NUMBER(5,2)) FROM dual; /*      -- Result: 245.21 (note that the value is rounded, not truncated to 245.20) */ SELECT CAST(245.205 AS NUMBER(5,2)) FROM dual; SELECT CAST ('123456' AS NUMBER) + 5 FROM DUAL; SELECT CAST ('5.05.2017' AS DATE) +5 FROM DUAL; /*check the default date format. That's why it give error*/ SELECT CAST ('30-APRIL-2015' AS DATE) +5 FROM DUAL; SELECT CAST (SYSDATE AS TIMESTAMP) FROM DUAL; SELECT SYSDATE FROM DUAL;
Views: 47 Nids Dixit
How To Install Kali Linux in VirtualBox
 
12:25
in this video I am going to show you How to install Kali Linux in Virtualbox : Step-by-step . This is A detailed guide on installing Kali Linux on VirtualBox. I am going to show How to Install Kali Linux 2016 + Guest Additions on VirtualBox. This video will show you the easy way to Install Kali linux 2.0 on Virtualbox Step by Step Install Kali LInux 2 in VirtualBox, Installing Kali Linux 2016.1 on VirtualBox. -------------------Online Courses to learn---------------------------- Data Analytics with R Certification Training- http://bit.ly/2rSKHNP DevOps Certification Training - http://bit.ly/2T5P6bQ AWS Architect Certification Training - http://bit.ly/2PRHDeF Python Certification Training for Data Science - http://bit.ly/2BB3PV8 Java, J2EE & SOA Certification Training - http://bit.ly/2EKbwMK AI & Deep Learning with TensorFlow - http://bit.ly/2AeIHUR Big Data Hadoop Certification Training- http://bit.ly/2ReOl31 AWS Architect Certification Training - http://bit.ly/2EJhXjk Selenium Certification Training - http://bit.ly/2BFrfZs Tableau Training & Certification - http://bit.ly/2rODzSK Linux Administration Certification Training-http://bit.ly/2Gy9GQH ----------------------Follow--------------------------------------------- My Website - http://www.codebind.com My Blog - https://goo.gl/Nd2pFn My Facebook Page - https://goo.gl/eLp2cQ Google+ - https://goo.gl/lvC5FX Twitter - https://twitter.com/ProgrammingKnow Pinterest - https://goo.gl/kCInUp Text Case Converter - https://goo.gl/pVpcwL ------------------Facebook Links ---------------------------------------- http://fb.me/ProgrammingKnowledgeLearning/ http://fb.me/AndroidTutorialsForBeginners http://fb.me/Programmingknowledge http://fb.me/CppProgrammingLanguage http://fb.me/JavaTutorialsAndCode http://fb.me/SQLiteTutorial http://fb.me/UbuntuLinuxTutorials http://fb.me/EasyOnlineConverter
Views: 663764 ProgrammingKnowledge
Oracle Core,  Лекция 3-2
 
01:34:13
Ссылка на файл с презентацией: https://docs.google.com/presentation/d/1PzGVjjsR2lSlr5EXFzmbIpVN4RMGBkjwU_De6FQyxVI/edit?usp=sharing (презентация может быть с анимацией) Ссылка на краткий конспект лекции: https://docs.google.com/document/d/1x7-BCc_2Z83vSGjcFZiWGGdtVoRm1AJLRnxp-lXtchU/edit?usp=sharing 1. Таблица DUAL 2. Конструкция WITH. Рекурсивные запросы с конструкцией WITH 3. Иерархические запросы (self joins): START WITH, CONNECT BY, PRIOR, NOCYCLE, ORDER SIBLINGS BY, LEVEL, CONNECT_BY_ISCYCLE, CONNECT_BY_ISLEAF, SYS_CONNECT_BY_PATH, CONNECT_BY_ROOT 4. Псевдостолбцы (pseudocomlumns). 4.1 ORA_ROWSCN (SCN_TO_TIMESTAMP, TIMESTAMP_TO_SCN) 4.2 ROWID (DBMS_ROWID) 4.3 ROWNUM 5. Конструкция SAMPLE 6. Конструкция PIVOT 7. Конструкция UNPIVOT 8. Оператор INSERT INTO SINGLE TABLE 9. Оператор INSERT INTO MULTITABLE: INSERT ALL, INSERT FIRST 10. Оператор UPDATE 11. Оператор DELETE 12. Оператор MERGE 13. Обновляемая VIEW (KEY-PRESERVED TABLE) 14. SQL FUNCTIONS: SYSDATE, EXTRACT, ADD_MONTH, MONTH_BETWEEN, UPPER/LOWER, LENGTH, SUBSTR, INSTR, REPLACE, LTRIM/RTRIM/TRIM, LPAD/RPAD, TO_CHAR, TO_NUMBER, TO_DATE, POWER, ABS, ROUND, CEIL/FLOOR, USER, TRUNC, GREATEST/LEAST Oracle Database, БД Oracle, вебинар Oracle, презентация Oracle, урок Oracle, лекция Oracle, обучение Oracle
PL SQL 6   Triggers
 
07:27
https://drive.google.com/file/d/0BxYoN5rLDBaRbFAxVTl6NFoyUzg/edit?usp=sharing Course Objectives Triggers. example 1 INSERT INTO student (student_id, salutation, first_name, last_name, zip, registration_date, created_by, created_date, modified_by, modified_date) VALUES (STUDENT_ID_SEQ.NEXTVAL, 'Mr.', 'Pedro', 'Perez', '00914', SYSDATE, USER, SYSDATE, USER, SYSDATE); --------------------- Example 2 CREATE OR REPLACE TRIGGER student_bi BEFORE INSERT ON student FOR EACH ROW DECLARE v_student_id STUDENT.STUDENT_ID%TYPE; BEGIN SELECT STUDENT_ID_SEQ.NEXTVAL INTO v_student_id FROM dual; :NEW.student_id := v_student_id; :NEW.created_by := USER; :NEW.created_date := SYSDATE; :NEW.modified_by := USER; :NEW.modified_date := SYSDATE; END; ----------------------- Example 3 INSERT INTO student (salutation, first_name, last_name, zip, registration_date) VALUES ('Mr.', 'Pedro', 'Perez', '00914', SYSDATE); ----------------------- Example 4 CREATE OR REPLACE TRIGGER instructor_aud AFTER UPDATE OR DELETE ON INSTRUCTOR DECLARE v_type VARCHAR2(10); BEGIN IF UPDATING THEN v_type := 'UPDATE'; ELSIF DELETING THEN v_type := 'DELETE'; END IF; INSERT INTO statistics VALUES ('INSTRUCTOR', v_type, USER, SYSDATE); END; ---------------------- Example 5 CREATE OR REPLACE TRIGGER instructor_biud BEFORE INSERT OR UPDATE OR DELETE ON INSTRUCTOR DECLARE v_day VARCHAR2(10); BEGIN v_day := RTRIM(TO_CHAR(SYSDATE, 'DAY')); IF v_day LIKE ('S%') THEN RAISE_APPLICATION_ERROR (-20000, 'Pas de modif. les weekends'); END IF; END; --------------------- Example 6 CREATE OR REPLACE TRIGGER student_compound FOR INSERT ON STUDENT COMPOUND TRIGGER v_day VARCHAR2(10); BEFORE STATEMENT IS BEGIN v_day := RTRIM(TO_CHAR(SYSDATE, 'DAY')); IF v_day LIKE ('S%') THEN RAISE_APPLICATION_ERROR (-20000, 'A table cannot be modified during off hours'); END IF; END BEFORE STATEMENT; BEFORE EACH ROW IS BEGIN :NEW.student_id := STUDENT_ID_SEQ.NEXTVAL; :NEW.created_by := USER; :NEW.created_date := SYSDATE; :NEW.modified_by := USER; :NEW.modified_date := SYSDATE; END BEFORE EACH ROW; END student_compound;
Views: 1023 Fdo Luis
create table in sql (oracle)
 
05:33
how to create table in SQL(Oracle)
Views: 2555 6xoxox91
Oracle SQL Developer Tutorial For Beginners  82   SQL Statement Terminators
 
01:46
Oracle SQL Developer Tutorial For Beginners Series. This course introduces Oracle SQL Development for its subscribers. Currently this is based on Oracle 12c. The test environment is in Windows 10.
Views: 551 Sam Dhanasekaran
How to Install Ubuntu 16.04 LTS on VirtualBox in Windows 8 / Windows 10
 
19:20
I this video I am going to show , How to Install Ubuntu 16.04 LTS on VirtualBox in Windows 8 / Windows 10. Ubuntu is a most popular Linux-based operating system. Recently Ubuntu releases its newest version 16.04 (Xenial Xerus). VirtualBox is also a popular software for creating virtual machine available for Windows and Linux environment. -------------------Online Courses to learn---------------------------- Data Analytics with R Certification Training- http://bit.ly/2rSKHNP DevOps Certification Training - http://bit.ly/2T5P6bQ AWS Architect Certification Training - http://bit.ly/2PRHDeF Python Certification Training for Data Science - http://bit.ly/2BB3PV8 Java, J2EE & SOA Certification Training - http://bit.ly/2EKbwMK AI & Deep Learning with TensorFlow - http://bit.ly/2AeIHUR Big Data Hadoop Certification Training- http://bit.ly/2ReOl31 AWS Architect Certification Training - http://bit.ly/2EJhXjk Selenium Certification Training - http://bit.ly/2BFrfZs Tableau Training & Certification - http://bit.ly/2rODzSK Linux Administration Certification Training-http://bit.ly/2Gy9GQH ----------------------Follow--------------------------------------------- My Website - http://www.codebind.com My Blog - https://goo.gl/Nd2pFn My Facebook Page - https://goo.gl/eLp2cQ Google+ - https://goo.gl/lvC5FX Twitter - https://twitter.com/ProgrammingKnow Pinterest - https://goo.gl/kCInUp Text Case Converter - https://goo.gl/pVpcwL ------------------Facebook Links ---------------------------------------- http://fb.me/ProgrammingKnowledgeLearning/ http://fb.me/AndroidTutorialsForBeginners http://fb.me/Programmingknowledge http://fb.me/CppProgrammingLanguage http://fb.me/JavaTutorialsAndCode http://fb.me/SQLiteTutorial http://fb.me/UbuntuLinuxTutorials http://fb.me/EasyOnlineConverter
Views: 313806 ProgrammingKnowledge
11G features
 
11:48
11G features / Drop Table Test; / 1) Invisible Index / Create Table Test (A Number, B Varchar2(20) ); / Begin For I In 1..100000 loop Insert Into Test Values(I,'test'||I); End Loop; end; / explain plan for Select * From Test where b='test1850'; / Select * From Table(Dbms_Xplan.Display()); / Create Index In_test On Test(b) visible; / Alter Index In_test Invisible; / Alter Index In_test Visible; / Select * From User_Indexes Where Table_Name='TEST'; / ===================== 2) Sql Result Cache / 1. 1st Time It Will Execute The Query From Db 2. After That If We Execute The Same Query, It Wont Execute The Query Again In Db. It Will Fetch The Result From This Cache Memory. ===================== 3) Read only table: / Drop Table Test1; / Create Table Test1 ( A Number, B Number, C Varchar2(20) ); / Insert Into Test1 Values (10, 20, 'test'); / Select * From Test1; / Alter Table Test1 read only; / Insert Into Test1 Values (10, 20, 'test'); / Select * From Test1; / Alter Table Test1 Read write; / Insert Into Test1 Values (10, 20, 'test'); / Select * From Test1; / =========================== 4) Virtual Column; ====== / Drop Table Hist_Student; / CREATE TABLE HIST_STUDENT( ST_MARKS NUMBER, St_Max_Marks Number, St_Perc Number As (round(St_Marks/St_Max_Marks)*100), sum_marks number as (st_marks+st_max_marks) ); / Insert Into Hist_Student (St_Marks,St_Max_Marks) Values(93,150); Insert Into Hist_Student (St_Marks,St_Max_Marks) Values(85,100); / Select * From Hist_Student; / ====================== 5)Listagg / Syntax: / LISTAGG - LISTAGG (measure_expr [, 'delimiter_expr']) WITHIN GROUP (ORDER By Clause) [Over Partition Byclause] / Select Department_Id, Listagg( first_Name,',') Within Group(Order By Salary) Employees From Employees group by department_id; ====================== 6) Sequence Usage / DECLARE L_ID NUMBER; BEGIN L_ID:= TEST_SEQ.NEXTVAL; End; / 7) Regexp_Count / WITH C AS (SELECT ‘Sachin Tendulkar’ STARS FROM DUAL UNION ALL Select ‘virender Sehwag’ Stars From Dual Union All SELECT ‘Gautam Gambhir’ STA`RS FROM DUAL UNION ALL SELECT ‘MS Dhoni’ STARS FROM DUAL UNION ALL SELECT ‘Yuvraj Singh’ STARS FROM DUAL) SELECT STARS, REGEXP_COUNT(STARS, ‘s’, 1, ‘i’) S FROM C; STARS S --------- -- Sachin Tendulkar 1 Virender Sehwag 1 Gautam Gambhir 0 MS Dhoni 1 Yuvraj Singh 1
How to Boot from USB in VirtualBox
 
04:15
How to Boot from USB in VirtualBox In this video I will show how easy it is to boot from a USB Flash Drive in a Virtualbox or VMPlayer, will will be using free software call Plop Boot Manager http://www.plop.at/en/ploplinux/index.html https://www.virtualbox.org/ http://www.briteccomputers.co.uk
Views: 227390 Britec09
Breville BES870XL Barista Express - Filters explained
 
08:07
When I was researching my purchase of a new espresso machine, to replace my old Krups unit, I ran across terms like single-wall, dual- or double-wall and pressurized and non-pressurized filters. My Krups just had a small (1-shot) and large (2-shot) filter, so what were these other terms? In this video, I hope to clear up any confusion you might have. I'm not an expert in this by any means, so excuse any subtle technical errors in explanations. And it should apply to most espresso machines, not just the Breville like I have. And if you already know about all this, you can skip this video :) My old Krups machine had the two filters, mentioned above. Looking at them, there was a large mesh on the inside and outside was a much smaller mesh area. In fact if I held the filter up to a bright light, I could only see one tiny hole between the top and bottom of the filter, so that is a double-wall filter. Essentially what you have is an orifice plate: - http://en.wikipedia.org/wiki/Orifice_plate That small hole is what creates the pressure drop between the espresso machine pump and normal atmospheric pressure. Espresso machine pump hot water at 5-15 bar (75-225psi), although 9 bar is common, through the grounds to extract the coffee. But unless you live under a couple hundred feet under water, you can't drink espresso at 9 bar pressure! If you did not have that pressure drop, you would have coffee grounds splattered all around your kitchen. Don't ask me how I know but once I did not have a porta-filter firmly attached to my old machine and splat..., you get the picture! So that's a double-wall filter, what is a single-wall filter? Easy, just cut the bottom wall off a double wall filter basket and just leave the bottom mesh intact. So how does a single-wall filter work? Well, instead of one precisely machined orifice in the outer wall, the pressure drop is created by millions of tiny passages between the tightly packed, finely ground coffee in the filter basket. You can imagine if you filled the filter with whole beans and poured water on it, the water would drain through instantly. Grind that coffee finer and finer and it takes longer and longer for the water to drain through. So to use a single-wall, or non-pressurized filter, you need to dial in the fineness of the coffer grind and the pressure of the tamping to set up the pressure drop required to make the extraction process run for the desired time, about 20-30 seconds. If you go too far, you'll find you just get drops of espresso coming out of the porta-filter. Ideal grind should be about like regular table salt, so pick up a pinch of salt in one hand and a pinch of ground coffee in the other and compare them side by side. A double-wall, or pressurized filter is designed to do this automatically, even if it was empty. This works well if you only have pre-ground coffee or you don't want to be bothered with tweaking the grinder settings. Think of it like a point-and-shoot camera as compared to a manual DSLR camera where you have to manually set focus, exposure, f-stop and all that. Both camera take a picture, but the end result may be different. I hope you found this informative. I wish I had run across a video description like this when I was looking for a new espresso maker. As always, thanks for watching!
Views: 70470 R Brown
Oracle Database In-Memory Configuration, Population & Querying - DBIM workshop part2
 
48:02
Underlying Oracle Database In-Memory is a unique in-memory dual format that avoids the trade-offs inherent in single-format databases and enables both superfast analytics and online transaction processing (OLTP). This session explains how the In-Memory column is allocated, when and how data is populated into it, and provides details on the key performance enhancing features that come with it including in-memory data compression, scans, joins aggregations and storage indexes. We will also demonstrate how to monitor and manage the In-Memory column store via new v$ performance views and data dictionary tables.
Oracle -11g -Sql -Alter command -Add Column ,Modify,Drop the column -3
 
05:55
khunKhun Product - https://database426.wordpress.com Gmail -Id [email protected] In this viedo explain about Alter command with Praticle in detailed level -Some part of Alter Command -Like - Add column ,Rename Column ,Modify Column size ,Drop the Column thanks
Views: 164 khunkhun Product
Oracle SQL Developer Tutorial For Beginners   28   DML   INSERT
 
01:40
Oracle SQL Developer Tutorial For Beginners Series. This course introduces Oracle SQL Development for its subscribers. Currently this is based on Oracle 12c. The test environment is in Windows 10.
Views: 1596 Sam Dhanasekaran
Oracle SQL Developer Tutorial For Beginners   80   Reserved Words
 
00:57
Oracle SQL Developer Tutorial For Beginners Series. This course introduces Oracle SQL Development for its subscribers. Currently this is based on Oracle 12c. The test environment is in Windows 10.
Views: 613 Sam Dhanasekaran

Cefixime la thuoc chua benh gi
Ministerio del ambiente convocatoria de personal 2012
Prednisolone acid 10 mg beipackzettel citalopram
Intensol prednisone 5mg
Isotard 25mg clomid