Home
Search results “Sys views in oracle”
PL/SQL tutorial 67: PL/SQL Ref Cursors In Oracle Database by Manish Sharma
 
04:33
RebellionRider.com presents introduction to PL/SQL Ref Cursors / Cursor Variable in Oracle Database by Manish Sharma ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/ref-cursor-1 Previous Tutorial ►Database Cursor (Playlist): http://bit.ly/2x0JGXz ► Record Datatype (Playlist): http://bit.ly/2xkcHOr ------------------------------------------------------------------------- ►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: 15113 Manish Sharma
Oracle DBA Justin - How to grant a system privilege to a user in an Oracle database
 
11:28
How to grant a system privilege to a user in an Oracle database
Views: 22496 jbleistein11
How to Create Database Link in Oracle. /* Step By Step /*
 
17:21
Today I am showing you. How to create Database link (DB Link) in Oracle. What is Database Link ( DB Link ) ? A database link is a schema object in one database that enables you to access objects on another database. I have 2 databases 1. paragdb 2. orcl In Paragdb database 1. Create listener 2. Service Name 3. In Orcl Database 1. Create Listener 2. Service Name 3. Create new User 4.Grant connect,resource,create database link to username; 5. open user 6. create database link 1. create database link link1 connect to scott identified by tiger using 'connect_primary''; 7.select * from [email protected]; 8. select * from [email protected]; 9. views 1. select * from user_db_links; 2. select * from all_db_links; 10. conn sys as sysdba 11. grant public database link to username; 12. select * from dba_db_links; 13. conn username/pass 14. create public database link plink connect to scott identified by tiger using 'connect_primary'; 15. drop database link. drop database link link1; To follow this steps you will also create oracle database link. It is very easy to understand.
Views: 8889 Parag Mahalle
SQL tutorial 48: How to create Roles in Oracle Database
 
07:16
4th SQL Tutorial in the series of user privileges in oracle database user Roles in Oracle Database. In this tutorial you will learn ● What user roles ● How to create simple roles (Role with Not Identified clause) ● How to create secure roles (Role with Identified clause) ● How to create external role. ● How To create global role. ● How to Grant System Privilege to a user Role ● How to Grant Object Privilege to a user Role In oracle database. ● How to grant a Role to another Role ● How To grant a role to database users (with Admin option) ● How To enable role using SET ROLE statement This video will teach you the concept of user role in oracle database which is an extension to the user privileges. In this video I did 10 SQL queries on user Roles which makes this tutorial fun. Celebrating 1000 subscribers. Thanks a lot guys for all your love and support. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/create_role_in_oracle System Privilege: http://youtu.be/EQzdtKPiErU Object Privilege: http://youtu.be/DuDL7NTPdqQ ------------------------------------------------------------------------- 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: 24427 Manish Sharma
SQL tutorial 38: How to create user using SQL Developer in Oracle database
 
06:52
How to create new user accounts using SQL Developer in oracle database. In This tutorial you will learn how to create a new user account. How to setup a database connection with SyS user. How to grant privileges to the user ----_Links_--- Blog :http://bit.ly/create_user_account Video Tut 4: http://youtu.be/wSqoXRlXDUU How to create database: http://youtu.be/enFFezPYhCg Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 Amazon Wishlist: http://bit.ly/wishlist-amazon Contacts E-Mail [email protected] Twitter https://twitter.com/rebellionrider Instagram http://instagram.com/rebellionrider Facebook. https://www.facebook.com/imthebhardwaj Linkedin. http://in.linkedin.com/in/mannbhardwaj/ Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com
Views: 66698 Manish Sharma
SQL tutorial 46: What are System Privileges & How To Grant them using Data Control Language
 
06:26
In this SQL Tutorial you will learn How To Grant System Privilege using Grant Data Control Language (DCL) along with ADMIN OPTION flag. First SQL Tutorial in the series of user privileges in oracle database ------------------------------------------------------------------------ ►►►Timeline◄◄◄ 1:50- Query 1- How To grant Basic System Privilege (i.e.Create Table system privilege) to a user 2:40- Query 2 - How to Grant Multiple System Privilege To a user in Single Grant (Data Control Language) Statement 3:52- Query 3 - How To grant System Privilege To Multiple Users in Single Grant (Data Control Language) Statement 4:50- Query 4- How To Grant System Privilege WITH ADMIN OPTION flag 5:26- WITH ADMIN OPTION demonstration ------------------------------------------------------------------------ Celebrating 1000 subscribers. Thanks a lot guys for all your love and support. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog (Link for SQL Script is at the end of this article) : http://bit.ly/system_privilege_admin_option Link for How To create user ●SQL Tutorial 37 - Using Create User Statement http://youtu.be/4QbK2Y-1LZw ●SQL Tutorial 38- Using SQL Developer http://youtu.be/GS4udgR44Ls ●SQL Tutorial 39- Using Oracle Enterprise Manager http://youtu.be/zGjh-Bb3HrI List of few System Privileges Available in Oracle Database http://wp.me/p3r6sw-7M Previous Tutorial: Introduction To User Privileges http://youtu.be/iQFb86lM1gs ------------------------------------------------------------------------- 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: 25242 Manish Sharma
How to solve insufficient privileges in oracle and create a new user
 
03:09
This video is about how to solve the error insufficient privileges in oracle and how to create a new user in oracle......... You can use this method for sql developer. After opening sql developer go to command prompt and follow this instruction .... I hope this will help you for solving the insufficient privileges in oracle 10g...... -------------------------------------------------------------------------------- If face any problem then .. Contact/Follow on........ Email : [email protected] Google+ : https://plus.google.com/102074100342156490577 Twitter : https://twitter.com/Alamgir21409730 Facebook : https://www.facebook.com/computersoftwaresolution/ Subscribe this youtube channel : https://www.youtube.com/channel/UCkE_J-tXiqxzASO6nlB8D6w
Views: 7716 Education Help
List all tables in a sql server database using a query  Part 65
 
05:38
Text version of the video http://csharp-video-tutorials.blogspot.com/2013/06/part-65-list-all-tables-in-sql-server.html Slides http://csharp-video-tutorials.blogspot.com/2013/09/part-65-list-all-tables-in-sql-server.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists In this video we will discuss, writing a transact sql query to list all the tables in a sql server database. This is a very common sql server interview question. Object explorer with in sql server management studio can be used to get the list of tables in a specific database. However, if we have to write a query to achieve the same, there are 3 system views that we can use. 1. SYSOBJECTS - Supported in SQL Server version 2000, 2005 & 2008 2. SYS.TABLES - Supported in SQL Server version 2005 & 2008 3. INFORMATION_SCHEMA.TABLES - Supported in SQL Server version 2005 & 2008 -- Gets the list of tables only Select * from SYSOBJECTS where XTYPE='U' -- Gets the list of tables only Select * from SYS.TABLES -- Gets the list of tables and views select * from INFORMATION_SCHEMA.TABLES To get the list of different object types (XTYPE) in a database Select Distinct XTYPE from SYSOBJECTS Executing the above query on my SAMPLE database returned the following values for XTYPE column from SYSOBJECTS IT - Internal table P - Stored procedure PK - PRIMARY KEY constraint S - System table SQ - Service queue U - User table V - View Please check the following MSDN link for all possible XTYPE column values and what they represent. http://msdn.microsoft.com/en-us/library/ms177596.aspx
Views: 92426 kudvenkat
PLS-11: Oracle PL/SQL Reference Cursor
 
08:43
Oracle For Full Course Experience Please Go To http://mentorsnet.org/course_preview?course_id=5 Full Course Experience Includes 1. Access to course videos and exercises 2. View & manage your progress/pace 3. In-class projects and code reviews 4. Personal guidance from your Mentors
Views: 74713 Oresoft LWC
SYS Administer Folders, Oracle Applications Training
 
03:46
This video shows the process for administering folders.
Views: 1721 Larry Sherrod
SQL Error ORA-00942 Table or View Does Not Exist in Oracle Database
 
05:03
How to use Tab View (Data Dictionary) of Oracle Database to solve the SQL Error ORA-00942 Table or View Does Not Exist error in Oracle Database ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/ora-00942 Previous Tutorial ► ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! ------------------------------------------------------------------------- ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ ___Facebook Official Page of Manish Sharma___ https://www.facebook.com/TheRebellionRider/ ___Facebook Official Page of RebellionRider.com___ https://www.facebook.com/RebellionRider.official/ You can also Email me at for E-mail address please check the About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 7730 Manish Sharma
Oracle Database 12c Tutorial 3:Connect HR/SYS user with SQL Developer in Oracle12c Using TNS Service
 
05:24
Learn how to connect HR and Sys User of Oracle database 12c With SQL Developer using TNS service. Connect HR user which is in pluggable database to SQL Developer ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : Previous Tutorial ► Tut 61: How To Unlock HR schema in Oracle Database 12c http://youtu.be/F81gfUnznZY ------------------------------------------------------------------------- ►►►Help Me In Getting A Job◄◄◄ ►Help Me In Getting A Good Job By Connecting With Me on My LinkedIn and Endorsing My Skills. All My Contact Info is Down Below. You Can Also Refer Me To Your Company Thanks ------------------------------------------------------------------------- Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! -------------------------------------------------------------------------- Amazon Wishlist: http://bit.ly/wishlist-amazon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ You can also Email me at [email protected] Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 55551 Manish Sharma
How to create and use database link in Oracle
 
15:50
Database link are used to connect to database which is on different host and different instance, where you cannot use schema.table_name. But it gives you the freedom to manipulate the remote database table as if they are located in you own schema. This is the first part of database link video, on next videos will show you how database link can be used in datawarehousing.
Views: 6448 Subhroneel Ganguly
SYS Form Personalization, Changing a Display Prompt on a Form, Oracle Applications Training
 
02:37
This video shows how to change the display prompt on a form.
Views: 1801 Larry Sherrod
REF CURSOR AND SYS_REFCURSOR IN ORACLE PL/SQL WITH EXAMPLE
 
25:07
This video explains about ref cursor in oracle pl/sql, what are ref cursors, how are ref cursor different from simple cursors, what are the advantages of using a ref cursor etc. The video demonstrates proper and easy to understand examples on ref cursor.
Views: 10811 Kishan Mashru
Oracle SQL  - Connecting as a SYSDBA - Lab
 
02:07
Use this video as a Lab for connecting as a SYSDBA to your Oracle Database.
Views: 8609 Sam Dhanasekaran
How to change SYS/SYSTEM password in 12C-Oracle 12C Administration
 
05:13
How to change SYS/SYSTEM password in 12C-Oracle 12C Administration =================================================== [email protected]= alter session set container=CDB$ROOT; Session altered. [email protected]=show con_id CON_ID ------------------------------ 1 [email protected]= alter user SYSTEM identified by oracle container=all; User altered. [email protected]= alter session set container=pdb1; Session altered. [email protected]= show con_id CON_ID ------------------------------ 3 ============================================= Hi Folks, Greetings!! I am professional part time oracle dba trainer and having good experience in oracle database administration. This is the right place to enroll yourself for Oracle DBA real time course. Please use following email ID for more details. Don’t hesitate to WhatsApp me any time. I will give you the best training and will create path to get DBA job easily. Enjoy the free YouTube video and connect with me for deep Oracle DBA knowledge. Mobile No : + 91 9960262955 (WhatsApp Number) EmailID: [email protected]
Views: 4783 ANKUSH THAVALI
SYS Form Personalization, Displaying a Message in a Form, Oracle Applications Training
 
01:25
This video shows how to display a message to the user using a forms personalization.
Views: 4873 Larry Sherrod
Oracle Database Users / User Management (Simple)
 
09:33
Create, Alter, Drop, Grant Rights, Default Tablespace, Temporary Tablespace, Quota Setup, View Users Information, Lock / Unlock user account select username,account_status,default_tablespace, temporary_tablespace,created from dba_users; create user myuser identified by myuser; alter user myuser quota unlimited on mytbs; alter user myuser quota 100m on mytbs; alter user temporary tablespace temp; alter user myuser default tablespace mytbs; alter user myuser accout unlock; alter user myuser account lock; alter user myuser password expire; alter user myuser identified by youuser; create user myuser identified by myuser default tablespace users temporary tablespace temp quota unlimited on users; grant create session, resource to myuser; grant create session, resource to myuser with grant option; drop user asif; drop user asif cascade;
Views: 41735 Abbasi Asif
Oracle DBA - Manage Users, Roles & Privileges | User Management
 
07:44
Thanks for Watching please Like, Subscribe and Share... BoxCut Media.
Views: 28562 BoxCut Media
Oracle Database tutorials 4:  database connectivity using SQL developer and command prompt
 
09:19
Blog Link: http://bit.ly/how-to-create-new-connection-in-sql-developer Wishlist: http://bit.ly/wishlist-amazon This SQL tutorial and Oracle database 11g tutorial for beginners will show how to connect to database either on a local machine or on a machine in your LAN using ip address. Tool used in this tutorial is SQL developer & command prompt. This tutorial series is part of SQL expert exam certification training. If you are preparing for SQL certification you can use my tutorials. This SQL Tutorial is a part of free training. Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=j7eYO7 Contacts Email [email protected] Twitter https://twitter.com/rebellionrider Instagram http://instagram.com/RebellionRider Facebook. https://www.facebook.com/imthebhardwaj Linkedin. in.linkedin.com/in/mannbhardwaj/ Thanks for linking, commenting, sharing and watching more of our videos The Code makers
Views: 282716 Manish Sharma
SQL tutorial 41: How to UNLOCK USER in oracle Database
 
04:13
SQL tutorial on How to unlock user or schema in oracle database or how to unlock hr account/user/schema in oracle database using alter user SQL command. you can use the steps to change the password of any user in oracle database explained in detail. Celebrating 1000 subscribers. Thanks a lot guys for all your love and support. ------------------------------------------------------------------------- Blog Link: http://bit.ly/unlock-user-in-oracle -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the first one to see my ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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/ 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: 39867 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: 361257 Chitu Okoli
Get Table Names with Column Names and Data Types in SQL Server - SQL Server Tutorial
 
05:47
In this video ,we will generate the script that will return us all the table names with column names and data type of those columns. We often need this information. Let's say we are going to prepare mapping document for load the data from Source Database to Destination database. We can get the list of all tables with column names and data types from Source Database and Destination Database and then paste in Excel and map the required input columns to output columns for ETL Process. Blog link with scripts used in video http://sqlage.blogspot.com/2015/02/get-all-tables-with-column-names-and.html
Views: 49571 TechBrothersIT
How to Unlock Accounts and Reset New Passwords for (SYSTEM & SYS) Oracle DB 12C in Windows 10
 
04:03
Using SQL*Plus How to change system password Oracle DB 12c Release 2 (12.2.0.1.0) How To Recover a Lost Password on Oracle How to Fix an Oracle User's Password When It Has Expired START SERIES FROM THE BEGINNING: https://goo.gl/kXkmdp WATCH THE NEXT VIDEO: GO TO THE HINDI YOUTUBE CHANNEL: https://goo.gl/gTHiw2 SUBSCRIBE: https://goo.gl/LjKGzc I am Willing Make a Website, if YOU WANT ME TO MAKE A VIDEOS ON Different Technologies/field I WILL DO IT.. Watch Others Videos and Have any Queries Email to me on ([email protected]) ####--------------------------­------------------------------­------------------------------­#### Subscribe to Cloud Network :- http://goo.gl/LjKGzc Website :- http://www.cloudnetwork.in Like us on Facebook :- http://facebook.com/itcloudnetwork Follow us on Twitter :- http://twitter.com/itcloudnet Circle us on Google+ :- https://goo.gl/StVdHb Add us on LinkedIn :- http://in.linkedin.com/pub/itcloudnet Skype Id :- cloud.network1 E-Mail Id :- [email protected] ####--------------------------­------------------------------­------------------------------­--#### Thanking You Hope U Like it........
Views: 788 Cloud Network
DYNAMIC SQL WITH EXECUTE IMMEDIATE IN ORACLE PL/SQL WITH EXAMPLE
 
21:53
The audio and video now synced. Ever tried creating a table inside a PL SQL block, or a function or a procedure? If yes, then you would know that it would raise an error, as DDL statements are not allowed inside a PL/SQL Block. So the solution to such a case, where you want to generate tables, or sequences or want to execute any DDL statement on the fly, then use synamic sql. Dynamic SQL statment will allow you to create state statements on the fly and then you can execute them using the execute immediate statement. This video tutorial demonstrates on this topic of using synamic sql with execute immediate in a PL/SQL block.
Views: 5159 Kishan Mashru
How To Install MySQL on Windows 10
 
24:18
In this post we will learn how to How To Install MySQL on Windows 10. The same procedure can be used for installing MySQL on Windows 8 / Windows 7. But first let's see What is MySQL . MySQL is a very popular, open source database. Officially pronounced “my Ess Que Ell” (not my sequel). Handles very large databases; very fast performance. Why are we using MySQL? Free (much cheaper than Oracle!) Each student can install MySQL locally. Easy to use Shell for creating tables, querying tables, etc.Easy to use with Java JDBC. While installing MySQL, it will prompt you to create a root password . At this stage please select a safe and secure password . Make sure you remember the password, to use it later.MySQL tutorial for beginners and professionals with examples on CRUD, insert statement, select statement, update statement, delete statement, use database, keys, joins etc. -------------------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: 615650 ProgrammingKnowledge
Oracle Training - Accounts Payable in Oracle E-Business Suite R12 (1080p - HD)
 
12:00
http://www.i-oracle.com/ - Oracle Training and Tutorials - Learn how to enter and pay an invoice in Oracle Applications E-Business Suite R12. Use the R12 interface to also match the invoice to a Purchase Order, validate and approve the invoice. View Subledger Accounting (SLA) transactions, view invoice details. And many more.
Views: 390890 Yemi Onigbode
Oracle SQL Tutorials 47 ll Categories of Data Dictionary Views Theory
 
18:22
CREATE TABLE command in sql/oracle,INSERT command in sql/oracle UPDATE,ALTER PASSWORD command in sql, GRANT command, REVOKE command i, CREATE SYNONYM command in sql/oracle, DELETE command in sql/oracle, ALTER TABLE command in sql/oracle, DROP TABLE command in sql/oracle, CREATE INDEX command in sql/oracle, ALTER INDEX command in sql/oracle, DROP INDEX command in sql/oracle, CREATE VIEW command in sql/oracle, DROP VIEW command in sql/oracle, USING SQL COMMAND Types of SQL Commands The following sections discuss the basic categories of commands used in SQL to perform various functions. These functions include building database objects, manipulating objects, populating database tables with data, updating existing data in tables, deleting data, performing database queries, controlling database access, and overall database administration. The main categories are DDL (Data Definition Language) DML (Data Manipulation Language) DQL (Data Query Language) DCL (Data Control Language) Data administration commands Transactional control commands Defining Database Structures Data Definition Language, DDL, is the part of SQL that allows a database user to create and restructure database objects, such as the creation or the deletion of a table. Some of the most fundamental DDL commands discussed during following hours include the following: CREATE TABLE ALTER TABLE DROP TABLE CREATE INDEX ALTER INDEX DROP INDEX CREATE VIEW DROP VIEW Manipulating Data Data Manipulation Language, DML, is the part of SQL used to manipulate data within objects of a relational database. There are three basic DML commands: INSERT UPDATE DELETE Selecting Data Though comprised of only one command, Data Query Language (DQL) is the most concentrated focus of SQL for modern relational database users. The base command is as follows: SELECT This command, accompanied by many options and clauses, is used to compose queries against a relational database. Queries, from simple to complex, from vague to specific, can be easily created. The SELECT command is discussed in exhilarating detail during Hours 7 through 16. A query is an inquiry to the database for information. A query is usually issued to the database through an application interface or via a command line prompt. Data Control Language Data control commands in SQL allow you to control access to data within the database. These DCL commands are normally used to create objects related to user access and also control the distribution of privileges among users. Some data control commands are as follows: ALTER PASSWORD GRANT REVOKE CREATE SYNONYM You will find that these commands are often grouped with other commands and may appear in a number of different lessons throughout this book. Data Administration Commands Data administration commands allow the user to perform audits and perform analyses on operations within the database. They can also be used to help analyze system performance. Two general data administration commands are as follows: START AUDIT STOP AUDIT Do not get data administration confused with database administration. Database administration is the overall administration of a database, which envelops the use of all levels of commands. Database administration is much more specific to each SQL implementation than are those core commands of the SQL language. Transactional Control Commands In addition to the previously introduced categories of commands, there are commands that allow the user to manage database transactions. COMMIT Saves database transactions ROLLBACK Undoes database transactions SAVEPOINT Creates points within groups of transactions in which to ROLLBACK SET TRANSACTION Places a name on a transaction Transactional commands are discussed extensively during Hour 6, "Managing Database Transactions."
Quickly Navigating Between Objects in Oracle SQL Developer
 
03:38
A couple of tricks for navigating from an Oracle Database table to its related objects such as indexes and triggers, and back. Plus how to jump to an object from your PL/SQL code.
Views: 1837 Jeff Smith
SQL tutorial 47: How to Grant Object Privileges With Grant Option in Oracle Database
 
07:13
In this SQL Tutorial you will learn How To Grant Object Privilege using Grant Data Control Language (DCL) statement along with GRANT OPTION flag. Third SQL Tutorial in the series of user privileges in oracle database ------------------------------------------------------------------------ ►►►Timeline◄◄◄ 1:06- Query 1- How To grant Basic Object Privilege (i.e.SELECT Object privilege) to a user 3:31- Query 2 - How to Grant Multiple Object Privilege To a user in 4:26- Query 3 - How To grant Object Privilege on Column Level 5:30- Query 4- How To Grant System Privilege WITH GRANT OPTION flag 6:06- WITH ADMIN OPTION demonstration ------------------------------------------------------------------------ Celebrating 1000 subscribers. Thanks a lot guys for all your love and support. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ List of Object Privilege http://bit.ly/list_of_object_privileges Object Privileges Blog http://bit.ly/object_privileges-in-oracle-database Previous Tutorial System Privilege: http://youtu.be/EQzdtKPiErU Introduction to user privilege: http://youtu.be/iQFb86lM1gs ------------------------------------------------------------------------- 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: 24160 Manish Sharma
Auditing in Oracle 11g
 
10:43
Auditing in Oracle database will help you to what a user doing??
Views: 4934 Athar Fahad
Analyzing Privilege Use by a User Who Has the Oracle DBA Role
 
03:40
In this video you see how to analyze the use the system and object privilege use of a user who has been granted the DBA role and who performs database tuning operations. Copyright © 2014 Oracle and/or its affiliates. Oracle® is a registered trademark of Oracle and/or its affiliates. All rights reserved. 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 of merchantability, fitness for a particular purpose, and non-infringement.
ALTER Command (DDL) in SQL with Implementation on ORACLE
 
13:09
► Link for All Types of SQL Commands (DDL, DML, DCL, TCL): https://www.youtube.com/watch?v=vUj-kUEC_oA ► Link for Database Management System Playlist- https://www.youtube.com/playlist?list=PLxCzCOWd7aiFAN6I8CuViBuCdJgiOkT2Y ► Link for Computer Networks Playlist- https://www.youtube.com/playlist?list=PLxCzCOWd7aiGFBD2-2joCpWOLUrDLvVV_ ► Link for Operating System Playlist- https://www.youtube.com/playlist?list=PLxCzCOWd7aiGz9donHRrE9I3Mwn6XdP8p ► Link for Graph Theory Playlist- https://www.youtube.com/playlist?list=PLxCzCOWd7aiG0M5FqjyoqB20Edk0tyzVt ► Last Minutes Preparation for UGC NET and GATE Playlist- https://www.youtube.com/playlist?list=PLxCzCOWd7aiE4LQMkIhAe9amWX_SPNMiZ ------------------------------------------------------------------------------------------------- Our Social Links: ► Subscribe to our YouTube channel: https://www.youtube.com/gatesmashers ► Like Our page on Facebook - https://www.facebook.com/gatesmashers/ ► For any Query and Suggestions- [email protected]
Views: 675 Gate Smashers
How to Generate Oracle ER Diagrams Using PL/SQL Developer & Oracle SQL Developer?
 
05:35
This Video Will Teach you.. How to Generate Oracle ER Diagrams Using PL/SQL Developer & Oracle SQL Developer? Document Attached @ https://github.com/arulxaviers/Generate_ER_Diagram_SQL_Developer how to generate erd from sql developer how to generate er diagram using pl/sql developer how to generate er diagram using sql developer data modeler sql developer data modeler download how to generate er diagram using pl/sql developer how to generate er diagram using toad how to generate er diagram using sql server management studio oracle sql developer data modeler reporting repository required. generate er diagram from sql server how to generate er diagram using oracle sql developer
Views: 7639 Oracle PL/SQL World
Oracle Sys Connect By Path
 
09:41
Oracle Sys Connect By Path
Views: 22 Nook Tutorials
How to Reset Forgotten Oracle Database SYS AS SYSDBA Password on Windows 7
 
04:14
How to Reset Forgotten Oracle Database SYS AS SYSDBA Password on Windows 7 Contact: రవి కుమార్ . లంకె Ravi kumar Lanke Blog: www.installationbyravi.co.in Gmail : [email protected] Yahoo : [email protected]
Views: 82702 Ravikumar Lanke
INTRODUCTION TO VIEWS PART 1
 
29:01
What is a View Uses of View SECURITY BACKWARD COMPATABILITY PERFORMANCE Types of View Indexed View Partitioned View System View User Defined View Create a View Modify a View Delete a View
Stored procedures in sql server   Part 18
 
20:11
In this video we will learn 1. What is a stored procedure 2. Stored Procedure example 3. Creating a stored procedure with parameters 4. Altering SP 5. Viewing the text of the SP 6. Dropping the SP 7. Encrypting stored procedure Text version of the video http://csharp-video-tutorials.blogspot.com/2012/08/stored-procedures-part-18.html Slides http://csharp-video-tutorials.blogspot.com/2013/08/part-18-stored-procedures.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 758130 kudvenkat
SQL with Oracle 10g XE - Creating a New User
 
02:21
In this video I log into the Oracle 10g XE database with the SYSTEM user and create a new user under the Administration section. When I create the new user I grant them all the rights as well as make than a Database Administrator. This video is part of a series of videos with the purpose of learning the SQL language. For more information visit Lecture Snippets at http://lecturesnippets.com.
Views: 26770 Lecture Snippets
How to connect with Pluggable Database using SQL Developer by Manish Sharma
 
12:07
RebellionRider.com presents Oracle Database 18c tutorial 4 on how to connect with Pluggable Database (PDB) through sample user like HR using SQL Developer. How to install SQL Developer https://youtu.be/zliF8kXVmeE Timestamp ● 00:59 Start Must Listen ● 01:42 How to create a basic connection ● 09:17 How to create a connection with TNS alias ● 10:53 How to connect with PDB using the above mentioned connections ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/pdb-with-SQLDev Previous Tutorial ► Oracle Database 18c Tutorial 2 https://youtu.be/maLrgeY0InA ► Oracle Database 18c Tutorial 3 https://youtu.be/z0dfSom97GU ------------------------------------------------------------------------- ►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 #Oracle18cByRebellionRider #RebellionRider
Views: 2070 Manish Sharma
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: 54857 Manish Sharma
Oracle DBA Justin - How to reset a user accounts password in an Oracle database
 
11:26
How to reset a user accounts password in an Oracle database
Views: 22005 jbleistein11
How to Resolve Oracle SQL Parent Key Not Found (ORA-02291)
 
05:49
In this video, we’ll explain what the ORA-02291 “parent key not found” error is, see an example, and look at how to resolve it. This error usually happens when we try to insert data into a table. It looks like this: Error is: ORA-02291: integrity constraint (constraint_name) violated - parent key not found So what does this error mean? It means we’re trying to insert data into a child table, and there is no related record in the parent table. If a foreign key has been set up to enforce this relationship, there needs to be a parent to insert a child that refers to it. Watch the video to see an example of this error as well as how to resolve it. For more information on Oracle SQL, refer to the Database Star website here: https://www.databasestar.com/
Views: 3585 Database Star
Oracle PL/SQL Tutorials | Set Commands in SQL*Plus:SQL*Plus Settings | by Mr.Vaman Deshmukh
 
13:25
Oracle PL/SQL Tutorials | Set Commands in SQL*Plus:SQL*Plus Settings | by Mr.Vaman Deshmukh ** For Online Training Registration: https://goo.gl/r6kJbB ► Call: +91-8179191999 ► Visit Our Website for Classroom Training: https://nareshit.in ► For Online Training: https://nareshit.com/ #OraclePLSQLTutorials #SQL*PlusSettingsTutorials #PLSQLTutorials -------------------------- ► About NareshIT: "Naresh IT is having 14+ years of experience in software training industry and the best Software Training Institute for online training, classroom training, weekend training, corporate training of Hadoop, Salesforce, AWS, DevOps, Spark, Data Science, Python, Tableau, RPA ,Java, C#.NET, ASP.NET, Oracle, Testing Tools, Silver light, Linq, SQL Server, Selenium, Android, iPhone, C Language, C++, PHP and Digital Marketing in USA,Hyderabad, Chennai and Vijayawada,Bangalore India which provides online training across all the locations -------------------------- ► Our Online Training Features: 1.Training with Real-Time Experts 2.Industry Specific Scenario’s 3.Flexible Timings 4.Soft Copy of Material 5. Share Videos of each and every session. -------------------------- Please write back to us at [email protected]/[email protected] or Call us at USA: +1404-232-9879 or India: +918179191999 ** Check The Below Links** ► For Course Reg: https://goo.gl/r6kJbB ► Subscribe to Our Channel: https://goo.gl/q9ozyG ► Circle us on G+: https://plus.google.com/NareshIT ► Like us on Facebook: https://www.facebook.com/NareshIT ► Follow us on Twitter: https://twitter.com/nareshitech ► Follow us on Linkedin: https://in.linkedin.com/company/naresh-i-technologies ► Follow us on Instagram: https://www.instagram.com/nareshitech/
ORACLE WORLD - How to Deinstall the Oracle database software from a Windows operating system
 
14:35
Hello friends today let me showing to you that how to deinstall or remove oracle database software from windows 7 operating system. Oracle database Unbeatable,Unbreakable Platform.. #DeinstallOracledatabase #Windowsoperatingsystem By Lalit saini
Views: 367 Oracle World
Oracle DBA Justin - How to revoke a system privilege from a user in an Oracle database
 
06:29
How to revoke a system privilege from a user in an Oracle database
Views: 2271 jbleistein11
JSON in Oracle 12C Part 1 - Creating JSON Columns in Tables
 
09:20
This is the first video in a series of videos on how to handle JSON data in Oracle 12C. In this video, I'll show you how to create columns in a table that will be used to hold JSON data.
Views: 5109 Pretty Printed
Tutorial#2- how to Install Oracle SQL Database 11g
 
07:54
Oracle SQL tutorial on how to install Oracle database 11g on windows, its best video for Oracle SQL beginner ------------------------------------------------------------------------ Oracle SQL practice question : Install Oracle data base with four user HR , Scott , SYS , SYSTEM ------------------------------------------------------------------------ Frequently asked interview question on Oracle SQL https://www.youtube.com/watch?v=f7E30fV8wJA&index=1&list=PLiLpmqwkwkCv4qmtBnz4M3zIs1_ukkboT In this series we cover the following topics: SQL basics, create table oracle, SQL functions, SQL queries, SQL server, SQL developer installation, Oracle database installation, SQL Statement, OCA, Data Types, Types of data types, SQL Logical Operator, SQL Function,Join- Inner Join, Outer join, right outer join, left outer join, full outer join, self-join, cross join, View, SubQuery, Set Operator. follow me on: Facebook Page: https://www.facebook.com/LrnWthr-319371861902642/?ref=bookmarks Contacts Email: [email protected] Instagram: https://www.instagram.com/lrnwthr/ Twitter: https://twitter.com/LrnWthR
Views: 458 EqualConnect Coach