Home
Search results “Select dummy oracle”
Oracle Interview question : what is dual table in oracle
 
05:14
Oracle Interview question : what is dual table in oracle Oracle dual table is automatically created as part of installation in SYS schema. Dual table has one column called DUMMY of VARCHAR2(1) datatype. This table is useful for computing a constant expression with select statement List of all the SQL and PLSQL interview questions https://easy-learning-tech.blogspot.com/p/oracle-sql-plsql-interview-questions.html
Views: 419 Siva Academy
PL/SQL tutorial 73: Bulk Collect with SELECT-INTO statement in Oracle Database
 
07:26
RebellionRider.com presents a PL/SQL tutorial on how to use the BULK COLLECT clause with SELECT INTO statement in Oracle Database by Manish Sharma. In this tutorial, you will also learn how to overcome the overhead caused by context switch and improve the query performance. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/bulk-collect-2 Previous Tutorial ►Introduction to Bulk Collect: https://youtu.be/CrJSlf_m3yA ►PL/SQL Tutorial 51-Nested Table: https://youtu.be/EUYyiFCzU0I ►Collection Method Count:https://youtu.be/NNq80CcC5K8 ------------------------------------------------------------------------- ►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: 10215 Manish Sharma
Create new connection with new user in Oracle SQL Developer
 
10:28
This video shows you how to create a new connection using a new user account (other than the system user account) in Oracle SQL Developer, so that you have a clean workspace without all the clutter of system tables. It is NOT a general introduction to using Oracle SQL Developer.
Views: 343770 Chitu Okoli
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: 85881 Manish Sharma
The DUAL TABLE in Oracle Database
 
01:56
The DUAL TABLE in Oracle Database
Views: 1491 Abe Samir's Academy
Getting started With Toad for Oracle - in-depth tutorial
 
23:18
https://www.quest.com/toad-for-oracle/ Getting started With Toad for Oracle - in-depth turorial
Views: 43423 Quest
Oracle SQL Developer: Query Builder Demo
 
08:13
How to build queries with your mouse versus the keyboard. 2018 Update: If you'd like to see how to convert your Oracle style JOINS to ANSI style (in the FROM vs the WHERE clause) see this post https://www.thatjeffsmith.com/archive/2018/10/query-builder-on-inline-views-and-ansi-joins/
Views: 72248 Jeff Smith
SQL Tutorial - 12: Inserting Data Into Tables
 
10:10
In this tutorial we'll learn to insert data into tables using the INSERT INTO statement.
Views: 167279 The Bad Tutorials
WMB Tutorials | Connecting to Database using WMB or IIB
 
07:48
This video explains how to connect to oracle database using WMB (WebSphere Message Broker) or IIB (IBM Integration Bus). In last video we saw how to configure database on WebSphere message broker or IBM integration bus. In this video we will go forward and write actual code to connect to oracle database to fetch data. We will be sending request with username in it and then based on username we will fetch that users data from oracle database. Service URL http://localhost:7080/services/getUserDetails Request { "username":"user1" } Response { "person_id": 1, "given_name": "Dave", "family_name": "Badger", "title": "Mr", "birth_date": "1960-05-01 00:00:00", "username": "user1" } Dummy Data for Connecting to Database using WMB or IIB Demo CREATE TABLE people ( person_id INTEGER NOT NULL PRIMARY KEY, user_name VARCHAR2(100) NOT NULL, given_name VARCHAR2(100) NOT NULL, family_name VARCHAR2(100) NOT NULL, title VARCHAR2(20), birth_date DATE ); INSERT INTO people VALUES (1, 'user1','Dave', 'Badger', 'Mr', date'1960-05-01'); commit; SELECT * FROM people;
Views: 1631 ProjectsGeek
SAP HANA Academy - SQL Functions: Add_Months_Last [2.0 SPS 00]
 
03:04
*** Important: please read this for prerequisites and code. Please note that this option is new for HANA 2.0 and will not work in previous versions. * Please see this playlist for more HANA SQL Function videos: https://www.youtube.com/playlist?list=PLkzo92owKnVwpfj5r9EZrPJdZJdUizexs In this video we'll look at the "Add_Months_Last" DateTime SQL function. The syntax used in this video is here: -- ADD_MONTHS_LAST ( d, N ) -- where input d is a DATE, a TIMESTAMP, or a SECONDDATE -- and input N = number of months to add --------------------------------------------------- SELECT ADD_MONTHS_LAST (TO_DATE ('2016-06-24'), 1), ADD_MONTHS_LAST (TO_DATE ('2016-06-30'), 1) FROM DUMMY; --------------------------------------------------- SELECT '2016-06-24 + 1' "Initial Date", ADD_MONTHS (TO_DATE ('2016-06-24'), 1) "Add Months", ADD_MONTHS_LAST (TO_DATE ('2016-06-24'), 1) "Add Months Last" FROM DUMMY UNION ALL SELECT '2016-10-31 + 1', ADD_MONTHS (TO_DATE ('2016-10-31'), 1), ADD_MONTHS_LAST (TO_DATE ('2016-10-31'), 1) FROM DUMMY UNION ALL SELECT '2016-06-30 + 1', ADD_MONTHS (TO_DATE ('2016-06-30'), 1), ADD_MONTHS_LAST (TO_DATE ('2016-06-30'), 1) FROM DUMMY UNION ALL SELECT '2015-02-28 + 12', ADD_MONTHS (TO_DATE ('2015-02-28'), 12), ADD_MONTHS_LAST (TO_DATE ('2015-02-28'), 12) FROM DUMMY; SELECT ADD_MONTHS_LAST (CURRENT_TIMESTAMP, 1) FROM DUMMY;
Views: 1147 SAP HANA Academy
Learn SQL in 1 Hour - SQL Basics for Beginners
 
01:02:23
A crash course in SQL. How to write SQL from scratch in 1 hour. In this video I show you how to write SQL using SQL Server and SQL Server Management Studio. We go through Creating a Database, Creating Tables, Inserting, Updating, Deleting, Selecting, Grouping, Summing, Indexing, Joining, and every basic you need to get starting writing SQL. TABLE OF CONTENTS Skip Intro/Discuss Management Studio 3:27 Create Database 5:10 Create Table 7:26 Insert Data 10:29 Select Statement 17:43 Where Clause 19:00 Update Statement 22:25 Delete Statement 24:33 Adding Comments 27:41 Adding Columns 29:33 Drop Table 32:38 Add Primary Key 33:17 Create Products Table 36:00 Create Orders Table 38:54 Foreign Keys 45:37 Joins 50:30 Functions/Group By 56:50 READ THE ORIGINAL ARTICLE WITH SQL SCRIPTS HERE http://www.sqltrainingonline.com/learn-basic-sql-course/ YOUTUBE NEWS UPDATES http://www.youtube.com/user/sqltrainingonline VISIT SQLTRAININGONLINE.COM FOR TONS MORE VIDEO NEWS & TIPS http://www.sqltrainingonline.com SUBSCRIBE FOR OTHER SQL TIPS AND NEWS! http://www.youtube.com/subscription_center?add_user=sqltrainingonline SUBSCRIBE TO OUR EMAIL LIST! http://www.sqltrainingonline.com LET'S CONNECT! Google+: http://gplus.to/SQLTrainingOnline Facebook: http://facebook.com/SQLTrainingOnline Twitter: http://twitter.com/sql_by_joey Linkedin: http://linkedin.com/in/joeyblue SQLTrainingOnline: http://www.sqltrainingonline.com
Views: 814253 Joey Blue
SQL tutorial 51: DECODE function in Oracle Database By Manish Sharma (RebellionRider)
 
05:04
SQL Tutorial 51 Decode function in Oracle Database. ● What Is DECODE() ● DECODE ( ) vs CASE ● Syntax of DECODE() ● Query 1. String Matching using DECODE() ● Query 2. DECODE() comparing values form the COLUMN of the table Celebrating 1000 subscribers. Thanks a lot guys for all your love and support. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: ------------------------------------------------------------------------- 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 first 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: 33888 Manish Sharma
Creating a database, table, and inserting - SQLite3 with Python 3 part 1
 
10:59
Welcome to an SQLite mini-series! SQLite, as the name suggests, is a lite version of an SQL database. SQLite3 comes as a part of the Python 3 standard library. Databases offer, typically, a superior method of high-volume data input and output over a typical file such as a text file. SQLite is a "light" version that works based on SQL syntax. SQL is a programming language in itself, but is a very popular database language. Many websites use MySQL, for example. SQLite truly shines because it is extremely lightweight. Setting up an SQLite database is nearly instant, there is no server to set up, no users to define, and no permissions to concern yourself with. For this reason, it is often used as a developmental and protyping database, but it can and is used in production. The main issue with SQLite is that it winds up being much like any other flat-file, so high volume input/output, especially with simultaneous queries, can be problematic and slow. You may then ask, what really is the difference between a typical file and sqlite. First, SQLite will let you structure your data as a database, which can easily be queried, so you get that functionality both with adding new content and calling upon it later. Each table would likely need its own file if you were doing plain files, and SQLite is all in one. SQLite is also going to be buffering your data. A flat file will require a full load before you can start querying the full dataset, SQLite files don't work that way. Finally, edits do not require the entire file to be re-saved, it's just that part of the file. This improves performance significantly. Alright great, let's dive into some SQLite. https://pythonprogramming.net/sql-database-python-part-1-inserting-database/ Playlist: https://www.youtube.com/playlist?list=PLQVvvaa0QuDezJh0sC5CqXLKZTSKU1YNo https://pythonprogramming.net https://twitter.com/sentdex https://www.facebook.com/pythonprogramming.net/ https://plus.google.com/+sentdex
Views: 218905 sentdex
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: 2169 Tech Coach
Hibernate - How to use multiple databases Mysql and Oracle
 
06:26
Java by Kiran class offers a wide range of java, selenium & python training in Pune to meet the growing corporate needs. We know individual learning capabilities are different that's why we offer to customize a course for each student. We provide 100% practical and real-time training. Lectures are only taken by Kiran sir only one branch at Karve Nagar Pune [only 2 timings 7.30 morning and evening and weekends] Kiran has worked (total 9 years) in MNC at Bangalore/ Noida/ Pune currently in MNC Pune learn from working professional who is still working so you will not get anything dummy. Only real-time scenarios at our institute whatever new technologies come into the market, we guarantee to train you.
Views: 375 Java By Kiran
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: 247531 The Bad Tutorials
How to Truncate Table in SQL
 
00:41
Follow this easy step by step tutorial to learn how to use Truncate Table query in SQL and see how data can be removed from the table. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ Truncate Table command allows us to delete all the data in the table without deleting the table itself. This command does not delete the entire table, but it only deletes the records inside the table. In this tutorial we will learn to truncate a table in SQL. Step 1- Viewing Table Data First of all let us view the records from any table, let it be dummy in our case. For that write: Select * from dummy and execute it by pressing F5. Step 2- Executing Command Now write the Truncate Table command along with the required table name. The query would be: Truncate table dummy and execute it . Step 3- Data Removed Now view the records of dummy table again, you will observe that the table would be empty with no records present. That is what the Truncate Table query does. And that is how we can truncate a table in SQL.
Oracle Architecture in less than 10 minutes
 
09:46
CAPTIONS AVAILABLE - I assume that it's the "I like!" votes that keep this video at or near the top when you search on "oracle". Thank you to all. S. Faroult View on www.konagora.com where Youtube is blocked. Full transcript (with some screenshots) available for a small fee at http://stores.lulu.com/konagora/. A pretty reckless description of what happens when you start Oracle and when you execute a statement. If you're a developer, it could influence how you code. If you're a junior DBA, or would be junior DBA, I hope it will help you make sense of some parts of the "Concepts" manual.
Views: 525567 roughsealtd
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: 35010 Manish Sharma
Dasar Penggunaan Cursor Pada Oracle PL/SQL
 
23:18
Cursor merupakan bagian dari PL/SQL. Silahkan Subscribe
Views: 142 Boby Siswanto
Creating simple Database in Android Studio
 
29:35
Video shows you how to create and work with SQLite database in your Android app. If you learn something press the Like button! If you want to see more tutorials like this press the Subscribe button! It's FREE!
Views: 59156 Tihomir RAdeff
BluePrism - SQL Server || Reality & Useful
 
21:45
Hi Friends, Now We will discuss about MSSQL Connectivity and fetch data from SQL Table --------------------------------------------------------------------------- First Check the table available in MSSQL or not and create one sample table with two columns Create table sample(no int,name text); HostName: BALAJI-PC\SQLEXPRESS I am going to create above table completed successfully. let me check query the table select * from sample; Now we will create a bot to fetch data from table. For this we will insert dummy data 1. We will use Action stage and 'Data - SQL Server' VBO to configure the database details Using the set connection we need to configure the SQL Server details Server - BALAJI-PC\SQLEXPRESS Database - Robotics-DB For my database no username and no password I Created againt the table using IDE. updating the query with this SELECT * FROM [Robotics-DB].[dbo].[sample] So, those are empty 2. we will use Action Stage to query the data We have a Action called 'Get Collection' SQL - select * from sample Now we got the data. Let's do the insertion of records For this we need to use Execute Action in Data - SQL Server' VBO insert into [Robotics-DB].[dbo].[sample] values(4,'Manager') Now we got the data with inserted record into collection Thank you for watching video and output will be the collection and success & message 3. Let's link it and execute we got error saying that invalid object name 'sample' That means unable to identify the table name Let me solve it
Views: 8353 Reality & Useful
SQL Joins Tutorial for Beginners - Inner Join, Left Join, Right Join, Full Outer Join
 
18:04
Learn how to create SQL Joins. The first 10 minutes teach you the basics. Inner Join, Left Outer Join, Right Outer Join, and Full Outer Join. The second 10 minutes show you are few techniques that will help you as you start building joins. READ THE ORIGINAL ARTICLE WITH THE TABLE SCRIPS http://www.sqltrainingonline.com/sql-joins-tutorial-for-beginners/ YOUTUBE NEWS UPDATES http://www.youtube.com/user/sqltrainingonline VISIT SQLTRAININGONLINE.COM FOR TONS MORE VIDEO NEWS & TIPS http://www.sqltrainingonline.com SUBSCRIBE FOR OTHER SQL TIPS AND NEWS! http://www.youtube.com/subscription_center?add_user=sqltrainingonline SUBSCRIBE TO OUR EMAIL LIST! http://www.sqltrainingonline.com LET'S CONNECT! Facebook: http://facebook.com/SQLTrainingOnline Twitter: http://twitter.com/sql_by_joey Linkedin: http://linkedin.com/in/joeyblue SQLTrainingOnline: http://www.sqltrainingonline.com
Views: 135320 Joey Blue
How to Detect Soft Corruption in Oracle 12c Database
 
18:19
Detection of Soft Corruption in 12c: To use the scripts below replace : , ",# and $ by proper bracket Lets Create a tablespace and small table. SQL: create tablespace DEMO1 datafile '/u02/tstdb1/TSTDB1/datafile/demo01.dbf' size 50M SQL: create table objects tablespace DEMO1 as select * from dba_objects; SQL: alter table objects add constraint pk_obj primary key #object_id$; SQL: create index idx_obj_name on objects#object_name$ tablespace demo1; Backup tablespace. RMAN: backup tablespace DEMO1; We need to put the DB in archivelog first Rebuild index with NOLOGGING option to simulate soft corruption later. RMAN: alter index idx_obj_name rebuild nologging; Confirm that we have datafiles that require backup because they have been affected with NOLOGGING operation. RMAN: report unrecoverable; Simulate corruption. RMAN: alter database datafile 5 offline; RMAN: restore datafile 5; RMAN: recover datafile 5; RMAN: alter database datafile 5 online; Query table with corrupted index and notice error. SQL: select count#*$ from objects where object_name like 'A%'; Let’s perform validation of datafile to check block corruption. RMAN: backup validate check logical datafile 5; Notice that we have 457 blocks marked corrupt but v$database_block_corruption view is empty. SQL: select count#*$ from v$database_block_corruption; Let’s query v$nonlogged_block view. set lines 200 set pages 999 select file#, block#, blocks,object#,reason from v$nonlogged_block; Will RMAN detect that we have corrupted blocks? RMAN: backup datafile 5; RMAN backup won’t fail due to NOLOGGING corrupt blocks and our backup will contain soft corrupted blocks. Let’s Identify corrupt segments using v$nonlogged_block view. set lines 2000 set pages 9999 col owner for a20 col partition_name for a10 col segment_name for a20 SELECT e.owner, e.segment_type, e.segment_name, e.partition_name, c.file# , greatest#e.block_id, c.block#$ corr_start_block# , least#e.block_id+e.blocks-1, c.block#+c.blocks-1$ corr_end_block# , least#e.block_id+e.blocks-1, c.block#+c.blocks-1$ - greatest#e.block_id, c.block#$ + 1 blocks_corrupted FROM dba_extents e, V$NONLOGGED_BLOCK c WHERE e.file_id = c.file# AND e.block_id "= c.block# + c.blocks - 1 AND e.block_id + e.blocks - 1 := c.block# UNION SELECT s.owner, s.segment_type, s.segment_name, s.partition_name, c.file# , header_block corr_start_block# , header_block corr_end_block# , 1 blocks_corrupted FROM dba_segments s, V$NONLOGGED_BLOCK c WHERE s.header_file = c.file# AND s.header_block between c.block# and c.block# + c.blocks - 1 UNION SELECT null owner, null segment_type, null segment_name, null partition_name, c.file# , greatest#f.block_id, c.block#$ corr_start_block# , least#f.block_id+f.blocks-1, c.block#+c.blocks-1$ corr_end_block# , least#f.block_id+f.blocks-1, c.block#+c.blocks-1$ - greatest#f.block_id, c.block#$ + 1 blocks_corrupted FROM dba_free_space f, V$NONLOGGED_BLOCK c WHERE f.file_id = c.file# AND f.block_id "= c.block# + c.blocks - 1 AND f.block_id + f.blocks - 1 := c.block# order by file#, corr_start_block# / This is the best outcome to get if you notice corruption errors. All errors are related to index corruption so we could fix this problem rebuilding index. alter index idx_obj_name rebuild; Simply issuing "alter index rebuild" command won't work. We should mark index unusable to drop segment before rebuilding it or just rebuild index with online option. It is better choice to mark index unusable because you don't need additional space then, but I will simply rebuild index with online option and see what will happen. SQL: alter index idx_obj_name rebuild online; Index altered. SQL: select count#*$ from objects where object_name like 'A%'; No errors... but, let's validate datafile for corruption. RMAN: backup validate check logical datafile 5; Notice "Marked Corrupt" column. Hm... 457 like before. Don't worry, this is not new corruption. These are FREE blocks which will be reused and Oracle will automatically re-format those blocks. Query the v$nonlogged_block view again as given above. We could force re-formatting creating dummy table and inserting data to dummy table. Check Doc ID 336133.1. create table s # n number, c varchar2#4000$ $ nologging tablespace DEMO1; SQL: BEGIN FOR i IN 1..1000000 LOOP INSERT /*+ APPEND */ INTO sys.s select i, lpad#'REFORMAT',3092, 'R'$ from dual; commit ; END LOOP; END; / SQL: drop table sys.s purge; Notice that we don't have corrupted blocks any more. RMAN: backup validate check logical datafile 5;
Views: 160 OracleDBA
Oracle Database 12c Tutorial 4: How to install sample schemas / users in Oracle Database 12c
 
08:33
Learn how to install sample schemas or users in oracle database 12c, In this tutorial you will also learn how to create a pluggable database in oracle database 12c by manish sharma RebellionRider ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/how-to-install-sample-schema-users-hr-sh-in-oracle-12c 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: 53062 Manish Sharma
Oracle SQL Tutorial 1 - Intro to Oracle Database
 
10:18
As illustrated in the video, Oracle Database is a program designed to hold lots of information, or data. There are all kinds of different databases and they all have their uses. Some of the most common ones are MySQL, SQL Server, Sybase, and MongoDB. All of these have different uses. The differences will be easier to understand after you learn more about each kind of database. We did not discuss it much in the video, but if you are wondering what “SQL” means in the title, it stands for structured query language. Structured query language is a human readable computer language that is used to tell databases to do things. We will discuss SQL and Oracle SQL Developer more in future videos. Databases are better than spreadsheets because they allow multiple users at one time, different levels of access given to users, recovery options and transactions, and it is more protected from hacking and malicious destruction. Programming languages often have very useful functions or methods that can be used to communicate to a database and therefore they are a naturally good option for the back end of programs. This course will go over all of the major parts of database programming using Oracle SQL. We will be using Oracle 11g, but these videos should still work with other versions, including the most recent 12c. Q and A ~~~~~~ How much does Oracle cost? The full enterprise edition costs thousands. They have other versions for less and they even have a FREE VERSION! This is known as the XE version (eXpress Edition). That is the one we will be using. How long does it take to learn SQL? You can learn all of the basics and be an efficient beginner database developer in only about a month of practice. To become an intermediate it can take anywhere from an additional 3 - 6 months with a only a few hours of studying and practicing each day. How can I learn SQL faster? Take notes and actually mess around with making your own database. Watch these videos until you understand the concepts within them, read articles and books that teach in more depth. Enjoy this content? You might enjoy my programming videos. Pick one and have some fun! 🙂 Learn Javascript - http://bit.ly/JavaScriptPlaylist Learn Java - http://bit.ly/JavaPlaylist Learn C# - http://bit.ly/CSharpTutorialsPlaylist Learn C++ - http://bit.ly/CPlusPlusPlaylist Learn C - http://bit.ly/CTutorialsPlaylist Donate!: http://bit.ly/DonateCTVM2. HELP ME! http://www.patreon.com/calebcurry. Subscribe to my newsletter: http://bit.ly/JoinCCNewsletter ~~~~~~~~~~~~~~~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: 328139 Caleb Curry
Introduction to GL
 
05:02
In this Video, we will understand the scope of the dummy setup which we will demonstrate in the future setup videos. We have covered only the mandatory setup steps, as per the standard Oracle PDF. We will map Web Tutorial itself in Oracle GL.
Views: 641 ERPWebTutor
How to Create S Curve in Primavera  P6 with less Data || Learn Oracle Primavera || dptutorials
 
04:34
These days, S-Curves are being made compulsory in the progress reports. S-Curve is nothing but display of labor units, Cumulative costs or other quantities against time. If it is a must to generate the S-Curve without having proper information on Costing and resources, there is a trick to generate the Curve with the dummy resource weights Let's see how we can generate the S-Curve in Primavera P6 Step-1: Develop a schedule with proper WBS. Step-2: Go to Resources tab and Right click, select Add to create a resource of Resource Type as "Labor". Step-3: Go to Activities Tab and click on Columns icon to add columns "Resources", "Budgeted Labor units", and "Actual Labor units". Step-4: Now assign the labor resources to all the activities by selecting all the activities (using shift button) at a time and by holding Shift button left click on the resources cell of the last activity and select the created resource so as to assign resource to all activities at a single time.(saving time rather than assigning for each activity). Step-5: Now, assign the planned weights in the "Budgeted labor units" cell to all the respective activities. Step-6: When you update and schedule w.r.t status date, you will see the actual weights in "Actual labor units" column Step-7: To view the S-Curve, click on "Resource usage profile" icon. Step-8: To print this S-Curve or to make a Pdf, Go to Printview>>Page setup>>options>> select only profile and click ok. Illustrative Video tutorial of the same has been shown below for your better understanding. FOR MORE DETAILED TUTORIALS, VISIT http://dptutorials.in/ SUBSCRIBE FOR MORE AWESOME TUTORIALS http://www.youtube.com/c/AskplannerBlogspotLearningmadeeasy SUPPORT THE CHANNEL VIA SHOPPING http://www.amazon.in/gift-card-store/b?ie=UTF8&node=3704982031 http://www.flipkart.com/offers/electronics?affid=durgapras20
Views: 12241 dptutorials
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
SQL TUTORIAL - SELF JOINS Hierarchy Tables
 
14:53
Another video brought to you by BeardedDev, bringing you tutorials on Business Intelligence, SQL Programming and Data Analysis. You can now support me on patreon - https://www.patreon.com/beardeddev This SQL Tutorial is all about hierarchy tables and self joins. We start off by looking at hierarchies that we are all aware of such as Parent and Child. The video then describes how we can create a hierarchy table in SQL Server including a Primary Key and a Foreign Key that references the Primary Key in the same table. If you are new to working with constraints in SQL Server please check out these videos: SQL Tutorial - Primary Key Constraints: https://youtu.be/DJ054rHGhRw SQL Tutorial - Create Table with Constraints: https://youtu.be/bfBnZKf2EGg If you would like to follow along with this SQL Tutorial then this is the create table statement used: CREATE TABLE dbo.Staff ( StaffId INT IDENTITY(1, 1) NOT NULL CONSTRAINT PK_Staff_StaffId PRIMARY KEY (StaffId) , StaffTitle VARCHAR(50) NOT NULL , ManagerId INT NULL CONSTRAINT FK_Staff_ManagerId FOREIGN KEY (ManagerId) REFERENCES dbo.Staff (StaffId) ) We then insert some dummy data in to the Hierarchy table and have a look at the results when executing a SELECT statement. On to discussing Self Joins, and the difference between using an INNER JOIN and a LEFT OUTER JOIN when joining a table to itself although the same applies if you were joining two separate underlying tables together. Then we apply a Self Join and return results, as the table and columns are the same we need to apply aliases. SELECT A.StaffTitle , B.StaffTitle AS ReportsTo FROM dbo.Staff AS A LEFT OUTER JOIN dbo.Staff AS B ON A.ManagerId = B.StaffId
Views: 114 BeardedDev
35 12 TimeConstraintMax SchedulingParameter
 
03:30
Let's take a look at the scheduling parameter settings for time constraint MAX. I will tell you about how to use the command for assigning processes to which time constraint MAX is applied, and how to assign processes when time constraint MAX is not satisfied. First, we will complete the operation. Let's move one operation and fix it. Operations in which result of Completed and Started has been input are assigned with the Assign privileged operations command. As a result, privileged operations are assigned prior to Scheduled operations. Similarly, time fixed operations are assigned with the Assign time fixed operations command. If an operation has not been time fixed or its result has not been input, it is assigned with the Assign/peg orders command. Operations to which time constraint MAX is applied are assigned at the same time in order to guarantee the upper limit of the time constraint. For this reason, if only some of the operations are privileged operations or fixed operations, it is difficult to satisfy time constraint MAX. To avoid this, operations related to time constraint MAX are assigned with higher priority by using the Assign result constrained operations command and the Assign time fix constrained operations command. Constraint violations are suppressed by assigning the remaining operations after assigning those operations for which it is difficult to satisfy the constraint. Even so, operations that do not satisfy constraints will occur. In preparation for such cases, we can specify an assignment method for operations that do not satisfy constraints. One such method is the Assign outside scheduling period method. This is the default setting. Next, there is the method of setting Ignore constraint and assigning without applying time constraint MAX. Failure to satisfy Time constraint MAX can be checked with the operation use-instruction bar, connection lines, and message. The last method is assignment to Dummy Resource. Assigning operations by setting Ignore constraint for the resources specified in the Integrated Master interferes with other operations for which time constraint MAX can be satisfied. Through assignment to Dummy Resource, we can avoid this so that as many operations as possible satisfy time constraint MAX. Out-of-period assignment may affect aspects such as load ratio, so selecting dummy resource may be preferable. Please select the appropriate setting according to the requirements.
Creating Calculated Items Using Oracle BI EE
 
02:26
This video teaches you how to create a calculated item for a specific set of data values. A calculated item is a computation between members. To find out more about Oracle BI EE, see the documentation at https://docs.oracle.com/en/middleware 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.
2. How to Read Excel Data using SELECT Query with WHERE Condition - Fillo Excel API
 
10:42
Using fillo excel api select query we can read the excel data. How we can query the database same way we can query the excel data. http://codoid.com/wp-content/uploads/2016/03/fillo-1.15.zip Facebook : https://www.facebook.com/automationtesting2016/ LinkedIn : https://www.linkedin.com/feed/?trk=hb_signin Google+ : https://plus.google.com/105286300926085335367 Twitter : https://twitter.com/krishnasakinala Website : http://automationtesting.in/ select query update query insert query delete query fillo excel api
Views: 770 Krishna Sakinala
creating a new connection in sqlDeveloper
 
01:51
this video demonstrates how to create new connection in sql developer
Views: 68681 Varun Bansal
How to Cancel a Third Party Cheque for Multiple Owners in HiRUM Front Desk
 
03:22
Learn how to CANCEL A THIRD PARTY CHEQUE FOR MULTIPLE OWNERS IN HIRUM FRONT DESK. Find more tips at http://www.hirum.com.au/ If you are looking for professional Property Management Software, Online Booking Software, and Channel Management Software for your accommodation or hospitality business, please contact us: http://www.hirum.com.au/contact-us/ Latest News and Updates! Blog ► http://www.hirum.com.au/blog Current HiRUM Support Clients: You can find more helpful tutorials here! eLearning Centre ► http://www.hirum.com.au/elearning Service Desk ► http://www.hirum.com.au/servicedesk Follow Us! Facebook ► https://www.facebook.com/hirumaustralasia Twitter ► https://twitter.com/hirumaust LinkedIn ► https://www.linkedin.com/company/hirum-australasia Google+ ► https://plus.google.com/+hirumaustralasia Instagram ► https://instagram.com/hirumaust/ Pinterest ► https://www.pinterest.com/hirumaust/ --- VIDEO TRANSCRIPT --- Welcome to a HiRUM tutorial. Our tutorials are presented at a pace that caters to the novice user. Our eLearning Centre has accompanying Help Sheets. The following tutorial will assist WHEN YOU WANT TO CANCEL A CHEQUE THAT WAS PAID TO A THIRD PARTY ON BEHALF OF MULTIPLE OWNERS. Click on to the Banking icon, and then click on to the All Payments icon, down in the bottom left hand corner you will find the month’s field, using the right or left arrows, choose the month that the cheque was originally generated in. Highlight the cheque in question and click on to the change button, select the option 'has this cheque been cleared on the bank statement, choose today's date as the cleared date. Ensure the Amount cleared is zero. When you are re-issuing a cheque to a third party, then simply select the Dummy unit, click on to the okay button. The funds will automatically be sent back to the Dummy unit. Go to the Units icon, Find the Dummy Unit, highlight and select the unit account. Enter a debit for exactly the same amount to bring the unit account back to zero, click on to the insert button, use today's date and enter the same amount as the cancelled cheque, Use the Group name that pertains to the charge, and leave the tick on payable to manager, click on to the okay button. The next thing to do is to go into each individual unit account that made up the original cheque amount and insert a credit using the same group code you used to create the debit in the dummy account. If you click on to the print Reports icon, then select the historic tab you will find a report called Group Ledger, Choose the Sort Order to be by Date transaction and enter the code you have been using to insert unit owner credits, select the date range to be the date you re-entered the credits and select the okay button. This is how you can check that the debit has been offset by the credits posted to the unit accounts. We hope you found this tutorial useful.
Java Tutorial 10: Create a simple Bank Account
 
12:19
Java Tutorial 10: Create a simple Bank Account. Demo on creating a simple bank account with multiple classes. Topics covered include working with multiple classes, creating objects and private variables in java.
Views: 90706 10minutetrain
pandas best practices (5/10): Handling missing values
 
05:03
This is part 5 of my pandas tutorial from PyCon 2018. Watch all 10 videos: https://www.youtube.com/playlist?list=PL5-da3qGB5IBITZj_dYSFqnd_15JgqwA6 This video covers the following topics: math with booleans, value counts, filtering a DataFrame, dropna parameter. NEW TO PANDAS? Watch my introductory series (30+ videos): https://www.youtube.com/playlist?list=PL5-da3qGB5ICCsgW1MxlZ0Hq8LL5U3u9y DOWNLOAD the dataset and notebook: https://github.com/justmarkham/pycon-2018-tutorial SUBSCRIBE to learn data science with Python: https://www.youtube.com/dataschool?sub_confirmation=1 JOIN the "Data School Insiders" community and receive exclusive rewards: https://www.patreon.com/dataschool LET'S CONNECT! - Newsletter: http://www.dataschool.io/subscribe/ - Twitter: https://twitter.com/justmarkham - Facebook: https://www.facebook.com/DataScienceSchool/
Views: 3896 Data School
SAP HANA Academy - Live2: 8. Unix ODBC install
 
26:13
In this step by step project from the SAP HANA Academy, we illustrate a simple example of building an application using native development tools for SAP HANA. This video walks through installing the Unix ODBC drivers for SAP HANA. Installing ODBC: First, enter either the Java ssh client or putty to connect to SAP HANA One. Users can configure the terminal to set the format they desire. (5:38 -- 6:15) Next, type in isql ---version after hanaserver:~# to verify that the ODBC has not been installed. Bob currently doesn't have ODBC installed. (6:30 -- 6:39) Then, create a folder by entering hanaserver:~# pwd, then hanaserver:~ cd.. , then hahaserver:/#mkdir _drivers, and then hanaserver:/#ls to create a folder named drivers for the ODBC installation. (6:45 -- 6:59) Next, enter hanaserver:/ cd_drivers and then hanaserver:/_drivers # ls to verify that the folder is empty. (7:00-7:13) Then, copy the syntax from the file linked at the bottom of the video (and this blog) and paste it after hanaservers:/_drivers # to download Unix ODBC. It should look like this: hanaservers:/_drivers # wget http://sourceforge.net/projects/unixodbc/files/unixODBC/2.2.14/unixODBC-2.2.14-linux-x86-64.tar.gz/download to download Unix ODBC. (7:20 - 8:15) After the file has downloaded enter hanaserver:/_drivers # gunzip unixODBC-2.2.14-linux-x86-64.tar.gz to gunzip the file. (9:10 -- 9:20) Next, enters hanaserver:/_drivers# tar xvf unixODBC-2.2.14-linux-x86-64.tar to un-tar the file. (9:20 -- 9:28) Enter ls to see the user folder and then drill down a few levels into the user folder by entering cd user, then ls, then cd local/, then ls to see the various file folders for Unix ODBC. (9:40 -- 10:00) Finally, drill into the bin folder by entering cd bin to see that iSQL has been installed. (10:01 -- 10:20) Configuring the connection to ODBC: First, enters su - hdbadm to connect as the SAP HANA administrator user. (10:34 -- 10:43) Next, add command executable paths to the HDBADM user by entering vi ~/.bashrc. (11:30 -- 11:56) Modify the resultant file by entering the path of :/_drivers/usr/local/bin after export PATH=$PATH:$JAVA_HOME/bin. (12:06 -- 12:24) Now that the path has been created type in :wq to quit vi. (12:30-12:36) Next, a user needs to modify the customer .sh file by entering vi ~/customer.sh when logged in as HDBADM. (14:50 -- 15:07) Above the resultant file paste in the below code that is found in number 6 in the attached file: export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/_drivers/usr/local/lib/. (15:17 -15:30) Next, create an ODBC.ini file in the home directory of the HDBADM user by pasting in export ODBCINI=$HOME/.odbc.ini. (15:52 -- 16:06) Then, return to hanaserver:/usr/sap/HDB/HDB 00 and enters cd/user/sap/hdbclient followed by entering ls to see all of the files. (17:28 -- 17:49) Next, put it in path by creating a new file by entering vi ~/.odbc.ini and then after pressing I to do an insert paste in this code from number 7 of the attached file: HDB Driver=/usr/sap/hdbclient/libodbcHDB.so ServerNode=localhost:30015. (17:57 -- 18:29) Enter :wq to write and quit and then reenter vi ~/.odbc.ini to verify that the file has been installed. (19:10 -- 19:15) Testing that ODBC Works: Now after entering hanaserver:/usr/sap/hdbclient isql --version an error is generated. (19:30 -- 19:37) To solve the error the user has to log out and then log back as HDBADM to refresh the connection with the updated variables to see that Unix.ODBC 2.2.14 is installed. (19:45 -- 20:07) Next, enter the command isql -- v HDB live2user SHALive1 to return a messaged that you are connected. The Live2 username and password were created in an earlier video in the series. (20:33 -- 21:09) Next, after SQL enter select * from dummy to verify the connection to SAP HANA One. (21:11 -- 21:31) Then, after SQL enter select * from "LIVE2"."Members" to return the Members table. (21:32 -- 21:50) Connecting to another HANA Box Reenter the ODBC driver by typing in vi ~/.odbc.ini. (22:17 -- 22:25) Check to make SAP HANA Boxes have the same revision and then copy the current command and then paste it below. (23:16 -- 23:45) Next re-name the DSNs. Bob renames HBD to REMOTEHDB in the copied command and in the original command he renames HDB to MYHDB. (23:45 -- 24:06) Then change localhost:30015 to the correct IP host and instance name for the REMOTEHDB HANA box. In this example Bob changes it to 54.83.15.89:30115. (24:07 -- 24:32) After entering a quit command, enter isql --v REMOTEHDB to connect to the REMOTE HDB and then enters select * from dummy to verify the new connection. (24:33 -- 25:07) For more videos, code samples and step-by-step projects, please visit us at www.academy.saphana.com
Views: 6695 SAP HANA Academy
Introduction to SQL - Tutorial for beginners to databases. PART 1
 
10:17
A fun, energetic and clear introduction to SQL and databases for just about anybody to understand! Take the FULL course: https://goo.gl/uY4wDo Finally understand SQL without being bored to tears or getting frustrated. Also grab my nice DISCOUNT on my SQL for FinTech job seekers course: https://goo.gl/jZHfVe This video answers: What is SQL? How is SQL used? What is a database? Why use a database instead of a spreadsheet? These videos have an intrinsic cost of about $1000 to make so if you enjoy them, please consider donating so that I can make more videos on a more regular basis! It's not just standing up and talking. It could be weeks of planning/research, then multiple takes, then hours of editing then responding to comments. Don't forget the thousands spent on the equipment used. I've spent a lot of money on the equipment I use to shoot/edit these and when they fail (which they are), I have to spend even more money to replace then. Then there is the fact I use up all my free time to do videos now. I have put aside friends and family to focus on this because I feel this is my calling to help others. My job is also very demanding and always comes first, so that leaves little time for videos. Thanks! https://www.paypal.com/cgi-bin/webscr... Part 2: https://goo.gl/ppQz9r NOTE: SQL combines the roles of data definition, data manipulation, and query in a single language. It was one of the first commercial languages for the relational model, although it departs in some respects from the relational model as described by Codd (for example, the rows and columns of a table can be ordered). Enjoy my SQL for beginners video! Check out my highly rated Option Trading Video: http://www.youtube.com/watch?v=357Lvf... Check out my FIX Protocol Training Series: http://www.youtube.com/watch?v=rW8sDk... Fun and Easy to Understand training on: Trading & Trading Techniques Wall Street Technology FIX Protocol Application Support Engineering This channel depends on YOUR support! Please subscribe and follow me on Google+ for more excellent videos! Thank you! -~-~~-~~~-~~-~- Take beginner SQL course and get certified: http://goo.gl/k2HKY8 -~-~~-~~~-~~-~-
Views: 685975 FIXProtocol
Java Banking Application Project full tutorial
 
20:49
Java Banking Application Project full tutorial 𝐅𝐨𝐥𝐥𝐨𝐰 𝐌𝐲 𝐒𝐨𝐜𝐢𝐚𝐥 𝐏𝐫𝐨𝐟𝐢𝐥𝐞 FACEBOOK ↱ https://www.facebook.com/Albert-Joseph-1615247938774420/ TWITTER ↱ https://twitter.com/albert_joseph1 LINKEDIN ↱ https://www.linkedin.com/in/albert-joseph-8b32b012a LINKEDIN ↱ http://albertjosephblog.wordpress.com BLOGGER ↱ http://albertjosephtips.blogspot.com/ PINTEREST. ↱ https://www.pinterest.com/AlbertJoseph1/ TUMBLR ↱ https://albertjoseph1.tumblr.com/
Views: 94023 Help People
PL/SQL tutorial 41: How To Create PL/SQL Stored Procedure Without Parameters in Oracle Database
 
06:30
RebellionRider.com present you the PL/SQL Tutorial 41 on How To Create PL/SQL Stored Procedure Without Parameters in Oracle Database By Manish Sharma ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/create-procedure-1 Previous Tutorial ► PL/SQL Blocks: https://youtu.be/rbarR4_gaH8 ► Introduction To Stored Procedures: https://youtu.be/buaSuEMi4lw ------------------------------------------------------------------------- ►►►Let's Get Free Uber Cab◄◄◄ Use Referral Code UberRebellionRider and get $20 free for your first ride. ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ ___Facebook Official Page___ https://www.facebook.com/RebellionRider.official/ You can also Email me at for E-mail address please check 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: 40275 Manish Sharma
Generating Personal ID for New Employee on Peoplesoft
 
01:18
Tour : Generating personal ID for new employees on Peoplesoft Step 1. Add new employee Step 2. Add employee details Step 3. Biographical details Step 4. Contact Information Step 5. Regional details Step 6. Fill in region specific information Step 7. Organizational relationships Step 8. Select organizational relationship of the employee Step 9. Click to save all information Step 10. Personal ID has generated 1. Add new employee Click here to add new employee to your Peoplesoft HRMS 2. Add employee details Fill in details of the new employee to your Peoplesoft database 3. Biographical details Let's start with adding his biographical details 4. Contact Information Enter contact information of the new employee 5. Regional details Fill in employee details that are specific to the region. 6. Fill in region specific information We have taken Canada in the above case where you need to provide details like bilingual code, health care number and more which are specific to Canada 7. Organizational relationships You need to enter employee's organisational relationship. 8. Select organizational relationship of the employee A person can have more than one organizational relationship at any one time or can change relationships over time.  9. Click to save all information Click to save all the details filled in about the employee and generate his personal I.D. 10. Personal ID has generated Congratulations! Employee has been successfully added on your Peoplesoft database and personal I.D. has been generated
Views: 795 MyGuide
SQL Tutorial For Beginners | Learn SQL Basic to Advance
 
03:40:07
SQL Tutorial For Beginners | Learn SQL Basic to Advance Learn More about SQL @ https://goo.gl/oRjLfu In this SQL Tutorial, you Learn everything about using SQL for managing databases. SQL is a standard language for storing, manipulating and retrieving data in databases. Our tutorial will teach you how to use SQL in MySQL Server, MS Access, Oracle, Sybase, Informix, Postgres, and other database systems. Source NewBoston: https://goo.gl/3NzveD Timestamps 0:00 Introduction to Databases 7:32 SQL Server 12:04 Creating a Database 21:40 SHOW and SELECT 28:19 Rules for SQL Statements 32:30 Getting Multiple Columns 37:41 Distinct and LIMIT 43:29 Sorting Results 50:25 Sort Direction 54:42 Data Filtering and WHERE 59:38 Advanced Filtering Using AND and OR 1:06:33 IN ,NOT IN 1:12:52 Search Engines Work 1:19:19 More on Wildcards 1:22:33 Regular Expressions 1:30:05 Custom Columns 1:38:49 Functions 1:45:02 Aggregate Functions 1:52:59 GROUP BY 2:00:19 Subqueries (watch this https://youtu.be/iq52vhD45A4 ) 2:06:28 Another Subquery Example 2:13:37 Join Tables 2:22:05 Outer Joins 2:30:12 UNION 2:35:34 Text Searching 2:42:39 INSERT INTO 2:50:45 Insert Multiple Rows 2:59:26 UPDATE & DELETE 3:07:13 CREATE TABLE 3:14:19 NOT NULL & AUTO INCREMENT 3:21:25 ALTER / DROP / RENAME TABLE 3:27:30 Views 3:36:38 General Tips #SQL #SQLTutorial. #LearnSQL
Views: 82230 Extern Code
SQL Consulting | Connect SQL Developer to Oracle Database
 
05:34
Connect SQL Developer to Oracle Database Tutorial http://www.ReportingGuru.com Email us at [email protected] if you need help, custom reports, or reporting architecture setup. Our phone number is 1-(800) 921-4759. Reporting Guru is a US based development company with all resources located in the US. We have many senior level developers with over a decade of development experience. Please let us know if you would like to discuss your requirements or issues free of charge. Our process is taking your requirements and suggesting the best architecture or approach without trying to sell you any specific software. We work as needed and only charge for the hours we work. We do not charge a retainer and there is no minimum charge. We offer the following services: Custom Report Writing | Consulting | Database Development & Integration. Some of our specialties are: --SQL Server Reporting Services SSRS / SQL Server / SQL Server Integration --Services SSIS / SQL Server Analysis Services SSAS --Custom Application Development / Maintenance --Oracle --MySQL --Crystal Reports / Business Objects --BIRT --.NET Development --PHP Development --SharePoint --Microsoft Dynamics --Access --Excel and Pivot Tables --More! CUSTOM REPORT WRITING Our experienced data report writers take your report & business requirements to build the custom reports you need. We deliver reports on demand or on a timed schedule. CONSULTING When your data and reporting team needs guidance or whether you need to build new reports, convert reports, enhance existing reports or need advice on finding the right reporting solution for your business ReportingGuru is here to help. DATABASE DEVELOPMENT & INTEGRATION We create and develop the necessary structure to house business data in a clear and easily accessible manner, so you have the tools to pull the reports you need easily. CUSTOM SOFTWARE & APPS We also offer custom applications for our clients like our Dashboard Guru and Quickbooks Enterprise Connector http://www.reportingguru.com/products/. Reporting Guru's dashboarding software will give interactivity to static web based reports. Our Quickbooks Connector will pull data from Quickbooks into a database for custom reporting purposes. Connect SQL Developer to Oracle Database http://www.ReportingGuru.com Email us at [email protected] or call 1-(800) 921-4759.
Views: 98759 Reporting Guru
MySQL Part 2 - Telugu
 
08:07
MySQL (Part 2) Connecting to the database and inserting dummy data into the database. mysql_connect("server_addr", "username", "password") - Connect to the Database Server with the authorised user and password. mysql_select_db("database_name") - Selecting a database within a connected database server.
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: 82530 Manish Sharma
Sequelize By Eric Stevens
 
59:35
South East Michigan Javascript Users (http://semjs.org) Presentation Date: November 9, 2015 Location: Ann Arbor, MI Video Presented By: Symphono (http://www.symphono.com) Location Provided By: Nutshell (http://nutshell.com) Abstract: Sequelize is a promise-based ORM for Node.js and io.js making logical connections between our presentation layer and database schema. Sequelize, thankfully, supports most database dialects such as PostgreSQL, MySQL, MariaDB, SQLite and MSSQL making getting started even easier. In this talk I will demonstrate the basics of Sequelize and how to utilize it for your ORM. I'll be presenting using mySQL and Node as our database and framework. We'll cover initial setup, how Sequelize can manage and control your schema, getting data in and out, basic relational mapping, validation, getters and setters, and finally a RESTful API layer with sequelize-restful. Come discover a world of schema, columns, and models leaving the SELECT at home. About the speaker: Eric Stevens is a Senior Web Developer working at Infinite Web Design. He has been working professionally since graduating from Western Michigan University in 2004 with a BA in Information Technology. He has worked at companies such as Plex Systems and Minacs utilizing C#, ASP, Oracle, and MSSQL. His work consists of mostly designing and working in ColdFusion, crafting JavaScript, and teasing data out of mySQL. He enjoys spending time with his lovely wife and three children, exploring the world, and relaxing on the beach. Eric Stevens lives and works in Lake Orion.
Views: 7041 SEM js
SQL Server join :- Inner join,Left join,Right join and full outer join
 
08:11
For more such videos visit http://www.questpond.com Also watch Learn Sql Queries in 1 hour :- https://www.youtube.com/watch?v=uGlfP9o7kmY See our other Step by Step video series below :- Learn Angular tutorial for beginners https://tinyurl.com/ycd9j895 Learn MVC Core step by step :- http://tinyurl.com/y9jt3wkv Learn MSBI Step by Step in 32 hours:- https://goo.gl/TTpFZN Learn Xamarin Mobile Programming Step by Step :- https://goo.gl/WDVFuy Learn Design Pattern Step by Step in 8 hours:- https://goo.gl/eJdn0m Learn C# Step by Step in 100 hours :- https://goo.gl/FNlqn3 Learn Data structures & algorithm in 8 hours :-https://tinyurl.com/ybx29c5s Learn SQL Server Step by Step in 16 hours:- http://tinyurl.com/ja4zmwu Learn Javascript in 2 hours :- http://tinyurl.com/zkljbdl Learn SharePoint Step by Step in 8 hours:- https://goo.gl/XQKHeP Learn TypeScript in 45 Minutes :- https://goo.gl/oRkawI Learn webpack in 50 minutes:- https://goo.gl/ab7VJi Learn Visual Studio code in 10 steps for beginners:- https://tinyurl.com/lwgv8r8 Learn Tableau step by step :- https://tinyurl.com/kh6ojyo Preparing for C# / .NET interviews start here http://www.youtube.com/watch?v=gaDn-sVLj8Q In this video we will try to understand four important concepts Inner joins,Left join,Right join and full outer joins. We are also distributing a 100 page Ebook ".Sql Server Interview Question and Answers". If you want this ebook please share this video in your facebook/twitter/linkedin account and email us on [email protected] with the shared link and we will email you the PDF.
Views: 847574 Questpond
DDL, DML, DCL & TCL statements in SQL (Database basics)
 
09:35
DDL, DML, DCL & TCL statements in SQL (Database basics) Check my blog on this: https://sqlwithmanoj.com/2009/02/10/what-are-ddl-dml-dcl-and-tcl-commands-difference-bw-them/ Check the whole "SQL Server Basics" series here: https://www.youtube.com/playlist?list=PLU9JMEzjCv14f3cWDhubPaddxRvx1reKR Check my SQL blog at: http://sqlwithmanoj.com/ Check my SQL FB Page at: https://www.facebook.com/sqlwithmanoj
Views: 284671 SQL with Manoj
Build ADF Hierarchy Viewer Component using custom built java data control.
 
09:49
Step 1: Create a custom java object to hold the tree node object. I called it as TreeItem in my example. Step 2: Create a custom java control to load the dummy data. Check out the HRTreeData java class for details. Step 3: Open adfc-config.xml, then add a view to the unbounded task flow. Create the view by double clicking the view control. Lets call the view as HViewer.jsf for now. Step 4: Add HRTreeData as a managed bean resource to adfc-config, so that the custom java class is accessible from the view. Step 5: Open the view in design mode, drag and drop Hierarchy Viewer component by selecting ADF Data Visualization option in Component palette window. Step 6: Add the images required to populate the Hierarchy Viewer component, and then right click on the view and run the application. Enjoy and have fun!.
Views: 2750 Raj Venugopal