Oracle

SelectMSI.SEGMENT1 encoding, Msi.description describes, Number of mr.old_order_quantity, Mr.old_schedule_date order Demand Date, Mipo.po_number order number, Mipo.purch_line_num Order Bar, pv.vendor_name Suppliers, Ppf.last_name BuyerFromMrp.

Common SQL statements:Select To_char (sysdate, ' Yy-mm-dd hh24:mi:ss ') from dual; Display: 08-11-07 13:22:42Select To_date (' 2005-12-25,13:25:59 ', ' Yyyy-mm-dd,hh24:mi:ss ') from dual; Display: 2005-12-25 13:25:59Get system time:Select Sysdate

Note the point:1. If it is opened in a tool such as PL/SQL, directly modify the following code [ Italic bold Section ] to execute2. Ensure that the path exists, such as "D:\oracle\oradata\Oracle9i\", which is the path where you want to save the file/

--Query the usage of table spaceSelect UPPER (f.tablespace_name) "Table space name",D.TOT_GROOTTE_MB "Table space 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,2), '

Select Msi.segment1,Msi.description,,Msi.item_type,Msi.inventory_item_status_code statusFrom Inv.mtl_system_items_b MSIwhere msi.organization_id = Xand Msi.item_type in (' FG ', ' SA ')and Msi.inventory_item_status_code <> ' Inactive 'And NOT EXISTS

--Purchase Order Execution enquiry (received within seven days)Select Pha.segment1 Purchase order,Msib.segment1 Material Code,Pla.quantity Order Quantity,Plla.need_by_date Demand Date,Ppf. Full_name Buyer,NVL (rcv.quantity,0) Receive quantityFrom

SELECT DISTINCT fa.application_short_name module,B.responsibility_name responsibility name, Fa.application_name application product,B.responsibility_key Responsibility keyword, b.description description,DECODE (b.data_group_id, 0, ' standard ', ')

Pre-read; In order to achieve a key to the purpose of doing it! Now Ruiy simple to do the following a few pieces of provisionsIf you want to do this one button, please don't go against the restraints!1. Download ' binary ' mysql software media

Automatically install the RPM packages required by Oracle (requires access to the extranet):#! /bin/shrpmpack= "binutilscompat-libstdc++* Elfutils-libelfelfutils-libelf-develelfutils-libelf-devel-staticgccgcc-c++

SELECT Pro.profile_option_name,Pro.user_profile_option_name,Lev.level_type type,--lev.level_code,Lev.level_name,Prv.profile_option_valueFrom APPS.FND_PROFILE_OPTIONS_VL Pro,Applsys.fnd_profile_option_values PRV,(SELECT 10001 level_id,' Site '

1. Create a DirectorySql> Create directory Dump_file as '/db/backup ';2. Directory-assigned PermissionsSql> Grant Read,write on Directorydump_file to BAM;View CatalogSql> select * from Dba_directories;3. BackupSQL>EXPDP user/pwd

Building Oracle11g RAC in linux (1) Document Description Author Deep Blue Project Simulate RAC construction in Visualbox (dual-node) (Redhat5 + Oracle11G) Environment RedHat performanise5.5, Oracle 11g 11.

Based on the previous article, this article modifies the relevant transaction slot information in the undo segment header to prevent the smon rollback operation when the database is restarted or the process is abnormal, thus, the database

To meet current requirements for Web and cloud applications, Oracle announced the launch of MySQL Fabric. MySQL Fabric is an integrated system that simplifies the management of MySQL database groups. This product provides high availability through

Oracle's user security management mainly has permissions and Roles When a user is created, the user does not have any permissions and cannot perform any operations. To perform a specific database operation, you must grant the system permission to

An excellent foreign Oracle blog website collected by individuals. If you need it, go over the firewall if you cannot access it.1. http://www.oratechinfo.co.uk/Http://www.oratechinfo.co.uk/2. Summary of oracle official documents1> official

Complete Text Version: http://note.youdao.com/share? Id = e0d195e84962dbf4997925bc6e1b929b & type = note 1. Install the Oracle Client on the windows operating system. You can download the client from the official website. Here I can refer to another

TOM's oracle programming art 9i, 10g, 11g   PMON PMON, process monitoring. PMON has three main purposes: 1. Perform cleanup after the process is interrupted abnormally. For example, if the dedicated server fails or is killed for some reason, PMON

I. Index Overview1. indexes are equivalent to directories.2. Indexes use a set of sorted index keys to replace the default full table scan retrieval method, thus improving the retrieval efficiency.3. The index creation should be moderate. If it is

In recent years, Oracle database systems have become increasingly favored by ctos. With their excellent data delivery capabilities and the operational capabilities of CEO Larry lison, the powerful and complex Oracle database has been favored by