oracle discoverer plus

Check Metalink and stick it to the topI have studied it myself, but since discoverer and OLAP viewer have not developed a unified solution, I will handle it separately. Oraclebi discoverer Workbook ID Method for searching the ID of a workbook1. Start a web browser. 2. Run discoverer plus and open a worksheet in the wo

Test environment: win2003 + oracle10gr2 Set environment variables:Set ORACLE_HOME = D: \ oracle \ product \ 10.2.0 \ db_1Set java_home = % ORACLE_HOME % \ JDKSet Path = % java_home % \ bin; % PATH % Go to the ISQLPLUS directory:Cd % ORACLE_HOME % \ Solaris \ J2EE \ ISQLPLUS \ Application-deployments \ ISQLPLUS Enter the jazn command environment:Java-djava. security. properties = % ORACLE_HOME %/sqlplus/admin/iplus/provider-jar % ORACLE_HOME %/Solaris/

Tags: character dev large database information Management DBA needs to run develop fromI. Classification of databases I. Classification of databases1. Small database: Access, Foxbase2. Medium database: Informix, SQL Server, MySQL3. Large database: Sybase, DB2, Oracle Second, how to reasonably use the database in the project, can be based on the following three aspects to start1, the size of the projectA, how much load, that is, the number of usersB,

Oracle BASICS (1): Use the oracle instance and SQL * plus commandI. Three-tier structure of oracle Database1. Client: used to access databases. Such as sqlplus and pl/SQL dev. 2. database Server-oracle dbms (database management system). This is what we install. 3. database i

Troubleshooting of SQL plus logon failures caused by su switching in Oracle Problem description:The Oracle database in the production environment suddenly fails to log on, and the oracle database in the rlwrap production environment suddenly fails to log on. rlwrap sqlplus "/as sysdba" reports the following error: rlwr

Oracle SQL * plus is a client tool that interacts with oracle. In SQL * plus, you can run the SQL * plus command and the SQL * plus statement. The DML, DDL, and DCL statements we usually call are SQL *

It is estimated that SQL * Plus is used almost at the beginning in Oracle, After all, this tool can run on any platform running Oracle, You can install this tool on the client or on the server, To install the client, install the client software provided by Oracle, On the server side, it is automatically installed when

1. Oracle startup and shutdown 1. To start or shut down the ORACLE System in a standalone environment, you must first switch to the ORACLE user, as shown in the following su 1. Oracle startup and shutdown 1. To start or shut down the ORACLE System in a standalone environment

Oracle SQL * Plus is a client tool that interacts with Oracle. In SQL * Plus, you can run the SQL * Plus command and the SQL * Plus statement. The DML, DDL, and DCL statements we usually call are SQL *

name, restart the machine, and then delete it. 6. Introduction of Oracle Management tools: 1.Oracle of the tool software, mainly for the execution of SQL statements and PL/n blocks; How to use: Sql*plus in the Start menu, or SQLPLUSW in the run bar, or Sql*plus Worksheet in the Start menu;

Oracle SQL * plus is a client tool that interacts with oracle. In SQL * plus, you can run the SQL * plus command and the SQL * plus statement. The DML, DDL, and DCL statements we usually call are SQL *

In the Oracle Copy Command, the Copy command of SQL * Plus is a common task for Oracle DBAs to copy data between data tables. Oracle provides N solutions, the SQL * Plus Copy command is one of them. The SQL * Plus Copy command use

One, sys users and system usersThe Oracle installation automatically generates SYS users and system users(1), sys user is superuser, has the highest privileges, has the SYSDBA role, has the rights to create database, the user's default password is Change_on_install(2), the system user is the management operator, the authority is also very large. With the Sysoper role, without the CREATE DATABASE permission, the default password is the manager(3), gene

One, sys users and system usersThe Oracle installation automatically generates SYS users and system users(1), sys user is superuser, has the highest privileges, has the SYSDBA role, has the rights to create database, the user's default password is Change_on_install(2), the system user is the management operator, the authority is also very large. With the Sysoper role, without the CREATE DATABASE permission, the default password is the manager(3), gene

Sysdate,to_char (sysdate-1/24/60/60, ' Yyyy-mm-dd HH24:MI:SS ') from dual; -Minus 1 seconds the date and date cannot be added together with a date and numberSql> select sysdate+1 from dual; Date and date can be subtractedSql> select Sysdate-sysdate from dual; Add_months (d,x)Returns the D date plus the date after x monthsLast_day (D) Returns the date of the last day of the month that contains the date D Add_months (sysdate,1)

One, sys users and system usersThe Oracle installation automatically generates SYS users and system users(1), sys user is superuser, has the highest privileges, has the SYSDBA role, has the rights to create database, the user's default password is Change_on_install(2), the system user is the management operator, the authority is also very large. With the Sysoper role, without the CREATE DATABASE permission, the default password is the manager(3), gene

Label:One, sys users and system usersThe Oracle installation automatically generates SYS users and system users(1), sys user is superuser, has the highest privileges, has the SYSDBA role, has the rights to create database, the user's default password is Change_on_install(2), the system user is the management operator, the authority is also very large. With the Sysoper role, without the CREATE DATABASE permission, the default password is the manager(3)

, this works fine. --This is the administrator's replyPL/SQL Developer is written in Delphi.The first thing that needs to become available is a a-bit version of the Delphi IDE.Another post also mentions:Hi when install in Windows Server 2003 R2 X64.When I try to connect a account, I has the following message:Initialization errorCould not load "E:/oracle/product/10.2.0/bin/oci.dll"--The following is an administrator's replyIs this a a-bit

Oracle SQL * Plus is a client tool that interacts with Oracle. In SQL * Plus, you can run the SQL * Plus command and the SQL * Plus statement. The DML, DDL, and DCL statements we usually call are SQL *

After the Oracle 10g Database is installed, the web page is installed by default to manage the access path of Oracle. Two isqlplus websites are available. After the Oracle 10g Database is installed, the web page is installed by default to manage the access path of Oracle, including two isqlplus websites. This is becaus