Script Home
  • MySQL modified root password method in CentOS environment

    +Read more
    Author:zyq / Release:2018-1-8 / category:oracle / crowd0 views time+ / sofa /
    OS:CentOS release 6.9 environment: IP:192.168.1.10 MySQL:MariaDB-10.1.30 1. before the modification confirmation root password change is the need to restart the MySQL library, confirm the production really can restart the MySQL library; to confirm the production whether there is a direct u...
  • Oracle adapter connected not solution

    +Read more
    Author:zyq / Release:2015-10-13 / category:oracle / crowd0 views time+ / Comments Off on Oracle adapter connected not solution /
    racle Developer connection is not an error: the listener does not currently know of SID given in the connect descriptor solution: in D: \ \ Administrator \ product \ app... \ dbhome_ \ found in the NETWORK \ ADMIN listener ora file, the modified files in the "here", copy and covered with res...
    adapters and connectionoracle
  • The Oracle SQL Developer connection error solution

    +Read more
    Author:zyq / Release:2015-10-13 / category:oracle / crowd0 views time+ / Comments Off on The Oracle SQL Developer connection error solution /
    with the oracle database connection when new ora - 12505, after solving the problem appeared ora - 12519 error, depressing the along while, after some for problem solving and below small make up take my two solutions to share to everyone, for reference only.   Solution a: today at work ...
    12505oracleSQL Developer
  • Oracle Scott create views insufficient permissions to a solution

    +Read more
    Author:zyq / Release:2015-10-10 / category:oracle / crowd0 views time+ / Comments Off on Oracle Scott create views insufficient permissions to a solution /
    in the PL/SQL Developer database management tools, use the SCOTT user account to log in, new SQL query window, enter a SQL statement create a view, then pop up an error message: ORA - 01031: insufficient permissions. the error information in the above have said is very clear, this is caused...
    oraclepermissionsScott
  • EBS XML publisher Chinese garbled problems and solutions

    +Read more
    Author:zyq / Release:2015-9-26 / category:oracle / crowd0 views time+ / Comments Off on EBS XML publisher Chinese garbled problems and solutions /
    due to the native environment, XML publisher statements run lead to do not to come out, unable to display the XML pages. using XSL style sheet cannot view XML input. Please correct the error and then click the refresh button, or try again later. XML document can have only one top level eleme...
    Chinese garbledpublisher
  • Oracle SQL Developer show time includes the method of vehicle Settings

    +Read more
    Author:zyq / Release:2015-9-23 / category:oracle / crowd0 views time+ / Comments Off on Oracle SQL Developer show time includes the method of vehicle Settings /
    Oracle SQL Developer is Oracle released a free integrated development environment. Oracle SQL Developer is a free open source graphical tool to develop database applications, using SQL Developer can browse database objects, run SQL statements and scripts, and edit and debug PL/SQL statements. In...
    and minutesDeveloperoracle
  • ORACLE random DBMS_RANDOM package

    +Read more
    Author:zyq / Release:2015-9-23 / category:oracle / crowd0 views time+ / Comments Off on ORACLE random DBMS_RANDOM package /
    simple said, roughly by the method of dbms_random package called random number four: 1, dbms_random. Normal       This function with no parameters, can return to normal, a number of distribution type so basically random number between 1 and 1.       Simple test,...
    oraclerandomrandom number
  • The use of the oracle distinct steps

    +Read more
    Author:zyq / Release:2015-9-22 / category:oracle / crowd0 views time+ / Comments Off on The use of the oracle distinct steps /
    let's look at examples below: table table field 1         Field 2       Id              Name      1                     A      2    ...
    distinctoracle
  • Oracle text function introduction

    +Read more
    Author:zyq / Release:2015-9-14 / category:oracle / crowd0 views time+ / Comments Off on Oracle text function introduction /
    Oracle text function to our commonly used functions, the following will introduce you to several Oracle text function usage, study for your reference, hope can let you to have a deeper understanding of Oracle text function. (1) the UPPER, LOWER and INITCAP the three function changes for thei...
    oracletext functions

0Wide search 1Web Design 2Script 3Network Programming 4Database 5Operating system 6Network Security