Home
Search results “Change user password oracle”
How to change user password on Oracle 11g
 
03:00
in this video i'll show you how to change password of your any user on oracle 11g.
Views: 7376 Raihan N Tarek
Oracle Database: How-To: Change User Password
 
02:11
The Best Site to Learn Oracle Database Administration Online
Views: 22698 TechnicalSkills
Oracle username and password and Account unlocking
 
08:37
all education purpose videos
Views: 265253 Chandra Shekhar Reddy
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: 2965 ANKUSH THAVALI
How to reset or change password in sqlplus ,system, admin
 
03:03
Hy guess in this Video Tutorial We are going to show How to Reset Password of SQL Plus or Change user password in SQL Plus. If you face any confusion so comment below or send us email at [email protected] *** Subscribe our Channel for more upcoming Videos. *** Also Visit our website uogstack.wordpress.com
Views: 2011 UOG Stack
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: 7719 radhikaravikumar
How to re-open expired oracle database account without change password
 
02:17
http://dbacatalog.blogspot.com
Views: 4867 dbacatalog
FNDCPASS|ORACLE APPS R12.2|CHANGING APPS USERS PASSWORD
 
08:08
In this video we going to share how to change the apps user password in oracle application R12.2 using the FNDCPASS. BY Sai diwakar.R oracle apps dba
Views: 267 EBS STUDIO ORACLE
Oracle EnterpriseOne - Changing the Weblogic Password in EnterpriseOne
 
10:35
Oracle EnterpriseOne - Changing the Weblogic Password in EnterpriseOne
Views: 5697 allarisolutions
Oracle DBA Basics_How to change sys password and creating users
 
01:16:20
How to change sys password and creating users and grants
Views: 158 Indian Needs
Sys Admin/User and Groups/How to change User Password A
 
02:17
System Administrator, Help, User and groups, How to change User Password
Views: 89 Login Logix
Oracle DB UNLOCK USER AND SET PASSWORD (HR)
 
01:02
Oracle DB UNLOCK USER AND SET PASSWORD (HR)
Ep 3 | Oracle Unlock USer and User Password Change Urdu/Hindi
 
06:52
How to Change User Password In Oracle? How To Unock User in Oracle Sql? In this Video i will Give you answer about these questions and teach you the easy way to Learn . If You Suffer from any probllem them Please ask me via Comment. Plzzzzzzzzzzzz Subscribe my channel also www.saudiatech.com
Views: 108 Usman Anwar
Changing user password using linux shell script.
 
19:33
How to change user password in Linux using shell scipt. Script has been shown with hard-coded as well as command line username and password. am providing you with the script code. #!/bin/bash ROOT_UID=0 E_WRONG_USER=65 E_NO_SUCH_USER=70 SUCCESS=0 if [ "$UID" -ne "$ROOT_UID" ] then echo "You need to be logged in as root to perform this operation" exit $E_WRONG_USER else echo "Continue with password change" fi username=$1 newpassword=$2 grep -q "$username" /etc/passwd if [ $? -ne $SUCCESS ] then echo "No such user exist" exit $E_NO_SUCH_USER fi echo "$newpassword" | passwd --stdin "$username" echo "Password for $username changed" exit 0
Views: 1994 Subhroneel Ganguly
ORACLE:  How to force password change on first login, on both SQLplus and SQL Developer.
 
01:46
Demo on SQLPlus and SQL Developer. Available for any version of Oracle Database.
Views: 5507 Database Tutorials
Oracle Applications - Change Password
 
17:32
كيفيه تسجيل الدخول لاول مره على تطبيقات اوراكل للحلول الماليه. تغيير كلمه السر لأول مره. وتغيير كلمه السر الاوراكل بعد ذلك فى اى وقت. بالاضافه إلى ملاحظات على عمل كلمه سر قوية، وحماية كلمه السر.
Views: 694 Ehab Hamed
Change sys user password in Oracle 12c Datagraud
 
03:02
Change SYS user password in Oracle 12c release 2 has been made so simple and automated and now DBA not to be worried about copying password file to Standby
Views: 118 Jamaal Khan
How to Change Oracle Database Name using Nid Utility /* Step By Step /*
 
26:20
Nid Utility is used for Changing DB Name and DBID. Nid means DB New Id Utility. 1. Using this utility we can change Database Name. 2. Using this utility we can change Database Id. 3 Using this utility we can change Database Name and Database Id. ------ Both. IN this Video I am Showing you how can we Change Oracle Database Name (DB Name) using Nid Utility Nid Utility is a database tool for change Database name and Database Id. This tool is very easy to implement and understand. Follow Steps: Nid target=username/password dbname='New DB Name' setname=yes
Views: 625 Parag Mahalle
Oracle EBS 12.2 - Change Password For SYSADMIN User-Virutal Machine
 
07:08
Once you install Oracle VirtualBox for EBS R12.2.7 for Oracle Virtual Machine, your systadmin user will not gonna to work unless you perform the steps mentioned in that session. Please feel free to share video link to your WhatsApp Groups, Friends, Colleagues, and SOCIAL Media. Happy Learning! Join Facebook Group:https://www.facebook.com/groups/oraerpsolutions Happy Learning! #OracleSYSADMINuser #OracleEBS #OracleVirtualBox_ e-business suit
Oracle Forms | How To Change User Login Password By Forms -37
 
13:43
Oracle Forms | How To Change User Login Password By Forms -37 To See More Forms Tutorial Click here https://www.youtube.com/watch?v=Zsu4CWo_vwk&list=PLXXvCMuixAJU3Ap_FE2zSEBicv8IC5kDU To See More Reports Tutorial Click here https://www.youtube.com/watch?v=y_0f_iILlmY&list=PLXXvCMuixAJUfU4ZISmPtHrmKe5qRvyVY Dear viewer, In this tutorial you will learn How To Change user login Password in your forms. Code: declare v_count number; v_pass VARCHAR2(20); V_id number; begin select count(*) into v_count from userinfo where USERID=:USER_ID AND upper(USERNAME)=UPPER(:USER_NAME); IF V_COUNT=1 THEN SELECT PW INTO V_PASS FROM USERINFO where USERID=:USER_ID AND upper(USERNAME)=UPPER(:USER_NAME); IF v_pass=:OPASS THEN IF v_pass=:NPASS THEN :mess:=('Both old and new pass are same!!'); ELSE IF :NPASS=:CPASS THEN :mess:=('Password changed sucessfully!!'); UPDATE USERINFO SET PW=:CPASS where USERID=:USER_ID AND upper(USERNAME)=UPPER(:USER_NAME); STANDARD.COMMIT; ELSE :mess:=('Confirmed password is not correct!!'); END IF; END IF; ELSE :mess:=('Invalid Password!!'); END IF; ELSE :mess:=('Invalid user name!!'); END IF; END; To Get more Tutorial Subscribe The Channel click here https://www.youtube.com/channel/UCQ3ea4zVCfnKBx1_7h8raGQ?sub_confirmation=1 To Get All Post Like The Facebook Page Click here https://www.facebook.com/oracledbsolutions Follow us: Facebook: https://www.facebook.com/oracledbsolutions Youtube link: https://www.youtube.com/channel/UCQ3ea4zVCfnKBx1_7h8raGQ?view_as=subscriber Facebook Group: https://www.facebook.com/groups/465557066961548 Contact us: email: [email protected] Skype: oracle26solutions Mob: 01734557080, 01627422780
Views: 177 OracleDB Solutions
How to access, change, reset, unlock a password that is locked or expired in oracle TOAD.
 
01:36
In this tutorial you will learn how to unlock, change, access a locked user account's password. To unlock a user that is locked or expired, connect using SYS (DBA). After successfully connected, click Schema Browser. Then find Users from list box. You will see a cross left side of the locked user. Double click the username that is locked or expired. Enter the new password in the opening window. Don't forget to uncheck Password Expired box. Now you can connect with the user that is unlocked. Thank you for watching.
Views: 910 bem fixx
how to change password in oracle database?
 
02:29
For changing password for any oracle user, you must have admin access. Let us use alter user command for changing password for oracle user.
Views: 308 itasworkshop
How to unlock account and change password in SQL
 
16:01
alter user scott identified by tiger account unlock;
Views: 7816 Computer-Science
CHANGE APPS PASSWORD WITHOUT FNDCPASS|ORACLE APPS R12.2
 
09:36
In this video we sharing the ERRORS if you change the apps password using the ALTER USER command| INVAILD USERNAME/PASSWORD
Views: 175 EBS STUDIO ORACLE
How To Change The Password Of Another User Using Command Prompt (HD)
 
03:33
Open up command prompt Type 'net user' Type 'net user (Username) * Type a password (It will not show up) press enter Type password again Press enter Done. If it says access denied, you may not be on an administrator account. You will need to be on an administrator account to perform this. My Twitter: https://twitter.com/Iluvgtasan
Views: 2970 iluvgtasan
Unlock and Reset password on Oracle user account
 
02:09
Unlock and Reset password on Oracle user account
Views: 107 Harith Jawad
How to change GlassFish server admin username and password ?
 
08:35
CLICK TO DOWNLOAD COMPLETE SOURCE CODE - http://www.hubberspot.com *********************************************** Do Watch Video in High Quality ... ***********************************************
Views: 5590 Dinesh Varyani
How to change password in oracle using prompt
 
03:13
If you first time install of Oracle by default username and password is USER-NAME : system PASSWORD : sysdba If you want to see more related video like subscribe and share this channel
Views: 28 it sector
Raspberry Pi Changing the default user password and creating new accounts
 
07:03
More videos like this online at http://www.theurbanpenguin.com Just a quick look at changing the default user account passwd in the Raspberry Pi, both with raspi-config and the passwd command. With that in place we look at creating a new user account with administrative rights using useradd
Views: 57899 theurbanpenguin
How to change password to a USER in AIX (passwd command)
 
02:09
change user password in AIX with passwd command
Reset the kali linux root/user password (2017) ✓
 
03:15
Reset the kali linux root/user password (2017) #kalilinux #resetrootpassword Links: Vmware : http://adf.ly/13452427/how-to-download-and-install-vmware Kali linux iso: http://adf.ly/13452427/kali-linux-iso How to install kali linux on vmware + vmware tools : https://youtu.be/YaFsdR0_r1E Also subscribe my other channel= Your Health Expert : https://www.youtube.com/channel/UCaqlnID33a2zhv7I_0BNqxw Earn some online money by just shortning your links: http://adf.ly/?id=13452427 Facebook : http://adf.ly/13452427/allaboutcomputers2 Blog : http://adf.ly/13452427/allaboutcomputers Thank You, Subscribe !
Views: 95308 All About Computers
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: 424 Cloud Network
How to Reset Root Password On Ubuntu 18.04 / 16.04 / 17.10 LTS
 
05:23
1 Reboot your computer. 2 Hold Shift during boot to start GRUB menu. 3 Select advanced options for ubuntu 4 Select the option with recovery mode 5 Select root and press enter 6 Give command - mount -n -o remount,rw / 7 Press Enter 8 Give command - passwd your_username 9 Give new password 10 reboot ------------------Online Courses to learn---------------------------- Java - https://bit.ly/2H6wqXk C++ - https://bit.ly/2q8VWl1 AngularJS - https://bit.ly/2qebsLu Python - https://bit.ly/2Eq0VSt C- https://bit.ly/2HfZ6L8 Android - https://bit.ly/2qaRSAS Linux - https://bit.ly/2IwOuqz AWS Certified Solutions Architect - https://bit.ly/2JrGoAF Modern React with Redux - https://bit.ly/2H6wDtA MySQL - https://bit.ly/2qcF63Z ----------------------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 -------------------------Stuff I use to make videos ------------------- Stuff I use to make videos Windows notebook – http://amzn.to/2zcXPyF Apple MacBook Pro – http://amzn.to/2BTJBZ7 Ubuntu notebook - https://amzn.to/2GE4giY Desktop - http://amzn.to/2zct252 Microphone – http://amzn.to/2zcYbW1 notebook mouse – http://amzn.to/2BVs4Q3 ------------------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 Searches related to How to Reset Root Password In Ubuntu how to set root password in ubuntu how to reset root password in ubuntu using grub forgot ubuntu password how to change root password in ubuntu create root password ubuntu ubuntu change password terminal start ubuntu in recovery mode linux root password
Views: 186362 ProgrammingKnowledge
Changing User Password
 
01:17
How to change a existing oracle user password in oracle database in urdu.
Views: 2298 modern IT Channel
How to Change Oracle10g Password
 
02:37
#Oracle_10g Password Reset
Views: 201 Franklin Thaker
Creating a -Change Password- page in Oracle Apex
 
13:21
DDL here: http://gluque.github.io Creating a new page in Oracle Apex for allow to update user's password. Creación de una página en Oracle Apex para que un usuario pueda cambiar su contraseña. Oracle Apex 4.2.3
Mysql update root user password on command line
 
07:58
This tutorial will teach you how to give or update mysql root user password.
Views: 29741 ICT Trainer
How to unlock user and change password in Oracle 11g(Hindi)
 
09:58
Hello Friends, This videos shows the How to unlock user and change password in Oracle 11g.I hope this video help to you and clear the doubts regarding unlock user change password and again lock the account. If you still have any question or query you can ask me on below comment box.I will surely reply with answer. I wish you all viewers to MERRY CHRISTMAS. Oracle 11g Database Installation LInk:https://youtu.be/Yi1dvJ67G54 Oracle 11g Forms and Reports 11g Installation Link:https://youtu.be/pBpRdqzEH9w If you like my video please Like,Share and Subscribe to my channel Ritesh Techno World. Thanks for watching...... Facebook Link:http://facebook.com/riteshvshah11 Twitter Link: https://twitter.com/riteshtechnow
Set SQL server password
 
07:45
if you are currently using "Windows authentication Mode" to login to the sql server... and you dont know your sql server username and password... then, follow this steps to set new "Sql server password" other related videos: export java project with database: https://www.youtube.com/watch?v=xzPuaj61ai4 set sql server port to 1433: https://www.youtube.com/watch?v=BF0DKnhk4Ek connect java code to sql server with derby connection: https://www.youtube.com/watch?v=GTeKQ2zMJWY
Views: 28379 [email protected]
Workspace Creation, Password Change : Apex Series Tutorial(2)
 
04:15
In this tutorial, we learn, how to create workspace in oracle apex, if forget the password then, how to reset the workspace password. its very easy.. Background Music: Background Music Deep Electronica.mp3 (Downloaded from youtube.) My all links ============= My Youtube Channel : https://www.youtube.com/c/MukulAhmed420 My Facebook Account: https://www.facebook.com/mukul.ahmed.148 My Google+ Account : https://plus.google.com/u/0/+MukulAhm... My Twitter Account : https://twitter.com/mukul_420 My Linkedin Account: https://www.linkedin.com/in/mukul-ahm... My hi5 Account : http://www.hi5.com/profile.html?uid=6... My okcupid Account : https://www.okcupid.com/profile/mukul...
Views: 146 Mukul Ahmed
How to Change Schema Password Using Oracle SQL Developer | Oracle SQL Developer Tips and Tricks
 
01:56
How to Change Schema Password Using Oracle SQL Developer | Oracle SQL Developer Tips and Tricks Oracle SQL Tutorial for Beginners Oracle SQL Developer Tips and Tricks Oracle Tutorial for Beginners Oracle Database Tutorial for Beginners Oracle SQL Developer Tips and Tricks Oracle Tutorial How to change sql developer password Changing password with Oracle SQL Developer How to Change Oracle Schema Password How to Change Schema Password in Oracle How to Change Password Using Oracle SQL Developer Resetting Your Oracle Database Password with Oracle SQL Developer oracle database, password reset using sql developer Reset Oracle Schema Password Using Oracle SQL Developer
Changing User Password
 
01:17
In This Video Tutorial I teach you how you can change existing User password In Oracle Database
Views: 50 latest ITChannel
How to SET/RESET PASSWORD FOR SQL SERVER 2012/2013/2017
 
04:24
Change your PASSWORD for SQL SERVER 2017 in 1 step
Views: 803 Black Bug
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: 326970 Chitu Okoli
How to Change | Reset Admin Password on Oracle Apex 5
 
03:43
How to Change Admin Password on Oracle Apex 5 How to Reset Admin Password on Oracle Apex 5 Alter password on oracle apex Reset Oracle APEX: 5 Administrative Password,Change Admin password on Apex,Reset Administrative Password,Change Password,Reset Password,Change Password without format,Password,change,How to Change || Reset Admin Password on Oracle Apex: 5,Solution Wizard,Solutionwizard,Alter admin password on apex,Alter password on oracle apex ===== @ LINK @ ===== DATABASE Playlist: https://www.youtube.com/playlist?list=PLxYD7hLvE2T-8UvDge73jnQ-r47vMFXjK&jct=yrtZrphuVwvOI8ctuINaMbXOyoLIbg ===== @ LINK @ ===== Facebook: https://www.facebook.com/Solution-wizard-166618963871485/ Link: Apex : 3 http://www.oracle.com/technetwork/developer-tools/apex/3-098787.html
Views: 1401 Solution Wizard
update user password in oracle
 
01:20
This tutorial use to update password and extending expire date of user in oracle.
Views: 13 Soft Query
Change Password Admin APEX 4.0
 
02:57
use "apxchpwd.sql" to change admin (password) APEX. SQL> connect / as sysdba Connected. SQL> @apxchpwd Enter a value below for the password for the Application Express ADMIN user. Enter a password for the ADMIN user [] Session altered. ...changing password for ADMIN PL/SQL procedure successfully completed. Commit complete.
Views: 10180 Surachart Opun
How to change oracle Password
 
01:03
Thanks For Nadi Hajjeh -Oracle DBA
Views: 142 Ibrahim Abu Salah
Secure password change in Oracle Forms
 
14:27
Form more Information or any help email :[email protected] code-------- declare v_count number; v_pass VARCHAR2(20); V_id number; begin select count(*) into v_count from USER_INFO where USER_ID=:control.USER_ID AND upper(USER_NAME)=UPPER(:control.USER_NAME); IF V_COUNT=1 THEN SELECT Password INTO V_PASS FROM USER_INFO where USER_ID=:control.USER_ID AND upper(USER_NAME)=UPPER(:control.USER_NAME); IF v_pass=:current_password THEN IF v_pass=:new_password THEN message('Both current and new password are same!!'); message('Both current and new password are same!!'); ELSE IF :new_password=:confirm_password THEN message('Congratulation!! You sucessfully changed your Password!!'); UPDATE USER_INFO SET Password=:confirm_password where USER_ID=:control.USER_ID AND upper(USER_NAME)=UPPER(:control.USER_NAME); COMMIT; ELSE message('Confirmed password is not correct!!'); message('Confirmed password is not correct!!'); END IF; END IF; ELSE message('Invalid Password!!'); message('Invalid Password!!'); END IF; ELSE message('Invalid user name!!'); message('Invalid user name!!'); END IF; END;
Views: 30 Forkan Raju

Merchandising assistant cover letter examples
Web content writing service
Iti mallepally hyderabad admissions essay
Internships cover letter samples
Read sample cover letters for resume