Oracle

Select to_char (sysdate, 'day') from dualThe current day of the week is displayed.Select to_char (sysdate, 'D') from dualWe can see that the day of the week is the day of the week. Because the foreign people's habits are different from those of

1. Find db_1/computer name _ orcl/sysman/config/EMD in the Oracle installation directory. properties, use NotePad to open EMD. properties, in EMD. change agenttzregion = GMT in the last line of the properties file to agenttzregion = Asia/Chungking

1.Function 1) Create a function Create or replace function get_tax (X number) return number as begin declare y number; begin Y: = x-2000; if x 2) Execution function SQL> select get_tax (1000) from dual; Result: Get_tax (1000) ---

Now oracle can be managed through http: // localhost: 8080/apex on the web, but this will occupy port 8080, which is in conflict with other Web servers. This method is found today and is effective in the experiment:   Call dbms_xdb.cfg_update

  PL/SQL developer inserts a certain amount of data into a table in the database. You can see that the data has been inserted into the table through the SELECT statement.ProgramBut the newly inserted data cannot be queried.   Then write the test

I. First, the cause of the problem is that I deleted a file in oracle \ oradata \ oradb by mistake.2. symptom: SQL * Plus cannot be connected, the following error is displayed: ORA-01033: Oracle initialization or shutdown in progress, the same error

1) Start the SQL plus command that comes with Oracle: sqlplusw (the SQL plus interface will appear after you enter this statement in the running command) Doc command implementation: sqlplus 2) connect to the database after SQL plus is started.

Garbled during Oracle 9i installation in redhat9Information: The Oracle Installation Interface contains no text and only garbled characters. What should I do? Solve Chinese problems VI. bash_profileExport lc_all = zh_cnExport lang = zh_cnExport java_

1. query user (data) tablespace Select upper (F. tablespace_name) "tablespace name ",D. tot_grootte_mb "tablespace size (m )",D. tot_grootte_mb-F. total_bytes "used space (m )",To_char (round (D. tot_grootte_mb-F. total_bytes)/D. tot_grootte_mb * 100

1. Create a database(1) on the server side, Use Database Configuration assistant to create a database and enter the global database ID. The newly created database can be seen after independent login, but cannot be seen when you log on to the Manager

Dr. Shi Yu, an Oracle expert, explained Oracle over the past two days. The general content is as follows:Oracle architecture: Oracle instances and databasesOracle instances include multiple processes and data memory zonesThe data memory zone

Purpose The merge command can be used to modify or insert data from one table to another. The insert or modify operation depends on the conditions of the on clause. This statement can be executed in two steps in the same statement, which can reduce

Java programs or classes can be stored in the database and replaced or supplemented with PL/SQL. Java can be used as a database trigger, stored procedure, function, and object member function. After developing a Java stored procedure according to

I have recently seen many people talking about issues such as TNS or the inability to log on to the database. I simply summarized the following documents. First, the network structure of Oracle can be combined with encryption, LDAP, and so on .. We

Asp.net connection to SQL ServerBytes ---------------------------------------------------------------------------------------------------------------------Using system. Data;Using system. Data. sqlclient;... String strconnection = "User ID = sa;

After learning about the use of expdp, after a while, I started to use batch export. The results showed a series of problems. After creating the logical directory and the physical directory corresponding to the operating system, run the following

I wrote a file to enable and disable the Oracle service I used. The details are as follows: ********** *********************************** @ Echo offECHO is starting the Oracle service. Please wait ......Net start oraclecsserviceNet start

Ref_cursor for Oracle Development PL/SQL language development Reference ManualPrefaceWe are no longer familiar with ref_cursor. We have been familiar with ref_cursor in our previous blog: in the blog "How to make Oracle Stored Procedure return

Oracle backup and recovery of single or multi-table data Oracle backup, recovery of single or multi-table data steps, applicable to Oracle 8, 9, 10.*Back up single or multi-table data:Exp user/password @ Server File = filefullpathname log =

Steps for Oracle to back up and restore table space data In the previous blog, you used logical backup exp/imp for full-database backup, single-table or multi-table data backup. This article summarizes how to use exp/IMP to back up tablespaces. The