Home
Search results “Oracle invalid common user”
How to Create Users in Oracle 12c
 
03:42
Ho to create users in Oracle. Solution error SQL Error: ORA-65096: invalid common user or role name. http://onlymastermind.blogspot.com/ Twitter:https://twitter.com/zubair007khan skype:zubair007khan
ORA-65096,ORA 1994 - privilege issues in oracle database
 
13:21
In this video , you will learn how to troubleshoot user privilege issues in a oracle database.If you like this video ,please subscribe!!
Views: 307 tech nizan
Create Scott user in Oracle 12c & ORA-65096: resolve invalid common user or role name
 
04:17
In this video you can learn how to create new user in Oracle 12c, also how to resolve common user create error To create user- create user scott identified by 123; --to resolve error -- ORA-65096: invalid common user or role name alter session set "_ORACLE_SCRIPT"=true; --Grant all access to user- grant all privileges to scott find TNSName file here- C:\app\sys\product\12.1.0\dbhome_1\network\admin\tnsnames.ora (based on the installation directory you chose during installation) --Create sample tables in scott user- ---------------------------------------- CREATE TABLE EMP (EMPNO NUMBER(4) NOT NULL, ENAME VARCHAR2(10), JOB VARCHAR2(9), MGR NUMBER(4), HIREDATE DATE, SAL NUMBER(7, 2), COMM NUMBER(7, 2), DEPTNO NUMBER(2)); INSERT INTO EMP VALUES (7369, 'SMITH', 'CLERK', 7902, TO_DATE('17-DEC-1980', 'DD-MON-YYYY'), 800, NULL, 20); INSERT INTO EMP VALUES (7499, 'ALLEN', 'SALESMAN', 7698, TO_DATE('20-FEB-1981', 'DD-MON-YYYY'), 1600, 300, 30); INSERT INTO EMP VALUES (7521, 'WARD', 'SALESMAN', 7698, TO_DATE('22-FEB-1981', 'DD-MON-YYYY'), 1250, 500, 30); INSERT INTO EMP VALUES (7566, 'JONES', 'MANAGER', 7839, TO_DATE('2-APR-1981', 'DD-MON-YYYY'), 2975, NULL, 20); INSERT INTO EMP VALUES (7654, 'MARTIN', 'SALESMAN', 7698, TO_DATE('28-SEP-1981', 'DD-MON-YYYY'), 1250, 1400, 30); INSERT INTO EMP VALUES (7698, 'BLAKE', 'MANAGER', 7839, TO_DATE('1-MAY-1981', 'DD-MON-YYYY'), 2850, NULL, 30); INSERT INTO EMP VALUES (7782, 'CLARK', 'MANAGER', 7839, TO_DATE('9-JUN-1981', 'DD-MON-YYYY'), 2450, NULL, 10); INSERT INTO EMP VALUES (7788, 'SCOTT', 'ANALYST', 7566, TO_DATE('09-DEC-1982', 'DD-MON-YYYY'), 3000, NULL, 20); INSERT INTO EMP VALUES (7839, 'KING', 'PRESIDENT', NULL, TO_DATE('17-NOV-1981', 'DD-MON-YYYY'), 5000, NULL, 10); INSERT INTO EMP VALUES (7844, 'TURNER', 'SALESMAN', 7698, TO_DATE('8-SEP-1981', 'DD-MON-YYYY'), 1500, 0, 30); INSERT INTO EMP VALUES (7876, 'ADAMS', 'CLERK', 7788, TO_DATE('12-JAN-1983', 'DD-MON-YYYY'), 1100, NULL, 20); INSERT INTO EMP VALUES (7900, 'JAMES', 'CLERK', 7698, TO_DATE('3-DEC-1981', 'DD-MON-YYYY'), 950, NULL, 30); INSERT INTO EMP VALUES (7902, 'FORD', 'ANALYST', 7566, TO_DATE('3-DEC-1981', 'DD-MON-YYYY'), 3000, NULL, 20); INSERT INTO EMP VALUES (7934, 'MILLER', 'CLERK', 7782, TO_DATE('23-JAN-1982', 'DD-MON-YYYY'), 1300, NULL, 10); CREATE TABLE DEPT (DEPTNO NUMBER(2), DNAME VARCHAR2(14), LOC VARCHAR2(13) ); INSERT INTO DEPT VALUES (10, 'ACCOUNTING', 'NEW YORK'); INSERT INTO DEPT VALUES (20, 'RESEARCH', 'DALLAS'); INSERT INTO DEPT VALUES (30, 'SALES', 'CHICAGO'); INSERT INTO DEPT VALUES (40, 'OPERATIONS', 'BOSTON'); CREATE TABLE BONUS (ENAME VARCHAR2(10), JOB VARCHAR2(9), SAL NUMBER, COMM NUMBER); CREATE TABLE SALGRADE (GRADE NUMBER, LOSAL NUMBER, HISAL NUMBER); INSERT INTO SALGRADE VALUES (1, 700, 1200); INSERT INTO SALGRADE VALUES (2, 1201, 1400); INSERT INTO SALGRADE VALUES (3, 1401, 2000); INSERT INTO SALGRADE VALUES (4, 2001, 3000); INSERT INTO SALGRADE VALUES (5, 3001, 9999); CREATE TABLE DUMMY (DUMMY NUMBER); INSERT INTO DUMMY VALUES (0); COMMIT; --------------------------- Please Like share and subscribe if the content helped you. Also please tell me if you want to see some content. I am an Engineer working in MNC. I live in Noida, love to explore new things. My Instagram account- isthat_shubh My Facebook Account- https://www.facebook.com/samratshubham
Views: 111 Shubham Garg
create user in oracle 12c database and difference between container and pluggable database
 
10:09
This video explains- 1. Difference between plug-gable database and container database 2. How to create user in container DB 3. How to create user in plug-gable database 4. what errors you might face in the process and solutions for those errors. You may refer my other video to install oracle 12c if you want to install the s/w and want to create database.
Views: 9090 Tech Group
Oracle DBA - Manage Users, Roles & Privileges | User Management
 
07:44
Thanks for Watching please Like, Subscribe and Share... BoxCut Media.
Views: 30342 BoxCut Media
how to install Oracle 12c and setting up new user accounts , a perfect solution
 
13:53
you can download oracle 12c from the website here.. http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html
Views: 104138 how to get installed?
Oracle DBA Justin - How to create a basic user account in an Oracle database
 
11:57
How to create a basic user account in an Oracle database
Views: 21249 jbleistein11
Oracle Database Startup Issues Memory Target Parameter
 
06:44
NewayITSolutions: Oracle Database Startup Issues: Memory Target cannot be used. Learn how easy it is to make $100k and above by becoming an Oracle Database Administrator. Website: https://newayitsolutions.com Subscribe: https://newayitsolutions.com/page Enroll: https://newayitsolutions.com/enroll Youtube: newayitsolutions ------------------------------------------------------------------------------------------------------------------------------------------------------------- Follow on Facebook: https://www.facebook.com/newayitsolutions/ Follow on Twitter: https://twitter.com/Theoracledbaguy Follow on Instagram: https://www.instagram.com/oracledbatrainer/ Financing Available: https://newayitsolutions.com/loan-application School Locations: Atlanta, Maryland, Virginia ------------------------------------------------------------------------------------------------------------------------------------------------------------- Office Contact: 1-866-569-0205 Mobile Contact: 240-244-9935
Views: 3429 NewayITSolutions LLC
Oracle username and password and Account unlocking
 
08:37
all education purpose videos
Views: 290611 Chandra Shekhar Reddy
Error: CS1617: Invalid option 6 for langversion
 
03:12
I was upgrading my MVC app from MVC 4 to MVC 5 in visual studio 2013 then eventually got message CS1617: Invalid option '6' for langversion. I looked into issue very closely and then finally come up with the right solution. I am here demonstrating complete resolution with you. Error Description: Invalid option '6' for /langversion; must be ISO-1, ISO-2, 3, 4, 5 or Default
Views: 1149 Technology Crowds
How to Fix All .DLL file Missing Error in Windows PC (windows 10/8.1/7)
 
01:52
Fix all missing dll files in windows 10/8.1/7 Click here for more detail... http://www.bsocialshine.com/2016/06/how-to-fix-all-dll-file-missing-error.html D3dx9_43.dll error, D3dx9_41.dl, D3dx9_42.dll, D3dx9_31.dll, d3dx9_39.dll, D3dcompiler_43.dll, d3dx9_43.dll error - d3dx10_43.dll error, d3dx9_43.dll, d3dx10_43.dll, d3dx9_43.dll, d3dx9_42.dll, d3dx9_30.dll, d3dx9_39.dll, binkw32.dll, 2004utils.dll 2057.dll 20sys_r.dll 20utl_r.dll 240197.dll 24cents.dll 25d4315.dll 28_83260.dll 2bp.dll 2dcolormode.dll 2dfilter.dll 2dintmmx.dll 2dmgr10.dll 2dmgr100.dll 2mouse16.dll 2mouse32.dll 2_0_1browserhelper2.dll 3 cuts per beat.dll 311.dll 31x5lc04.dll 31x5ls04.dll 31x5rc04.dll 32 cuts per beat.dll 324aud32.dll 33a76.dll 34api.dll 34coinstaller.dll 3894fc.dll 3dfx32v3.dll 3dfx32vb.dll 3dfxgl_ht2.dll 3dfxis16.dll 3dfxis32.dll 3dnaxtrasupp.dll 3dogldrv.dll 3douninst.dll 3dpcdll.dll 3dpmotioneffectsvst.dll 3dpolygoncruncherplugin.dll 3dprocpl.dll 3dr.dll 3dr32.dll 3dr332.dll
Views: 1525787 MJ Tube
HOW TO CREATE DATABASE USER IN ORACLE  10G  SOFTWARE
 
05:40
THIS VIDEO WILL TECH YOU HOW TO CREATE DATABASE USER IN ORACLE 10G SOFTWARE . --------------------------------------------------------------------------------------------------------- create user and grant privileges in oracle oracle create user example oracle create user schema invalid common user or role name create user in oracle 12c oracle grant create session oracle delete user create user sql
Views: 367 Creative Things
Oracle Database User Create by Sqlplus
 
12:16
Oracle Database User Create by Sqlplus
How to create an user and to grant all privileges to them in Oracle database
 
03:52
This video shows you how to create a new user and to grant privileges to them. Syntax to create a new user: create user username identified by password
Views: 39352 Thamizharasan Mohan
Oracle Database Tutorial 70: IO ERROR: The network adapter could not establish the connection
 
03:34
IO ERROR: The network adapter could not establish the connection Learn how to solve this Oracle Database / SQL Developer Error with in 4 minutes ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/sql-developer-error-the-network-adapter-could-not-establish-the-connection Previous Tutorial ► Intersect and Minus SQL set operators https://youtu.be/sDZFpwEw1k8 ------------------------------------------------------------------------- ►►►Let's Get Free Uber Cab◄◄◄ Use Referral Code UberRebellionRider and get $20 free for your first ride. ------------------------------------------------------------------------- ►►►Help Me In Getting A Job◄◄◄ ►Help Me In Getting A Good Job By Connecting With Me on My LinkedIn and Endorsing My Skills. All My Contact Info is Down Below. You Can Also Refer Me To Your Company Thanks ------------------------------------------------------------------------- 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! -------------------------------------------------------------------------- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►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 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: 168656 Manish Sharma
Create User and Connecting With SQLPLUS in Oracle SQL Developer Using Command Prompt
 
06:08
Facebook : https://www.facebook.com/ala.hassine.10 Email : [email protected] Page Facebook Système Embarqué : https://www.facebook.com/NewEmbeddedSystem ============================= ============================= The commands used in the video : sqlplus / as sysdba CREATE USER Name IDENTIFIED BY password; GRANT ALL PRIVILEGES TO Name; GRANT EXECUTE ANY PROCEDURE TO Name; GRANT UNLIMITED TABLESPACE TO Name; GRANT CREATE SESSION TO Name; CREATE ROLE role_Name; GRANT CREATE ANY TABLE, ALTER ANY TABLE, DROP ANY TABLE TO role_Name; GRANT SELECT ANY TABLE, INSERT ANY TABLE, UPDATE ANY TABLE, DELETE ANY TABLE TO role_Name; GRANT CREATE ANY TRIGGER, ALTER ANY TRIGGER, DROP ANY TRIGGER TO role_Name; GRANT CREATE ANY SEQUENCE, ALTER ANY SEQUENCE, DROP ANY SEQUENCE TO role_Name; GRANT SELECT ANY SEQUENCE TO role_Name; GRANT CREATE ANY INDEX, ALTER ANY INDEX, DROP ANY INDEX TO role_Name; GRANT CREATE ANY PROCEDURE TO role_Name; GRANT role_Name TO Name; exit sqlplus / as sysdba exit sqlplus Name/Password ============================= ============================= CREATE TABLE employee ( empno number PRIMARY KEY, empname varchar2(70) UNIQUE, address varchar2(70), salary number NOT NULL ) ============================= insert into employee values(1,'Ala','Nabeul',1500); insert into employee values(2,'Ahmed','Tunis',2000); insert into employee values(3,'Ritej','Sfax',1700); insert into employee values(4,'Majdi','Sousse',3000); insert into employee values(5,'Raed','Bizert',2500); insert into employee values(6,'Yasser','Mahdia',1900); ============================= select * from employee;
Views: 58 Système EmbarQué
ORA-65096 nombre de usuario o rol comun no valido
 
00:56
Solución al error ORA-65096. Antes de crear el usuario deben colocar esta línea de código, y luego se crea el usuario sin problemas. alter session set"_ORACLE_SCRIPT"=true;
How to find out the SID and DB Home in Oracle Database by Manish Sharma
 
05:10
What is my SID, Where is my DB Home in Oracle Database? Are these questions haunting you? Here's How to find out the SID and DB Home in Oracle Database by Manish Sharma from RebellionRider ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/sid_dbHome Previous Tutorial ► How to connect to your Pluggable Database using SQL Developer https://youtu.be/1gvN1A6xnxU ------------------------------------------------------------------------- ►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: 1944 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: 378307 Chitu Okoli
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: 69543 Manish Sharma
How to Unlock scott/tiger Oracle | Bilal Creator
 
02:01
Oracle username and password and Account unlocking follow the steps in video to unlock accout. ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- sqlplus/nolog connect [email protected] LabAdmin786 alter user scott account unlock identified by tiger; ************ scott/tiger ************ ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- Check out the more videos & Don't Forget to SUBSCRIBE : https://www.youtube.com/channel/UCBAi_1WL19MEqrWoDIGEDvw?view_as=subscriber ----------------------------------------------------------------------------- bilal creator,animation,sql,rebellion rider,rebellionrider,sql tutorials,pl/sql tutorials,pl/sql,oracle dba tutorials,oca,ocp,sql expert,sql developer,sql tutorials for beginners,sql expert tutorials,the code makers,how to,oracle 12c,windows 10,windows 10 tutorial,install 12c on windows 10,install oracle 12c on windows 10 professional 64 bit,sqlplus,oracle 12c database full installation 64 bit | bilal creator,oracle,how to unlock scott/tiger oracle | bilal creator,oracle 12c database full installation 64 bit | bilal creator,oracle username and password and account unlocking,chandu 2035,chandu.2035,chandu2035 video,oracle username and password,oracle scott user unlock,oracle user unlock,oracle 12c,fix,oracle,how to,sql,sqlplus,sqlplus unlock,how to unlock sqlplus,how to unlock oracle,username and password sqlplus,scoutt tiger error,sys as sysdba,sql+ ----------------------------------------------------------------------------- How to Unlock scott/tiger Oracle | Bilal Creator
Views: 104 Bilal Creator
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: 5652 ANKUSH THAVALI
How to fix "insufficient privileges to access this directory" error
 
02:23
Problem: While installing a program, the user receives the following error message: "The installer has insufficient privileges to access this directory". Solution: 1. manually create the required folder, 2. download the compressed registry file : ► https://drive.google.com/open?id=0Bw-8fzdMfWSFREZUTzZqNFROWkk 3. extract the contents to a folder you like, 4. double-click the "Take Ownership.reg" file to add it to the Windows Registry, 5. go to the folder that you manually created, right-click on it, click "Take ownership" 6. try to continue the setup, click Retry.
Views: 167046 furulevi
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: 57866 Manish Sharma
SQL tutorial 37: How to create NEW USER account using Create User statement in Oracle database
 
07:39
How to create new user accounts using Oracle Create User statement Of Oracle database. In This tutorial, you will learn how to create a new user account. Brief explanation of Create user statement syntax and an example of creating a new user and You will learn How to grant Create session system privilege to your ----_Links_--- Blog: http://bit.ly/create_user_account Video Tut 4: http://youtu.be/wSqoXRlXDUU How to create a 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: 43737 Manish Sharma
Oracle Tutorial - Update Statement
 
06:31
Oracle Tutorials for beginners - Update Statement
Views: 129 Tech Acad
Oracle 11g Database Binaries Installation Video
 
48:04
This video is learn how to install oracle binary.
Views: 23 learn oracle hindi
Fix for: Windows cannot find setup.exe Make sure you typed the name correctly and then try again
 
02:15
This is a permanent solution for this irritating error in windows, this problem is commonly caused by third party programs, specially those who claim to speed up your pc
Views: 66408 Elioth Santillan
Oracle userName and password reset
 
01:41
Reset your Oracle user password .
Views: 63770 brijesh kumar
OpenLDAP Server Configuration on RHEL 7 / CentOS 7 - 100% Working Step by Step Procedure
 
27:36
This video shows you 100% working Step by Step OpenLDAP Server Configuration on RHEL 7 / CentOS 7. Document Link : http://www.learnitguide.net/2016/01/configure-openldap-server-on-rhel7.html COMPLETE OTHER TECHNOLOGY FULL TRAINING AND TUTORIAL VIDEOS PLAYLISTS: Devops Tutorial & Devops Online Training - https://goo.gl/hpQNz3 Puppet Tutorial & Puppet Online Training - https://goo.gl/wbikT9 Ansible Tutorial & Ansible Online Training - https://goo.gl/kQc7HV Docker Tutorial & Docker Online Training - https://goo.gl/x3nXPg Python Programming Tutorial & Python Online Training - https://goo.gl/hDN4Ai Cloud Computing Tutorial & Cloud Computing Online Training - https://goo.gl/Dnez3Q Openstack Tutorial & Openstack Online Training - https://goo.gl/hEK9n9 Clustering Tutorial & Clustering Online Training - https://goo.gl/FvdmMQ VCS Cluster Tutorial & Veritas Cluster Online Training - https://goo.gl/kcEdJ5 Ubuntu Linux Tutorial & Ubuntu Online Training - https://goo.gl/pFrfKK RHCSA and RHCE Tutorial & RHCSA and RHCE Online Training - https://goo.gl/qi2Xjf Linux Tutorial & Linux Online Training - https://goo.gl/RzGUb3 Subscribe our channel "LearnITGuide Tutorials" for more updates and stay connected with us on social networking sites, Youtube Channel : https://goo.gl/6zcLtQ Facebook : http://www.facebook.com/learnitguide Twitter : http://www.twitter.com/learnitguide Visit our Website : https://www.learnitguide.net #openldap #authentication #activedirectory openldap, openldap tutorial, openldap centos 7, openldap server configuration, openldap centos 6, openldap on centos, openldap server configuration in rhel 7, openldap server configuration in rhel 6, openldap installation, openldap configuration, Configure OpenLDAP Server on RHEL7 Centos, linux openldap server setup, Linux ldap configuration, openldap server configuration, Step by step LDAP Configuration, how to install openldap, install openldap, configure openldap server, setting up openldap server, openldap installation and configuration, openldap tutorial videos, installing and configuring openldap server, installation and configuration of openldap server in linux
Views: 66500 LearnITGuide Tutorials
Over clause in SQL Server
 
09:13
over partition by in sql server 2008 sql server over clause partition partition by clause in sql server 2008 over partition by clause in sql In this video we will discuss the power and use of Over clause in SQL Server. The OVER clause combined with PARTITION BY is used to break up data into partitions. Syntax : function (...) OVER (PARTITION BY col1, Col2, ...) The specified function operates for each partition. For example : COUNT(Gender) OVER (PARTITION BY Gender) will partition the data by GENDER i.e there will 2 partitions (Male and Female) and then the COUNT() function is applied over each partition. Any of the following functions can be used. Please note this is not the complete list. COUNT(), AVG(), SUM(), MIN(), MAX(), ROW_NUMBER(), RANK(), DENSE_RANK() etc. Example : SQl Script to create Employees table Create Table Employees ( Id int primary key, Name nvarchar(50), Gender nvarchar(10), Salary int ) Go Insert Into Employees Values (1, 'Mark', 'Male', 5000) Insert Into Employees Values (2, 'John', 'Male', 4500) Insert Into Employees Values (3, 'Pam', 'Female', 5500) Insert Into Employees Values (4, 'Sara', 'Female', 4000) Insert Into Employees Values (5, 'Todd', 'Male', 3500) Insert Into Employees Values (6, 'Mary', 'Female', 5000) Insert Into Employees Values (7, 'Ben', 'Male', 6500) Insert Into Employees Values (8, 'Jodi', 'Female', 7000) Insert Into Employees Values (9, 'Tom', 'Male', 5500) Insert Into Employees Values (10, 'Ron', 'Male', 5000) Go Write a query to retrieve total count of employees by Gender. Also in the result we want Average, Minimum and Maximum salary by Gender. This can be very easily achieved using a simple GROUP BY query as show below. SELECT Gender, COUNT(*) AS GenderTotal, AVG(Salary) AS AvgSal, MIN(Salary) AS MinSal, MAX(Salary) AS MaxSal FROM Employees GROUP BY Gender What if we want non-aggregated values (like employee Name and Salary) in result set along with aggregated values You cannot include non-aggregated columns in the GROUP BY query. SELECT Name, Salary, Gender, COUNT(*) AS GenderTotal, AVG(Salary) AS AvgSal, MIN(Salary) AS MinSal, MAX(Salary) AS MaxSal FROM Employees GROUP BY Gender The above query will result in the following error : Column 'Employees.Name' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause One way to achieve this is by including the aggregations in a subquery and then JOINING it with the main query as shown in the example below. Look at the amount of T-SQL code we have to write. SELECT Name, Salary, Employees.Gender, Genders.GenderTotals, Genders.AvgSal, Genders.MinSal, Genders.MaxSal FROM Employees INNER JOIN (SELECT Gender, COUNT(*) AS GenderTotals, AVG(Salary) AS AvgSal, MIN(Salary) AS MinSal, MAX(Salary) AS MaxSal FROM Employees GROUP BY Gender) AS Genders ON Genders.Gender = Employees.Gender Better way of doing this is by using the OVER clause combined with PARTITION BY SELECT Name, Salary, Gender, COUNT(Gender) OVER(PARTITION BY Gender) AS GenderTotals, AVG(Salary) OVER(PARTITION BY Gender) AS AvgSal, MIN(Salary) OVER(PARTITION BY Gender) AS MinSal, MAX(Salary) OVER(PARTITION BY Gender) AS MaxSal FROM Employees Text version of the video http://csharp-video-tutorials.blogspot.com/2015/09/over-clause-in-sql-server.html Slides http://csharp-video-tutorials.blogspot.com/2015/09/over-clause-in-sql-server_29.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: 95662 kudvenkat
Oracle Database 12c - Create Container Database (CDB) and Pluggable Database (PDB)
 
03:36
Create Container Database with Pluggable Database using DBCA
Views: 4354 Yopi Setiawan
Simplest way to create Tables on Oracle 12c
 
04:30
--EMPLOYEE TABLE CREATE TABLE "EMP" ( "EMPNO" NUMBER(4,0), "ENAME" VARCHAR2(10 BYTE), "JOB" VARCHAR2(9 BYTE), "MGR" NUMBER(4,0), "HIREDATE" DATE, "SAL" NUMBER(7,2), "COMM" NUMBER(7,2), "DEPTNO" NUMBER(2,0) ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ; REM INSERTING into EMP SET DEFINE OFF; Insert into EMP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values (5258,'ALEX','MANAGER',null,to_date('25-JAN-89','DD-MON-RR'),1500,500,null); Insert into EMP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values (7875,'Aziz','MANAGER',7839,to_date('17-NOV-97','DD-MON-RR'),5000,1000,10); Insert into EMP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values (7899,'HADI','PRESIDENT',null,to_date('09-MAY-99','DD-MON-RR'),9000,null,10); Insert into EMP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values (3576,'ABDURAUF','MANAGER',null,null,null,null,null); Insert into EMP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values (3131,'EBAD','CR',null,to_date('25-JAN-81','DD-MON-RR'),1500,500,null); Insert into EMP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values (7955,'JOHNABRAHM','QWERT',null,to_date('18-JUN-20','DD-MON-RR'),2000,null,30); Insert into EMP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values (5952,'JENN','MANAGER',null,to_date('25-JAN-81','DD-MON-RR'),1500,500,null); Insert into EMP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values (7369,'SMITH','CLERK',7902,to_date('17-DEC-80','DD-MON-RR'),800,null,20); Insert into EMP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values (7499,'ALLEN','SALESMAN',7698,to_date('20-FEB-81','DD-MON-RR'),1600,300,30); Insert into EMP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values (7521,'WARD','SALESMAN',7698,to_date('22-FEB-81','DD-MON-RR'),1250,500,30); Insert into EMP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values (7566,'JONES','MANAGER',7839,to_date('02-APR-81','DD-MON-RR'),2975,null,20); Insert into EMP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values (7654,'MARTIN','SALESMAN',7698,to_date('28-SEP-81','DD-MON-RR'),1250,1400,30); Insert into EMP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values (7698,'BLAKE','MANAGER',7839,to_date('01-MAY-81','DD-MON-RR'),2850,null,30); Insert into EMP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values (7782,'CLARK','MANAGER',7839,to_date('09-JUN-81','DD-MON-RR'),2450,null,10); Insert into EMP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values (7788,'','ANALYST',7566,to_date('19-APR-87','DD-MON-RR'),3000,null,20); Insert into EMP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values (7839,'KING','PRESIDENT',null,to_date('17-NOV-81','DD-MON-RR'),5000,null,10); Insert into EMP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values (7844,'TURNER','SALESMAN',7698,to_date('08-SEP-81','DD-MON-RR'),1500,0,30); Insert into EMP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values (7876,'ADAMS','CLERK',7788,to_date('23-MAY-87','DD-MON-RR'),1100,null,20); Insert into EMP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values (7900,'JAMES','CLERK',7698,to_date('03-DEC-81','DD-MON-RR'),950,null,30); Insert into EMP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values (7902,'FORD','ANALYST',7566,to_date('03-DEC-81','DD-MON-RR'),3000,null,20); Insert into EMP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values (7934,'MILLER','CLERK',7782,to_date('23-JAN-82','DD-MON-RR'),1300,null,10); Insert into EMP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values (5230,'SCARLET','MANAGER',null,to_date('26-JAN-81','DD-MON-RR'),1600,600,null); CREATE UNIQUE INDEX "PK_EMP" ON "EMP" ("EMPNO") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ; ALTER TABLE "EMP" ADD CONSTRAINT "PK_EMP" PRIMARY KEY ("EMPNO") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ENABLE; ALTER TABLE "EMP" ADD CONSTRAINT "FK_DEPTNO" FOREIGN KEY ("DEPTNO") REFERENCES "DEPT" ("DEPTNO") ENABLE;
Views: 72 Fareed Ullah
Temp tables in dynamic sql
 
04:36
Text version of the video http://csharp-video-tutorials.blogspot.com/2017/05/temp-tables-in-dynamic-sql.html Slides http://csharp-video-tutorials.blogspot.com/2017/05/temp-tables-in-dynamic-sql_9.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 SQL Server Tutorial Videos https://www.youtube.com/playlist?list=PL08903FB7ACA1C2FB 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 the implications of creating temp tables in dynamic sql Temp tables created by dynamic SQL are not accessible from the calling procedure. They are dropped when the dynamic SQL block in the stored procedure completes execution. Let us understand this with an example. Notice in the example below, all the following 3 operations are in the block of dynamic sql code. 1. Creating the Temp Table 2. Populating the Temp Table 3. Select query on the Temp Table Create procedure spTempTableInDynamicSQL as Begin Declare @sql nvarchar(max) Set @sql = 'Create Table #Test(Id int) insert into #Test values (101) Select * from #Test' Execute sp_executesql @sql End So when we execute the above procedure we are able to access data from the Temp Table. Execute spTempTableInDynamicSQL Now, let's move the SELECT statement outside of the dynamic sql code block as shown below and ALTER the stored procedure. Alter procedure spTempTableInDynamicSQL as Begin Declare @sql nvarchar(max) Set @sql = 'Create Table #Test(Id int) insert into #Test values (101)' Execute sp_executesql @sql Select * from #Test End At this point, execute the stored procedure. Notice, we get the error - Invalid object name '#Test'. This is because temp tables created by dynamic SQL are not accessible from the calling procedure. They are dropped when the dynamic SQL block in the stored procedure completes execution. Execute spTempTableInDynamicSQL On the other hand, dynamic SQL block can access temp tables created by the calling stored procedure. Let's prove this by modifying the stored procedure as shown below. Alter procedure spTempTableInDynamicSQL as Begin Create Table #Test(Id int) insert into #Test values (101) Declare @sql nvarchar(max) Set @sql = 'Select * from #Test' Execute sp_executesql @sql End At this point, execute the stored procedure. Notice that we are able to access the temp table, which proves that dynamic SQL block can access temp tables created by the calling stored procedure. Execute spTempTableInDynamicSQL Summary 1. Temp tables created by dynamic SQL are not accessible from the calling procedure. 2. They are dropped when the dynamic SQL block in the stored procedure completes execution. 3. On the other hand, dynamic SQL block can access temp tables created by the calling stored procedure
Views: 28308 kudvenkat
p6 database error solution
 
03:53
solution of p6 database error
Views: 44952 Simba Nyakundi
Regular Expressions (Regex) Tutorial: How to Match Any Pattern of Text
 
37:55
In this regular expressions (regex) tutorial, we're going to be learning how to match patterns of text. Regular expressions are extremely useful for matching common patterns of text such as email addresses, phone numbers, URLs, etc. Almost every programming language has a regular expression library, so learning regular expressions with not only help you with finding patterns in your text editors, but also you'll be able to use these programming libraries to search for patterns programmatically as well. Let's get started... The code from this video can be found at: https://github.com/CoreyMSchafer/code_snippets/tree/master/Regular-Expressions Python Regex Tutorial: https://youtu.be/K8L6KVGG-7o ✅ Support My Channel Through Patreon: https://www.patreon.com/coreyms ✅ Become a Channel Member: https://www.youtube.com/channel/UCCezIgC97PvUuR4_gbFUs5g/join ✅ One-Time Contribution Through PayPal: https://goo.gl/649HFY ✅ Cryptocurrency Donations: Bitcoin Wallet - 3MPH8oY2EAgbLVy7RBMinwcBntggi7qeG3 Ethereum Wallet - 0x151649418616068fB46C3598083817101d3bCD33 Litecoin Wallet - MPvEBY5fxGkmPQgocfJbxP6EmTo5UUXMot ✅ Corey's Public Amazon Wishlist http://a.co/inIyro1 ✅ Equipment I Use and Books I Recommend: https://www.amazon.com/shop/coreyschafer ▶️ You Can Find Me On: My Website - http://coreyms.com/ My Second Channel - https://www.youtube.com/c/coreymschafer Facebook - https://www.facebook.com/CoreyMSchafer Twitter - https://twitter.com/CoreyMSchafer Instagram - https://www.instagram.com/coreymschafer/
Views: 255126 Corey Schafer
02-Oracle Tutorial in Developer Suite -Installation of Oracle 10g Developer Suite
 
15:05
Welcome to www.TrainerBD.com ‘s Free Oracle Video Tutorial download section. Here you will find a lot of free Oracle tutorial videos. e.g. Oracle Database 10g Tutorial, Oracle DBA 11g Tutorial, Oracle SQL Tutorial, Oracle PLSQL Tutorial, Oracle Forms 6i Tutorial, Oracle Forms Developer Tutorial, Oracle Fusion Middleware Tutorial, Oracle Apex Tutorial etc. Other training institutes will charge a lot money for this training. But www.TrainerBD.com offers this Oracle Training In Bangladesh for 100% free through these Oracle Tutorial Videos. Do you want to free download the Oracle Video Tutorials? Click http://goo.gl/kcYHWk These Oracle Tutorial Videos will teach you skills that directly align with real-life IT job. It shows the hands-on approach to the Oracle database, Oracle SQL, Oracle PLSQL, Oracle Developer Suite and Oracle 11g Fusion Middleware. You will learn Oracle SQL, Oracle PLSQL, Oracle Developer Suite FORMS, REPORTS and Oracle Database Administration, Oracle installation tricks with Oracle Database performance tuning in these Oracle Tutorial Videos series. You’ll discover professional tips and techniques for brilliant and distinctive software as an Oracle Developer and/or Oracle Database Administrator. Here you will learn about Oracle Forms 6i, Oracle Developer Suite 10g along with Oracle 11g Fusion Middleware and the migration process of Oracle Forms and Reports. At the end of these Oracle Tutorial videos a real life project will be completed in Oracle Forms Developer Suite. Later the whole project will be migrated to Oracle 11g Fusion Middleware. During this oracle Tutorial Videos In bangla, Muhammad Abdullah Al Noor (http://goo.gl/DUmKSk) (Skype: ensoftbd, Dial: 017 9072 1177) used some practice sheets in pdf. This pdf(s) will help you keep pace with his on screen actions and verbal instructions. Click here and submit this form: https://goo.gl/uUBj5f to get the pdf(s).   If you have problem downloading the Free Oracle tutorial videos where you can download 100% free “Oracle Training In Bangladesh” sessions, Please go through the following steps: 1- Click here : http://en.savefrom.net/?rmode=false 2- Copy and paste the Youtube video url in the Box. 3- Click Download. 4- Click MP4 480p. for Optimum Resolution Video. Download mpcstar, If you have problem viewing the Free Oracle Tutorial Videos In Bangla for beginners. You can download MPCSTAR by clicking here: http://www.mpcstar.com/download.php TrainerBD.com offer the most affordable Oracle Training in Bangladesh. Click: http://goo.gl/OYI9lF to learn Oracle Made Easy. Oracle Tutorial Videos for Beginners.Join this Facebook Group to get Life time support in Oracle : https://goo.gl/uUBj5f Get Oracle E-books in pdf by submitting this form: https://goo.gl/uUBj5f To Learn Oracle From TrainerBD.com Click Here : http://goo.gl/7pJjhV Oracle Tutorial Group (Facebook):- https://www.facebook.com/groups/Oracletutorialvideos https://www.facebook.com/groups/oracletutorialtechtunes TrainerBD.com Offers the most affordable (BDT. 15,000/-) Oracle Training in Mirpur, Dhaka, Bangladesh. Learn Oracle, Be an Oracle Developer and/or Database Administrator. Click http://goo.gl/OYI9lF to learn Oracle. Search Terms:- oracle video tutorial free download oracle applications tutorial oracle 11g tutorial free download oracle sql tutorial oracle 10g tutorial oracle form builder tutorial oracle forms 10g tutorial oracle 10g tutorial for beginners oracle database 10g tutorial sql oracle oracle for beginners oracle 10g tutorial oracle tutorials for beginners oracle dba tutorial for beginners pdf oracle forms developer tutorial toad for oracle tutorial oracle fusion middleware tutorial oracle forms 6i tutorial oracle sql tutorial oracle 11g tutorial oracle tutorial pdf free download oracle dba tutorial for beginners oracle application express tutorial oracle tutorial for beginners oracle database tutorial oracle apex tutorial oracle sql tutorial sql tutorial oracle 11g tutorial oracle 10g tutorial oracle dba tutorial oracle tutorial for beginners
Views: 541 TrainerBD .com
OpenLDAP Operations - ldapadd ..contd
 
14:07
This is the third video in the 'Getting Familiar with OpenLDAP series. It video demonstrates the usage of ldapadd command to add users into the ou=finance and ou=eng branch using an ldif file.
Views: 5116 Rajesh Rajasekharan
#1- Error ORA-12154: TNS:could not resolve the connect identifier specified
 
02:54
ORA-12154: TNS:could not resolve the connect identifier specified Cause: A connection to a database or other service was requested using a connect identifier, and the connect identifier specified could not be resolved into a connect descriptor using one of the naming methods configured. For example, if the type of connect identifier used was a net service name then the net service name could not be found in a naming method repository, or the repository could not be located or reached. Action: - If you are using local naming (TNSNAMES.ORA file): - Make sure that "TNSNAMES" is listed as one of the values of the NAMES.DIRECTORY_PATH parameter in the Oracle Net profile (SQLNET.ORA) - Verify that a TNSNAMES.ORA file exists and is in the proper directory and is accessible. - Check that the net service name used as the connect identifier exists in the TNSNAMES.ORA file. - Make sure there are no syntax errors anywhere in the TNSNAMES.ORA file. Look for unmatched parentheses or stray characters. Errors in a TNSNAMES.ORA file may make it unusable. - If you are using directory naming: - Verify that "LDAP" is listed as one of the values of the NAMES.DIRETORY_PATH parameter in the Oracle Net profile (SQLNET.ORA). - Verify that the LDAP directory server is up and that it is accessible. - Verify that the net service name or database name used as the connect identifier is configured in the directory. - Verify that the default context being used is correct by specifying a fully qualified net service name or a full LDAP DN as the connect identifier - If you are using easy connect naming: - Verify that "EZCONNECT" is listed as one of the values of the NAMES.DIRETORY_PATH parameter in the Oracle Net profile (SQLNET.ORA). - Make sure the host, port and service name specified are correct. - Try enclosing the connect identifier in quote marks. See the Oracle Net Services Administrators Guide or the Oracle operating system specific guide for more information on naming. my_database = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = my_host)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = my_database) ) ) #2- Erreur ORA 01034 ORACLE not available ORA 27101 shared memory realm does not exist HD https://www.youtube.com/watch?v=1FU9N0V9Z8k
Views: 10431 Houssine Formation
SQL: Change User Password
 
02:38
In this tutorial, you'll learn how to change user password in sql plus PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural extension for SQL and the Oracle relational database. PL/SQL is available in Oracle Database (since version 7), TimesTen in-memory database (since version 11.2.1), and IBM DB2 (since version 9.7).[1] Oracle Corporation usually extends PL/SQL functionality with each successive release of the Oracle Database. PL/SQL includes procedural language elements such as conditions and loops. It allows declaration of constants and variables, procedures and functions, types and variables of those types, and triggers. It can handle exceptions (runtime errors). Arrays are supported involving the use of PL/SQL collections. Implementations from version 8 of Oracle Database onwards have included features associated with object-orientation. One can create PL/SQL units such as procedures, functions, packages, types, and triggers, which are stored in the database for reuse by applications that use any of the Oracle Database programmatic interfaces. PL/SQL works analogously to the embedded procedural languages associated with other relational databases. For example, Sybase ASE and Microsoft SQL Server have Transact-SQL, PostgreSQL has PL/pgSQL (which emulates PL/SQL to an extent), and IBM DB2 includes SQL Procedural Language,[2] which conforms to the ISO SQL’s SQL/PSM standard. The designers of PL/SQL modeled its syntax on that of Ada. Both Ada and PL/SQL have Pascal as a common ancestor, and so PL/SQL also resembles Pascal in several aspects. However, the structure of a PL/SQL package does not resemble the basic Object Pascal program structure as implemented by a Borland Delphi or Free Pascal unit. Programmers can define public and private global data-types, constants and static variables in a PL/SQL package.[3] PL/SQL also allows for the definition of classes and instantiating these as objects in PL/SQL code. This resembles usage in object-oriented programming languages like Object Pascal, C++ and Java. PL/SQL refers to a class as an "Abstract Data Type" (ADT) or "User Defined Type" (UDT), and defines it as an Oracle SQL data-type as opposed to a PL/SQL user-defined type, allowing its use in both the Oracle SQL Engine and the Oracle PL/SQL engine. The constructor and methods of an Abstract Data Type are written in PL/SQL. The resulting Abstract Data Type can operate as an object class in PL/SQL. Such objects can also persist as column values in Oracle database tables. PL/SQL is fundamentally distinct from Transact-SQL, despite superficial similarities. Porting code from one to the other usually involves non-trivial work, not only due to the differences in the feature sets of the two languages,[4] but also due to the very significant differences in the way Oracle and SQL Server deal with concurrency and locking. There are software tools available that claim to facilitate porting including Oracle Translation Scratch Editor,[5] CEITON MSSQL/Oracle Compiler [6] and SwisSQL.[7] The StepSqlite product is a PL/SQL compiler for the popular small database SQLite. PL/SQL Program Unit A PL/SQL program unit is one of the following: PL/SQL anonymous block, procedure, function, package specification, package body, trigger, type specification, type body, library. Program units are the PL/SQL source code that is compiled, developed and ultimately executed on the database. The basic unit of a PL/SQL source program is the block, which groups together related declarations and statements. A PL/SQL block is defined by the keywords DECLARE, BEGIN, EXCEPTION, and END. These keywords divide the block into a declarative part, an executable part, and an exception-handling part. The declaration section is optional and may be used to define and initialize constants and variables. If a variable is not initialized then it defaults to NULL value. The optional exception-handling part is used to handle run time errors. Only the executable part is required. A block can have a label. Package Packages are groups of conceptually linked functions, procedures, variables, PL/SQL table and record TYPE statements, constants, cursors etc. The use of packages promotes re-use of code. Packages are composed of the package specification and an optional package body. The specification is the interface to the application; it declares the types, variables, constants, exceptions, cursors, and subprograms available. The body fully defines cursors and subprograms, and so implements the specification. Two advantages of packages are: Modular approach, encapsulation/hiding of business logic, security, performance improvement, re-usability. They support object-oriented programming features like function overloading and encapsulation. Using package variables one can declare session level (scoped) variables, since variables declared in the package specification have a session scope.
Views: 8991 radhikaravikumar
User question response for VBoxManage Syntax error: Invalid parameter 'VMs/Windows'"
 
12:22
This video helps solve the error "Syntax error: Invalid parameter 'VMs/Windows'" a viewer received when running VBManage showmediuminfo. The original video where the viewer posted the question in the comments section is located at https://www.youtube.com/watch?v=2iAbwdaXXeA . The video deals with how to resize the virtual hard disk of a Windows machine running on OS X in VirtualBox (phew!). This seemed like a common problem so I thought it was worth a video, and this should clear up everything and is oriented at the beginner terminal user. Please like the video and subscribe to my channel if it helps you out. Thanks!
Views: 1050 Eric Rosko
02.03.09_Oracle_10gR2_RAC_2.3.9 Configuring the Initialization Parameter Files in RAC.flv
 
07:10
Oracle 10g/11g RAC, DataGuard, GoldenGate,Streams Hands-on Practices Training. ONLY $199 Please feel free to contact me: E-mail/Skype: [email protected] 1. Building an Oracle RAC 10g R2 (10.2.0.1) on Linux 1.1 Install Linux OS(CentOS 5.3) - () 1.2 Install Required Linux Packages for Oracle RAC - (Video) 1.3 Network Configuration - (Video) 1.4 Create "oracle" User and Directories - (Video) 1.5 Configure the Linux Servers for Oracle - (Video) 1.6 Configure the "hangcheck-timer" Kernel Module - (Video) 1.7 Configure RAC Nodes for Remote Access using SSH - (Video) 1.8 IP SAN Configuration - Openfiler - () 1.9 Install Openfiler - () 1.10 Configure iSCSI Volumes using openfiler - (Video) 1.11 Configure iSCSI Volumes on Oracle RAC Nodes - (Video) 1.12 Install and configure Oracle Cluster File System(OCFS2) - (Video) 1.13 Install and Configure ASM (ASMLib2.0) - (Video) 1.14 Download Oracle RAC 10g Software - (Video) 1.15 Pre-Installation Tasks for Oracle10g Release 2 - (Video) 1.16 Install Oracle Clusterware 10g - 10.2.0.1.0 - (Video) 1.17 Install and configure Automatic Storage Management (ASM) - (Video) 1.18 Install Oracle Database 10gR2 Software - (Video) 1.19 Install Oracle Database 10g Companion CD Software - (Video) 1.20 Create TNS Listener Process - (Video) 1.21 Create ASM Instance - (Video) 1.22 Create a Cluster Database - (Video) 1.23 Post-Installation Tasks - (Optional) - (Video) 1.23.1 Re-compile Invalid Objects - (Video) 1.23.2 Enabling Archive Logs and Flashback in a RAC Environment - (Video) 1.23.3 Create Shared Oracle Password Files - (Video) 1.24 Verify TNS Networking Files - (Video) 1.25 Create / Alter Tablespaces - () 1.26 Verify the RAC Cluster & Database Configuration - (Video) 1.27 Verify Cluster Network Configuration - (Video) 2. RAC Database Administration and Workload Management 2.1 Starting / Stopping the Cluster - (Video) 2.2 Transparent Application Failover - (TAF) - () 2.3 Configuring the Server Parameter File(SPFILE) in RAC - (Video) 3. Upgrading Oracle CRS, ASM, RDBMS and Database 10.2.0.3 3.1 Download and Extract the Installation Software - (Video) 3.2 Pre-installation Tasks for Patch set and Release Upgrades - (Video) 3.3 Oracle Clusterware Rolling Upgrade - (Video) 3.4 Apply the patch 10.2.0.3.0 to the ASM Home - (Video) 3.5 Applying Patch set to Oracle RAC - (Video) 3.6 Upgrading Oracle Database 10.2.0.x to 10.2.0.3.0 Using DBUA - (Video)
Views: 279 Yongcheng Lai
Oracle SQL Developer Tutorial For Beginners  24   Create an User
 
02:31
Oracle SQL Developer Tutorial For Beginners Series. This course introduces Oracle SQL Development for its subscribers. Currently this is based on Oracle 12c. The test environment is in Windows 10.
Views: 2503 Sam Dhanasekaran
1Z0-589 – Oracle Exam Global Trade Management Test Essentials Questions
 
00:49
For more information on Oracle 1Z0-589 Practice Test Questions Please Visit: https://www.Pass-Guaranteed.com/1Z0-589.htm What am I going to be tested for? This 1Z0-589 certification exam covers topics such as: Explain Sanctioned Territory Oracle Screening, Configure 1Z0-589 Compliance Rule for Sanctioned Territory Screening, Execute ad hoc 1Z0-589 Sanctioned Territory Screening, Configure test service preference for product classification lookup, Execute 1Z0-589 product classification lookup and assignment within the context of trade item exam processing, Configure Test Product Classification Template. Which are some of the topics of the 1Z0-589 Global exam? 1Z0-589 Test Topic 1: Trade Master Data Questions (Exam Coverage 20%) 1Z0-589 Test Topic 2: Oracle Product Classification Process Questions (Exam Coverage 17%) 1Z0-589 Test Topic 3: Restricted Party Screening Questions (Exam Coverage 17%) 1Z0-589 Test Topic 4: Compliance Rules Questions (Exam Coverage 20%) 1Z0-589 Test Topic 5: Sanctioned Territory Screening Questions (Exam Coverage 16%) 1Z0-589 Test Topic 6: Trade Transactions Questions (Exam Coverage 10%) Who can attend to the Oracle Global Trade Management 6 Essentials test? Candidates must have a basic understanding of: Explain features that are common between 1Z0-589 Transportation Management (OTM) and GTM, Explain Trade Master Exam Data Management in GTM, Describe and configure Product Classification Test Codes, Describe and configure Oracle Restricted Party Questions List, Configure recurring 1Z0-589 process to detect an invalid product classification test code. Can you give me some in-depth information on the 1Z0-589 exam topics? • Describe User Test Role and Setup • Describe Screensets and Exam Menus • Explain Automation Agents in 1Z0-589 GTM • Explain Jurisdiction Exam Management • Describe and configure 1Z0-589 Region • Describe and configure 1Z0-589 Authority • Configure Test Service Preference for Restricted Party Screening • Describe and configure Oracle Regime • Describe and configure Jurisdiction What’s the 1Z0-589 passing score and duration? The duration of this exam is 120 minutes (78 questions) and the minimum passing score is 69%.
Views: 325 Orsan Stubell
O'Reilly Webcast: Top Three Things You Should Know About Mastering Your Web API Performance
 
01:01:10
Successfully monitoring web API performance improves business partner integration, boosts mobile performance, and ensures the successful integration of enterprise applications. Yet some of the most common web monitoring practices fall short of pinpointing issues with web APIs such as REST or SOAP. Discover how you can master your web API performance in a live webcast led by Dell Software web performance experts John Spirko and Rob Dickinson, with special guest Andy Wahrenberger, Operations Architect for Dell.com's DevOps core. You'll see why common web monitoring practices fall short of pinpointing API issues, and learn effective alternatives to ensure your current monitoring of APIs is adequate. From this webcast you learn: Why you should treat web API performance differently from other web monitoring initiatives How to formulate two-way SLAs to give both consumers and providers a stake in interface performance Options for getting a handle on how your SLA performs and what makes that performance fluctuate About John Spirko John Spirko has been a Senior Product Manager for Dell Foglight since 2001. His responsibilities at Dell focus on providing requirements and direction for a suite of products that map business objectives to end-user behavior. John has more than 12 years of industry experience as a software engineer, developer, DBA and system consultant. He has delivered presentations on end-user monitoring and related topics throughout the U.S. for the past six years. John holds a B.A. degree in electrical engineering from the New Jersey Institute of Technology. About Rob Dickinson Rob Dickinson is a Director of Software Development, and Java and database architect at Dell. He has extensive experience building and delivering very large scale OLTP and OLAP applications, primarily for startup companies with emerging products. He is an architect for Dell's patent pending TransactionDNA technology. His specialties include Java, J2EE, JBoss/WebLogic, Ant/Junit, XML/XSLT, JDBC/ODBC, MySQL, MS SQL Server, PostgreSQL, Oracle, Groovy/Rhino and JSP/Struts. Rob holds a B.S. degree in electrical engineering with a specialty in digital design. His interests include concurrent programming, distributed systems, and web technologies. About Andy Wahrenberger Andy Wahrenberger is a Senior Application Infrastructural Architect at Dell. As operations architect for Dell.com's DevOps core, he is responsible for the adaptation of various applications into a highly available, 24x7 architecture and guiding the design and continual improvement of one of the world's largest multi-datacenter, global eCommerce sites. Andy is responsible for application hosting strategy, encompassing network, compute and storage infrastructure, operation procedures, performance and monitoring. He has 20 years of experience in architecture, implementation, deployment, and performance tuning of large-scale applications, primarily integrating Microsoft .NET technologies into existing infrastructure or other applications. Prior to Dell,com, Andy has contributed his web expertise to Progressive.com, Nationwide.com, NationalCity.com, StateFarm.com, and Xiameter.com. Produced by: Yasmina Greco
Views: 2844 O'Reilly
01.06_Oracle_10gR2_RAC_1.6 Configure the hangcheck-timer Kernel Module_20120203.flv
 
01:20
Oracle 10g/11g RAC, DataGuard, GoldenGate,Streams Hands-on Practices Training. ONLY $199 Please feel free to contact me: E-mail/Skype: [email protected] 1. Building an Oracle RAC 10g R2 (10.2.0.1) on Linux 1.1 Install Linux OS(CentOS 5.3) - () 1.2 Install Required Linux Packages for Oracle RAC - (Video) 1.3 Network Configuration - (Video) 1.4 Create "oracle" User and Directories - (Video) 1.5 Configure the Linux Servers for Oracle - (Video) 1.6 Configure the "hangcheck-timer" Kernel Module - (Video) 1.7 Configure RAC Nodes for Remote Access using SSH - (Video) 1.8 IP SAN Configuration - Openfiler - () 1.9 Install Openfiler - () 1.10 Configure iSCSI Volumes using openfiler - (Video) 1.11 Configure iSCSI Volumes on Oracle RAC Nodes - (Video) 1.12 Install and configure Oracle Cluster File System(OCFS2) - (Video) 1.13 Install and Configure ASM (ASMLib2.0) - (Video) 1.14 Download Oracle RAC 10g Software - (Video) 1.15 Pre-Installation Tasks for Oracle10g Release 2 - (Video) 1.16 Install Oracle Clusterware 10g - 10.2.0.1.0 - (Video) 1.17 Install and configure Automatic Storage Management (ASM) - (Video) 1.18 Install Oracle Database 10gR2 Software - (Video) 1.19 Install Oracle Database 10g Companion CD Software - (Video) 1.20 Create TNS Listener Process - (Video) 1.21 Create ASM Instance - (Video) 1.22 Create a Cluster Database - (Video) 1.23 Post-Installation Tasks - (Optional) - (Video) 1.23.1 Re-compile Invalid Objects - (Video) 1.23.2 Enabling Archive Logs and Flashback in a RAC Environment - (Video) 1.23.3 Create Shared Oracle Password Files - (Video) 1.24 Verify TNS Networking Files - (Video) 1.25 Create / Alter Tablespaces - () 1.26 Verify the RAC Cluster & Database Configuration - (Video) 1.27 Verify Cluster Network Configuration - (Video) 2. RAC Database Administration and Workload Management 2.1 Starting / Stopping the Cluster - (Video) 2.2 Transparent Application Failover - (TAF) - () 2.3 Configuring the Server Parameter File(SPFILE) in RAC - (Video) 3. Upgrading Oracle CRS, ASM, RDBMS and Database 10.2.0.3 3.1 Download and Extract the Installation Software - (Video) 3.2 Pre-installation Tasks for Patch set and Release Upgrades - (Video) 3.3 Oracle Clusterware Rolling Upgrade - (Video) 3.4 Apply the patch 10.2.0.3.0 to the ASM Home - (Video) 3.5 Applying Patch set to Oracle RAC - (Video) 3.6 Upgrading Oracle Database 10.2.0.x to 10.2.0.3.0 Using DBUA - (Video)
Views: 190 Yongcheng Lai
How to Delete Undeletable Files & Folders in Windows 10/8/7 (No Software)
 
02:10
Cannot delete file: Access is denied Could not find this item There has been a sharing violation. The source or destination file may be in use. The file is in use by another program or user The file or directory is corrupted and unreadable. Make sure the disk is not full or write-protected and that the file is not currently in use. Facebook Page : https://www.facebook.com/MeMJTube Follow on twitter: https://twitter.com/mj1111983 Website : http://www.bsocialshine.com
Views: 227531 MJ Tube
Resetting Your Oracle Database Password with Oracle SQL Developer
 
02:43
Resetting your Oracle Database user password just got a LOT easier in version 4.2 of SQL Developer. In this video, the product manager shows you JUST how much easier.
Views: 25812 Jeff Smith