Plsql database Operations (Excel)

　　

First, Plsql database operation:

1. Back up a table before deleting data:

CREATE TABLE PLAT_COUNTER_DEF_BF as SELECT * FROM PLAT_MONITOR_COUNTER_DEF//backup

Delete from Plat_monitor_counter_def//deleting data

1. Excel to delete data before updating data

Delete from Plat_monitor_counter_group

Unlock

SELECT * FROM Plat_monitor_counter_group for update

Edit data: Copy or manually add data in Excel

Then tick, commit the transaction, lock the table

Note: The first column in Excel must be more than one column, and any data will be rows. The other one by one corresponds.

Second, Excel operation:

1. Ulookup function:

Concatenate (D2,H2): Connects two columns of data together to form a single data. (Double click on ' + ')

VLOOKUP (c2,sheet1! $A $: $B $101,2,false);

C2: Two a cell of the same column in a table.

sheet1! $A $: $B $101: The area selected in the corresponding table A2 to B101.

2: Select Target is the second column of "A2 to B101" in the "selected region of the corresponding table".

FALSE: Exact lookup.

The value of the whole column can be obtained by double-clicking the "+" sign when the first cell appears below the title.

Plsql database Operations (Excel)