Oracle

A self-developed form jumps out of another form2 when the first form1 meets the conditions. However, when form2 is disabled, a red bar appears, that is, the progress or progress bar. When disabled:   Solution: First find

In the EBS development process, you sometimes need to call host files through concurrent requests, such as FTP file transmission and transmission. The process of defining Host-Based Concurrent requests is as follows: 1. Define the execution method

Method 1, You only need"Serial number"Define it as a formula and set it:Get_block_property ('block _ name', current_record)This can be done, or put this line of statement into"When-create-record"Trigger. Disadvantage: the row number cannot be

Query records of % XX % 1. Use instrSelect count (*) from table t where instr (T. column, 'xx')> 0This query is very effective and fast   Query records of % xx Select count (C. c_ply_no) as Count From policy_data_all C,

Http://www.boobooke.com/v/bbk1109.zip Http://www.boobooke.com/v/bbk1110.zip Http://www.boobooke.com/v/bbk1112.zip Http://www.boobooke.com/v/bbk1114.zip Http://www.boobooke.com/v/bbk1115.zip Http://www.boobooke.com/v/bbk1148.zip Http://www.boobooke.co

The tablespace deleted today contains materialized view error, ORA-23515: materialized view and/or their indexes exist in the tablespace It seems that it is necessary to delete the materialized view and perform the delete operation. Because the

The connection to the database failed this morning. The following error is returned: A ORA-01034: Oracle not available ORA-27101: Shared Memory realm does not exist Someone has restarted the server, and Oracle is not up yet? It has been more than

This is often the case where some data is read using SQL and then processed based on the data. For example, if the student's student ID increases sequentially, the student ID is usually obtained and generated using the following method. Select max (

How to install Oracle 11g in Windows 7 Not long ago, I uninstalled my Windows Vista system, installed the flagship version of Windows 7, and encountered many problems during the installation process. Some problems were not encountered by myself,

Import and Export Oracle Data imp/exp Function: Oracle Data Import/Export imp/exp is equivalent to Oracle data restoration and backup.In most cases, you can use ORACLE data import and export to back up and restore data (without causing data loss

Conditional loops can be implemented in two ways.1. For variable in start value... end value loop end loop;2. While condition loop end loop; Loop usage:I. X: = 100;LoopX: = x + 10;If X> 1000 thenExit;End if end loop;Y: = X;Ii. X: = 100;LoopX: = x +

1. Date interval operation Current Time minus 7 minutes Select sysdate, sysdate-interval '7' minute from dual Current Time minus 7 hours Select sysdate-interval '7' hour from dual Current Time minus 7 days Select sysdate-interval '7' day from

How.. Net executes Multiple SQL statements at a time. Generally, only one SQL statement can be executed at a time unless a stored procedure is used. For example, the following services are available: when deleting a user (assuming userid = 5), you

Help !! Oracle connection problems, online and so on! Delphi/Windows SDK/API Http://www.delphi2007.net/DelphiDB/html/delphi_20061215193831284.html Connect to the Oracle database, computer name yd811, Services Name: yd811, Global Database Name

Recently, I have been working on a workflow project. The end user asked me to attach an attachment when sending a message, which is a problem for me.I checked the Oracle data uploaded online and found the Oracle EBS forms Development Guide

The common time format mask is as follows:Mask element meaningYYYY four-digit year (for example, 2005) yearYY two-digit year (for example, 05)Q quarter (1-4)MM month (01-12) monthThe number of weeks in WW (1-53), in which the first week is the first

Trigger execution sequence: 1. When you open FORM: (1) PRE-FORM (2) PRE-BLOCK (BLOCK level) (3) WHEN-NEW-FORM-INSTANCE (4) WHEN-NEW-BLOCK-INSTANCE (5) WHEN-NEW-RECORD-INSTANCE (6) WHEN-NEW-ITEM-INSTANCE 2. When the cursor moves to the next record

  Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->-- Payment type Select a. meaning, A. description From fnd_lookup_values Where a. lookup_type = 'cux _ ydzjjh_lb' And a. language = USERENV ('lang ')

This article is about ORALCE's analysis of the NUMBER type storage method and attempts to explain the designer's initial intention. I recently read a lot of descriptions about ORACLE data storage, and I don't feel familiar with it. So I have read

Character Set problems during Oracle Data dumpingAs an Oracle database user, there is no stranger to the Export and Import commands, because these two are the tools we often use for data backup and recovery. However, Oracle Character Set problems