|
|
|
![]()
| [일반] 쿼리방식을 이용한 export dump data 받기 exp |
|
| 호석 님께서 쓴 글입니다 - 211.♡.74.31 |
읽음:4034 |
|
|
When executing this query, Export builds a SQL SELECT statement similar to the following:
SELECT * FROM emp WHERE job='SALESMAN' and sal <1600;
The values specified for the QUERY parameter are applied to all tables (or table partitions) listed in the TABLE parameter. For example, the following statement will unload rows in both emp and bonus that match the query:
exp scott/tiger TABLES=emp,bonus QUERY=\"WHERE job=\'SALESMAN\' and sal\<1600\"
Again, the SQL statements that Export executes are similar to the following:
SELECT * FROM emp WHERE job='SALESMAN' and sal <1600;
SELECT * FROM bonus WHERE job='SALESMAN' and sal <1600;
|
|
|
|
