konhon

        Object    對象
        Class      類
        Object orientation   面向對象技術
        abstraction 抽象
        encapsulation 封裝
        attribute  屬性
        behavior  行為
        method    方法
        state   狀態
        instantiation 實例化
        instance  實例
        constructor  構造方法
        object lieftime 對象生命周期
        identity  標識符
        reference 引用
        garbage collection 垃圾收集

        類的基本UML表示法是一個由三個水平部分組成的矩形。頂端部分用來填寫類的名字， 中間部分用來填寫屬性， 底端部分用來填寫類的操作（方法）。根據需要的細節程度，中間和底端部分可以不被包含。
        關聯通過類之間的連線來表示，通常標注上關聯名稱。
        繼承的表示法是一個有三角箭頭的連線，箭頭指向更為通用的類（超類）。
        聚合的表示法是一個有空心菱形的連線，菱形指向整體類。組成使用實心菱形。
        依賴關系在語言中體現為局部變量，方法參量，以及對靜態方法的調用。
        UML通過使用一個空心的三角箭頭指向泛化來表示繼承。
        在UML中, 接口的表示大部分類似于類的表示, 但是包括了<<interface>>或一個圓圈,  以表明它是一個接口而不是一個類, 接口沒有任何屬性, 因此屬性部分通常被省略.實現接口的類使用一個虛線來實現連接, 而不是使用實線的泛化連接.

         association 關聯
         hierarchy 層次結構
         mulitiplicity 多重性
         whole/part 整體/部分
         has-a 擁有                  
         part-of 部分
        aggregation 聚合
        composition  組合
        generalization/specialization 泛化/特殊化
        is-a 是
        inheritance 斷承
        subclass 子類
        derived 派生類
        superclass 超類
        root class 根類
        overriding 重載
        default behaviors 缺省行為
        inheritance single 單繼承
        inheritance multiple 多重繼承
        interface 接口
        implements 實現 
        polymorphism  多態
        dynamic binding 動態綁定
        abstract class 抽象類
        concrete class 具體類
        visibility 可見性

一個在普通用戶下設置DNS的例子

unit uMain;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, StdCtrls, Registry;

type
  _STARTUPINFOW = record
    cb: DWORD;
    lpReserved: LPWSTR;
    lpDesktop: LPWSTR;
    lpTitle: LPWSTR;
    dwX: DWORD;
    dwY: DWORD;
    dwXSize: DWORD;
    dwYSize: DWORD;
    dwXCountChars: DWORD;
    dwYCountChars: DWORD;
    dwFillAttribute: DWORD;
    dwFlags: DWORD;
    wShowWindow: Word;
    cbReserved2: Word;
    lpReserved2: PByte;
    hStdInput: THandle;
    hStdOutput: THandle;
    hStdError: THandle;
  end;
  STARTUPINFOW = _STARTUPINFOW;

  TForm1 = class(TForm)
    Button1: TButton;
    Button2: TButton;
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
  private
    { Private declarations }
    procedure DoOperation(aCmd: string);
  public
    { Public declarations }
  end;

var
  Form1: TForm1;

function CreateProcessWithLogonW(lpUserName, lpDomain, lpPassword: LPCWSTR;
  dwLogonFlags: DWORD; lpApplicationName: LPCWSTR; lpCommandLine: LPWSTR;
  dwCreationFlags: DWORD; lpEnvironment: Pointer; lpCurrentDirectory: LPCWSTR;
  const lpStartupInfo: STARTUPINFOW; var lpProcessInformation: PROCESS_INFORMATION): BOOL; stdcall;
external advapi32 Name 'CreateProcessWithLogonW'

implementation

{$R *.dfm}

procedure DelRegCache;
begin
  with TRegistry.Create do
  try
    RootKey := HKEY_CURRENT_USER;
    DeleteKey('Software\Microsoft\Internet Explorer\TypedURLs');
  finally
    Free;
  end;
end;

procedure TForm1.DoOperation(aCmd: string);
var
  STARTUPINFO: StartupInfoW;
  ProcessInfo: TProcessInformation;
  AUser, ADomain, APass, AExe: WideString;
const
  LOGON_WITH_PROFILE = $00000001;
  LOGON_NETCREDENTIALS_ONLY = $00000002;
begin
  Screen.Cursor := crHourGlass;
  try
    FillChar(STARTUPINFO, SizeOf(StartupInfoW), #0);
    STARTUPINFO.cb := SizeOf(StartupInfoW);
    STARTUPINFO.dwFlags := STARTF_USESHOWWINDOW;
    STARTUPINFO.wShowWindow := SW_SHOW;
    AUser := 'administrator';
    APass := '123';
    ADomain := 'domain';
    AExe := aCmd;
    if not CreateProcessWithLogonW(PWideChar(AUser), PWideChar(ADomain),
      PWideChar(APass),
      LOGON_WITH_PROFILE, nil, PWideChar(AExe),
      NORMAL_PRIORITY_CLASS, nil, nil, STARTUPINFO, ProcessInfo) then
      RaiseLastOSError;
    WaitForSingleObject(ProcessInfo.hProcess, INFINITE);
  finally
    Screen.Cursor := crDefault;
  end;
end;

procedure TForm1.Button1Click(Sender: TObject);
begin
  DoOperation('netsh interface ip add dns "區域連線" 192.168.10.81 1');
  DoOperation('netsh interface ip add dns "區域連線" 202.96.128.166 2');
  Application.MessageBox('操作完成!', 'CrackNet', MB_OK + 64);
end;

procedure TForm1.Button2Click(Sender: TObject);
begin
  DelRegCache;
  DoOperation('netsh interface ip set dns "區域連線" dhcp');
end;

procedure TForm1.FormClose(Sender: TObject; var Action: TCloseAction);
begin
  Hide;
  Button2.Click;
end;

end.

電話英語：接到英語電話時要說的話

 

應急用語<說明>：不擅長說英語的人接到英語電話時，千萬不要手足無措，可用下述幾種方式沉著應答。

 

(1) 請稍待片刻。

Just a moment, please.

(2) 請別掛斷。我找一位會說英語的人來。

Hold the line, please. I'll get an English speaker.

(3) 請等一下。我找個人來聽。

Hold on, please. I'll get someone to the phone.

(4) 很抱歉，我英語說得不好。我找位會講英語的人稍后回電話給你。請教您的大名及電話號碼？

I'm sorry, I don't speak English well. I'll have an English speaker call you back later. May I have your name and telephone number?

 

接電話的開場白<說明>：拿起話筒的時候，可先用"Hello." "Good morning." "Good afternoon."等問候對方，并報上自己的公司名、部門名、姓名等，如此可予人態度親切的感覺。

 

(1) 早安。這里是正泰貿易公司。我能效勞嗎？

Good morning. This is Chengtai Trading Company. May I help you?

(2) 午安。這里是大安商業銀行。我能為您效勞嗎？

Good afternoon. This is Dan An Commercial Bank. What can I do for you?

(3) 先鋒電子。我是吳瑪莉。

Pioneer Electronics. This is Mary Wu speaking.

(4) 喂。海外營業部。我是王大明。

Hello. Overseas Sales Department. Taming Wang speaking.

(5) 喂。這里是王公館。

Hello. This is the Wang residence.

(6) 午安。我是王大明。

Good afternoon. Taming Wang speaking.

(7) 我是楊文凱，請講。

Wenkai Yang. Speaking.

 

問對方要找誰<說明>：通常對方都會主動說出要找誰，但萬一對方說不清楚，或是你沒聽懂，想再確認的時候，可以用下面的話問清楚。

 

(1) 請問找哪位？

Who do you want to talk [speak] to?

(2) 您找哪位？

Who would you like to speak with?

(3) 請問受話人的尊姓大名？

The name of the person you are calling, please?

(4) 你要打給哪位？

Who are you calling?

 

請教對方的大名<說明>：接獲老外打來的電話，應問清楚對方的身分，以便通報相關的當事人或做進一步的處理。

 

(1) 請問是哪位？

Who's calling, please?

(2) 請問您哪位？

Who's speaking, please?

(3) 請教大名好嗎？

May I have your name, please?

(4) 請問大名好嗎？

May I ask your name?

(5) 請教您的大名。

Your name, please.

(6) 請問您是哪位？

May I ask who's calling, please?

(7) 請問您是誰？

Who is this, please?

(8) 請問是誰？

Who is that calling?

(9) 請告訴我您是哪位？

Who should I say is calling?

(10) 您是哪一位？

Who(m) am I speaking to?

(11) 要我通報您是哪位嗎？

Could I tell him who's calling?

(12) 請問您是何人？

Who's that speaking, please?

(13) 請問是哪位打來的？

Who's this calling, please?

 

不明了對方所言時<說明>：聽不懂對方的話卻硬撐下去，并非明智之舉，不如坦白請對方更簡單明確的說明清楚。

 

(1) 能說得明確一點嗎？

Could you put that in more specific terms?

(2) 我無法確定你的意思。

I'm not sure what you mean.

(3) 很抱歉。我沒聽懂你的話。

I'm sorry. I couldn't follow you.

(4) 你講得太快了。我跟不上。

You're talking too fast. I can't keep up.

(5) 請你再多解釋一下好嗎？

Will you explain a little bit more?

(6) 你能說得簡單一點嗎？

Could you put that more simply?

(7) 恐怕我沒聽懂。能請你再說一遍嗎？

I'm afraid I didn't understand that. Could you say that again, please?

(8) 對不起，我沒聽到，請你再說一遍好嗎？

Excuse me, but I didn't hear that, would you mind repeating it, please?

(9) 抱歉，我沒聽懂，請您拼一下好嗎？

Sorry, but I didn't catch that, would you mind spelling it, please?

 

各種附和、質疑、同意、否定的用語<說明> 通話當中需借助各種或表附和，或表驚訝，或表欣喜，或表婉惜，或表疑問，或表否定的短語，以利談話的順利推展。

 

<1>表驚訝

(1) 真的呀？

Really?

(2) 什么？

What?

(3) 別開玩笑！

You're kidding!

<2>表欣喜

(1) 好極了！

Great!

(2) 太棒了！

Fantastic!

(3) 棒極了！

Terrific!

(4) 哇！

Wow!

<3>表婉惜

(1) 真糟糕。

That's too bad.

(2) 真可惜！

What a shame!

(3) 聽到這樣我很難過。

I'm sorry to hear that.

(4) 喔，原來如此。

Oh, I see.

<5>表同意

(1) 沒錯。

Right.

(2) 正是。

Exactly.

(3) 是的，一點也沒錯。

I'll say.

(4) 你說得對極了。

You can say that again.

(5) 好的。

OK.

<6>表不同意

(1) 我可不以為然。

I don't think so.

(2) 不成！

No way!

(3) 不！

No.

(4) 喔，得了吧！

Oh, come on!

(5) 事實上不然。

Not really.

 

通話將畢時的結尾語<說明>：通話接近尾聲，經常要來上幾句客套話，以作為道別的前奏曲。請靈活應用下列各句，免得該收場時卻不知如何下手。

 

(1) 謝謝你來電。

Thank you for calling.

(2) 感謝你打給我。

It was kind of you to call me.

(3) 很高興跟你談話。

Nice talking to you.

(4) 讓我們盡快聚聚。

Let's get together soon.

(5) 我該掛電話了。

I'd better get off the phone.

(6) 請隨時再打電話給我。

Call me again any time.

(7) 有空請再打電話來。

Call again when you've got time.

(8) 請代我問候珍妮。

My best wishes to Jane.

(9) 請一定要再來電話喔。

Please do call again.

(10) 我隨時高興接到你的電話。

I'm always glad to hear from you.

(11) 想聊的時候請隨時來電。

Call again anytime you feel like talking.

(12) 謝謝你回我電話，再見。

Thanks for returning my call, good-bye.

(13) 讓我們保持聯絡，再見。

Let's keep in touch, good-bye.

(14) 那么下周二見。

See you next Tuesday, then.

1.CREATE OR REPLACE PACKAGE ROME AS　　
　　AS
　　TYPE RefCursor IS REF CURSOR;
　　Function GetCompany(key IN char) return RefCursor;
　　END;
　　/
　　CREATE OR REPLACE PACKAGE BODY ROME IS
　　IS
　　Function GetCompany(key IN char) return RefCursor
　　Is
　　v_temp RefCursor;
　　BEGIN
　　OPEN v_temp FOR
　　SELECT * FROM Company WHERE com_ID =key;
　　return v_temp;
　　END GetCompany;
　　END;
　　
　　2.(適用于PLSQL類型)
　　
　　Type shifts_ty is RECORD(
　　comp_code　　varchar2(10),
　　SHIFT_CODE　　varchar2(10),
　　sft_flg　　　　varchar2(10),
　　beg_tm　　　　number,
　　end_tm　　　　number,
　　skills　　　　varchar2(10)) ;
　　Type shifts is Table of shifts_ty index by binary_integer;
　　
　　FUNCTION test_proc(test varchar2)
　　
　　return shifts is
　　shiftspkg SHIFTS;　 --表變量shiftspkg
　　
　　cursor q1 is select
　　shifts.comp_code,shifts.shift_code,shifts.WRK_BEG_TM,shifts.WRK_end_TM,
　　shifts.skills from str_shifts shifts where comp_code ='TSI';　--str_shifts是與表變量shiftspkg結構完全相同的真實表
　　qty q1%rowtype;
　　begin
　　
　　open q1;
　　loop
　　fetch q1 into qty;
　　exit when q1%notfound;
　　
　　for iCount in 1.. qty.skills.count
　　loop
　　shiftspkg(icount).comp_code:= qty.comp_code;
　　shiftspkg(icount).SHIFT_CODE:= qty.shift_code;
　　shiftspkg(icount).sft_flg:= 'SLOTS';
　　shiftspkg(icount).beg_tm:= qty.wrk_beg_tm;
　　shiftspkg(icount).end_tm:= qty.wrk_end_tm;
　　shiftspkg(icount).skills:= qty.skills(icount);
　　end loop;
　　end loop;
　　return　　shiftspkg;
　　end;
　　end;
　　
　　3.使用于SQL類型
　　
　　create or replace type myScalarType as object
　　( comp_code varchar2(10),
　　shift_code varchar2(10),
　　sft_flg　　　　varchar2(10),
　　beg_tm　　　　number,
　　end_tm　　　　number,
　　skills　　　　varchar2(10)
　　)
　　
　　create or replace type myArrayType as table of myScalarType
　　
　　FUNCTION test_proc(test varchar2) return myArrayType
　　is
　　l_data　myArrayType := myArrayType()　;
　　begin
　　for i in 1 .. 5
　　loop
　　l_data.extend;
　　l_data( l_data.count ) := myScalarType( 'cc-'||i,
　　'sc-'||i,
　　'flg-'||i,
　　i,
　　i,
　　test||i );
　　end loop;
　　
　　return l_data;
　　end;
　　
　　end;
　　
　　select *
　　from THE ( select cast( pkg_test.test_proc('hello') as myArrayType )
　　from dual ) a
　　或
　　select *
　　from table ( cast( my_function() as mytabletype　 ) )
　　order by seq

平時在PL/SQL中的編程中遇到一些問題，這里以問答的形式來進行把它們總結下來，以供大家分享。 　
　　
　　1、當需要向表中裝載大量的數據流或者需要處理大量的數據流的時候，能否使用管道提高處理效率？
　　
　　管道函數對于改善并行查詢的性能非常方便，它加快往表中加載數據的速度。管道函數的使用總結如下兩點：
　　
　　每當在查詢里使用PL/SQL函數時，該查詢將被序列化，即一個處理器只能運行一個查詢實例，那么在這種情況下不可能使用并行查詢（比如在數據倉庫中要經常使用這項技術）。因此，為了使用并行查詢就必須使用管道函數，這樣也就加快了執行的速度。
　　
　　管道函數的輸入參數必須是一個引用記錄集類型（即ref cursor），而返回的是嵌套表類型（其表中每一行對應每一個引用記錄）。在使用管道函數之前，必須先在程序頭寫上PARALLEL_ENABLE，這樣才能在查詢語句中使用管道函數來處理了。
　　
　　2． 如何使PL/SQL程序等待一段時間執行？
　　
　　方法就是使用DBMS_LOCK包的SLEEP函數，可以進行精確定時，其語法為：
　　
　　DBMS_LOCK.SLEEP (seconds IN NUMBER);
　　
　　3．需要在一張表插入一條記錄之后等若干秒后再執行另外一個操作，如何在PL/SQL程序里進行定時操作？
　　
　　一般的做法是用循環作延遲，利用 DBMS_UTILITY的gettime函數來檢測當前的時間，程序代碼如下：
　　
　　DECLARE
　　v_delaytime CONSTANT INTEGER := 100;
　　v_starttime INTEGER ;
　　v_endtime INTEGER ;
　　BEGIN
　　V_starttime := DBMS_UTILITY.get_time;
　　V_endtime := DBMS_UTILITY.get_time;
　　While abs(V_endtime- V_starttime)< v_delaytime loop
　　/*空循環或者簡單的耗時執行語句*/
　　End loop;
　　END;
　　/
　　
　　另外如果是不同會話（session）之間的定時，就必須使用DBMS_PIPE包的函數來實現會話間的消息傳遞。
　　
　　4．當PL/SQL返回一個數據集的時候，該使用集合還是游標？
　　
　　一般情況下，有以下兩點作為依據：
　　
　　1) 如果PL/SQL程序返回多多行數據給另外一個PL/SQL程序的話，這里就建議使用集合，因為這樣可以利用集合的批收集（bulk collection）來提高從數據庫提取數據的速度。
　　
　　2) 如果需要在PL/SQL程序的環境中把數據返回到宿主語言環境中（如Sql*plus,c,delphi等），這時應該使用游標變量來返回這些數據，因為幾乎所有的宿主語言都支持游標變量，但不是所有的宿主語言都支持集合。這樣可以增強程序的可移植性。
　　
　　5．如何更有效的在PL/SQL中使用游標？
　　
　　游標是PL/SQL中一個非常重要的概念，對數據庫的檢索主要依靠游標來操作。在PL/SQL中有兩類游標，一類是隱式游標，如select clno into v_clno from table_detail.另外一類是顯式游標，如cursor v_cur is select clno from table_detail。對于游標的使用這里給出以下幾點建議：
　　
　　1) 盡可能的使用bulk collection。它能夠較大的提高運行性能，在Oracl9i的第二版，甚至可以使用bulk collection來直接將數據寫入到記錄表
　　
　　2) 盡量使用顯式游標來處理，因為相對于隱式游標來說，顯式游標的速度更快一些。
　　
　　3) 如果查詢的表很小或者是靜態的，可以把該表緩存到一個包級的集合里。這樣，你的查詢函數就直接從集合里（即進程全局區，PGA cache），而不是從系統全局區（SGA）來取數據，這樣的處理速度會提升很多。

在你的工作中是否會為了某個活動要隨機取出一些符合條件的EMAIL或者手機號碼用戶，來頒發獲獎通知或其它消息？
　　
　　如果是的話，可以用oracle里生成隨機數的PL/SQL, 目錄文件名在：/ORACLE_HOME/rdbms/admin/dbmsrand.sql。
　　
　　用之前先要在sys用戶下編譯:
　　
　　SQL>@/ORACLE_HOME/rdbms/admin/dbmsrand.sql
　　
　　它實際是在sys用戶下生成一個dbms_random程序包，同時生成公有同義詞，并授權給所有數據庫用戶有執行的權限。
　　
　　使用dbms_random程序包, 取出隨機數據的方法：
　　
　　1. 先創建一個唯一增長的序列號tmp_id
　　
　　create sequence tmp_id increment by 1 start with 1 maxvalue 9999999 nocycle nocache;
　　
　　2. 然后創建一個臨時表tmp_1，把符合本次活動條件的記錄全部取出來。
　　
　　create table tmp_1 as select tmp_id.nextval as id,email,mobileno from 表名 where 條件;
　　
　　找到最大的id號：
　　
　　select max(id) from tmp_1;
　　
　　假設為5000
　　
　　3. 設定一個生成隨機數的種子
　　
　　execute dbms_random.seed(12345678);
　　
　　或者
　　
　　execute dbms_random.seed(TO_CHAR(SYSDATE,'MM-DD-YYYY HH24:MI:SS'));
　　
　　4. 調用隨機數生成函數dbms_random.value生成臨時表tmp_2
　　
　　假設隨機取200個
　　
　　create table tmp_2 as select trunc(dbms_random.value(1,5000)) as id from tmp_1 where rownum<201;
　　
　　[ 說明：dbms_random.value(1,5000)是取1到5000間的隨機數，會有小數,
　　trunc函數對隨機數字取整，才能和臨時表的整數ID字段相對應。
　　
　　注意：如果tmp_1記錄比較多(10萬條以上)，也可以找一個約大于兩百行的表(假如是tmp_3)來生成tmp_2
　　
　　create table tmp_2 as select trunc(dbms_random.value(1,5000)) as id from tmp_3 where rownum<201; ]
　　
　　5. tmp_1和tmp_2相關聯取得符合條件的200用戶
　　
　　select t1.mobileno,t1.email from tmp_1 t1,tmp_2 t2 where t1.id=t2.id;
　　
　　[ 注意：如果tmp_1記錄比較多(10萬條以上)，需要在id字段上建索引。]
　　
　　也可以輸出到文本文件：
　　
　　set pagesize 300;
　　spool /tmp/200.txt;
　　select t1.mobileno,t1.email from tmp_1 t1,tmp_2 t2 where t1.id=t2.id order by t1.mobileno;
　　spool off;
　　
　　6. 用完后，刪除臨時表tmp_1、tmp_2和序列號tmp_id。

寫一些關于PL/SQL的語法，免得等到用到的時候還要去亂翻。 　　１。控制流程(if,while) 　　２。循環(for) 　　３。游標(cursor) 　　４。異常處理(exception） 　　 　　1。控制流程（） 　　 　　A.條件語句 　　IF <statement> THEN 　　PL/SQL 　　END IF; 　　 　　IF <statement> THEN 　　PL/SQL 　　ELSE 　　PL/SQL 　　END IF; 　　 　　IF <statement> THEN 　　PL/SQL 　　ELSIF <statement> THEN 　　PL/SQL 　　END IF; 　　 　　2。循環 　　 　　A.simple loop 　　LOOP 　　SQL 　　EXIT WHEN <statement>; 　　END LOOP; 　　 　　LOOP 　　SQL 　　IF <statement> THEN 　　EXIT; 　　END IF; 　　END LOOP; 　　 　　B.While loop 　　WHILE　<statement> LOOP 　　SQL 　　END LOOP; 　　 　　C.For loop 　　FOR $counter in $low .. $high LOOP 　　SQL 　　END LOOP 　　 　　3。游標 　　 　　在PL/SQL程序中定義的游標叫做顯式游標。 　　 　　A.顯式游標的處理由四個部分組成： 　　cursor $cursorname is $Query;　　　--定義游標 　　open $cursorname;　　　　　　　　　--打開游標 　　fetch $cursorname into $othervariable　　--把游標中的東西取出 　　close $cursorname　　--關閉游標 　　 　　B.游標屬性 　　%found　　　　 布爾型屬性，當最近一次讀紀錄成功時，為true. 　　%nofound　　　　　　　　　　　　　　　　失敗時，為false. 　　%isopen 　　%rowcount　　　返回已從游標中讀取的記錄數。 　　 　　C.參數化游標 　　 　　所有的SQL語句在上下文區內部都是可執行的，因此都有一個游標指向上下文區，此游標就是所謂的SQL游標。 　　 　　與顯式游標不同，SQL游標不被程序打開和關閉。 　　 　　4.異常處理概念 　　 　　異常處理是用來處理正常執行過程中未預料的事件。如果PL/SQL程序塊一旦產生異常而又沒有指出如何處理時，程序會自動終止。 　　 　　異常處理部分放在PL/SQL的后半部分，結構為： 　　 　　EXCEPTION 　　WHEN first_exception THEN <code to handle first exception> 　　WHEN second_exception THEN <code to handle second exception> 　　WHEN OTHERS THEN <code to handle second exception>　--OTHERS必須放在最后 　　 　　異常分為預定義和用戶定義兩種。 　　 　　用戶定義的異常是通過顯式使用RAISE語句來引發。如 　　 　　DECLARE 　　e_TooManyStudents EXCEPTION;　-- 類型為Exception，用于指示錯誤條件 　　v_CurrentStudents NUMBER(3);　-- HIS-101學生注冊當前號 　　v_MaxStudents NUMBER(3);　　　-- HIS-101學生注冊允許的最大號 　　 　　BEGIN 　　/* 找出注冊學生當前號和允許的最大號 */ 　　 　　SELECT current_students, max_students 　　 　　INTO v_CurrentStudents, v_MaxStudents 　　 　　FROM classes 　　 　　WHERE department = 'HIS' AND course = 101; 　　 　　/* 檢查學生的號 */ 　　 　　IF v_CurrentStudents > v_MaxStudents THEN 　　 　　/* 太多的學生注冊，則觸發例外處理 */ 　　 　　RAISE e_TooManyStudents; 　　 　　END IF; 　　 　　EXCEPTION 　　 　　WHEN e_TooManyStudents THEN 　　 　　/* 當太多的學生注冊，就插入信息解釋發生過錯誤 */ 　　 　　INSERT INTO log_table (info) VALUES ('History 101 has ' || v_CurrentStudents || 　　 　　'students: max allowed is ' || v_MaxStudents); 　　 　　END; 　　 　　END; 　　 　　用戶定義的的異常處理 　　 　　可以使用RAISE_APPLICATION_ERROR來創建自己的錯誤處理： 　　 　　RAISE_APPLICATION_ERROR(error_number,error_message,[keep_errors]); 　　 　　其中error_number是從-20000到-20999之間的參數；error_message是相應的提示信息，小于512字節。如： 　　 　　CREATE OR REPLACE PROCEDURE Register ( 　　p_StudentID IN students.id%TYPE, 　　p_Department IN classes.department%TYPE, 　　p_Course IN classes.course%TYPE) AS 　　v_CurrentStudents NUMBER;　-- 班上學生的當前號 　　v_MaxStudents NUMBER;　　　-- 班上學生的最大號 　　 　　BEGIN 　　/* 找出學生的當前號和最大號 */ 　　SELECT current_students, max_students 　　INTO v_CurrentStudents, v_MaxStudents 　　FROM classes 　　WHERE course = p_Course 　　AND department = p_Department; 　　 　　/* 確認另外的學生是否有足夠的教室*/ 　　IF v_CurrentStudents + 1 > v_MaxStudents THEN 　　RAISE_APPLICATION_ERROR(-20000, 'Can''t add more students to ' || 　　p_Department || ' ' || p_Course); 　　END IF; 　　 　　/* 加一個學生在本班 */ 　　ClassPackage.AddStudent(p_StudentID, p_Department, p_Course); 　　 　　EXCEPTION 　　WHEN NO_DATA_FOUND THEN 　　RAISE_APPLICATION_ERROR(-20001, p_Department || ' ' || p_Course || 　　' doesn''t exist!'); 　　END Register;

     一些有用的SQL，都是oracle manage常用的。
　　
　　列在這里做參考，因為太難記了。
　　
　　時時更新。
　　
　　1。監控當前數據庫誰在運行什么SQL 語句
　　
　　SELECT osuser, username, sql_text from v$session a, v$sqltext b
　　where a.sql_address =b.address order by address, piece;
　　
　　2。查看碎片程度高的表
　　
　　SELECT segment_name table_name , COUNT(*) extents
　　FROM dba_segments WHERE owner NOT IN ('SYS', 'SYSTEM') GROUP BY segment_name
　　HAVING COUNT(*) = (SELECT MAX( COUNT(*) ) FROM dba_segments GROUP BY segment_name);
　　
　　3。表空間使用狀態
　　
　　select a.file_id "FileNo",a.tablespace_name "Tablespace_name",
　　round(a.bytes/1024/1024,4) "Total MB",
　　round((a.bytes-sum(nvl(b.bytes,0)))/1024/1024,4) "Used MB",
　　round(sum(nvl(b.bytes,0))/1024/1024,4) "Free MB",
　　round(sum(nvl(b.bytes,0))/a.bytes*100,4) "%Free"
　　from dba_data_files a, dba_free_space b
　　where a.file_id=b.file_id(+)
　　group by a.tablespace_name,
　　a.file_id,a.bytes order by a.tablespace_name
　　
　　4。查看USER
　　
　　SELECT OSUSER,SERIAL#
　　FROM V$SESSION, V$SQL
　　WHERE
　　V$SESSION.SQL_ADDRESS=V$SQL.ADDRESS AND
　　V$SESSION.STATUS = 'ACTIVE';
　　
　　5。監控 SGA 的命中率
　　
　　select a.value + b.value "logical_reads", c.value "phys_reads",
　　round(100 * ((a.value+b.value)-c.value) / (a.value+b.value)) "BUFFER HIT RATIO"
　　from v$sysstat a, v$sysstat b, v$sysstat c
　　where a.statistic# = 38 and b.statistic# = 39
　　and c.statistic# = 40;
　　
　　6。監控 SGA 中字典緩沖區的命中率
　　
　　select parameter, gets,Getmisses , getmisses/(gets+getmisses)*100 "miss ratio",
　　(1-(sum(getmisses)/ (sum(gets)+sum(getmisses))))*100 "Hit ratio"
　　from v$rowcache
　　where gets+getmisses <>0
　　group by parameter, gets, getmisses;
　　
　　7。監控 SGA 中共享緩存區的命中率，應該小于1%
　　
　　select sum(pinhits-reloads)/sum(pins) "hit radio",sum(reloads)/sum(pins) "reload percent"
　　from v$librarycache;
　　
　　8。監控內存和硬盤的排序比率，最好使它小于 .10，增加 sort_area_size
　　
　　SELECT name, value FROM v$sysstat WHERE name IN ('sorts (memory)', 'sorts (disk)');
　　
　　9。哪筆數據正在被人update，而且是被誰正在update
　　
　　select a.os_user_name, a.oracle_username,a.object_id,c.object_name,c.object_type
　　from v$locked_object a, dba_objects c
　　where a.object_id=c.object_id

set linedize 150　 //每行顯示的字符 　　set time on　　　　//在提示符前顯示系統時間 　　SQL> set time on 　　12:25:08 SQL> 　　 　　set serveroutput on/off　　//輸出顯示 　　set long 200　　　//每字段顯示的字符長度，如某列的值顯示不完，調次值 　　col column_name format a10　//顯示列的寬度 　　 　　set linedize 150　 //每行顯示的字符 　　set time on　　　　//在提示符前顯示系統時間 　　SQL> set time on 　　12:25:08 SQL> 　　 　　set serveroutput on/off　　//輸出顯示 　　set long 200　　　//每字段顯示的字符長度，如某列的值顯示不完，調次值 　　col column_name format a10　//顯示列的寬度 　　col ename heading 雇員　　//別名顯示 　　 　　spool d:\temp\sqlout.txt　//輸出為文檔 　　spool off 　　 　　SQL> alter session set NLS_LANGUAGE='AMERICAN'; 改變session的語言顯示 　　SQL> alter session set NLS_LANGUAGE='SIMPLIFIED CHINESE'; 　　 　　SQL> set timi on //顯示提示SQL語句執行所花的時間

601 I've been part of this project since its beginning.

從一開始我就參與這個計劃。

602 I'm Clifton, and I've been associated with this project since the beginning.

我叫克里夫敦，從一開始我就參與了這項計劃。

603 Please look at the data of this first chart.

請看第一幅圖表的數據。

604 The data confirm that this product is safe and effective.

數據證實此種產品安全有效。

605 As you can see in this photo, we've retained the same style which was so popular in this old model.

正如你在這張圖片上所看到的，同風格的這種舊型產品非常流行，我們保留了它。

606 Now, we're doing something new making skin strong enough that it doesn't wrinkle, become dry, or develop blemishes.

現在我們正在做一些改進，使皮質變得堅韌而不致有皺紋，變干或產生磨損。

607 The X2500 has the unique feature of providing better data flow with less input time.

這種X2500型的特點就是減少輸入時間，使資料更為順暢。

608 Compared to the previous model, our new model is less expensive and easier to use.

與舊型機比較我們的新型價格便宜且更容易操作。

609 It's available in a variety of sizes at convenience stores and department stores as well.

有各種大小型號，在便利商店和百貨公司均有。

610 This is a revolutionary new product.

這是一種革命性的新產品。

611 The X2500 will change your work in the office.

X2500將會改變你在辦公室的工作。

612 We now have five different models to choose from.

我們現在有五種不同的型號供你選擇。

613 Now, ladies and gentlemen, I'd be happy to answer any questions that you might have.

各位女士各位先生，現在你們有任何問題我都樂意答復。

614 Are there any questions?

還有什么問題嗎？

615 Do you have any questions at this point?

就這一點你們還有什么問題嗎？

616 If you have no questions, may I go on to the next stage?

如果你們沒有問題了，我可以進行下一階段嗎？

617 Now, I'd be happy to answer your questions.

現在，我樂意答復你們的問題。

618 I'd like to allow anyone to ask whatever questions they may have.

我樂意接受任何人提出的任何問題。

619 Your question is how we developed our product?

你的問題是我們是如何發展我們的產品？

620 For those of you that didn't hear it, the question was how soon we could expect the product to be on sale.

你們并未聽說過，問題是產品多快能上市。

621 When can we expect its delivery?

什么時間能發貨呢？

622 It's already in production, so you can expect it in stores before the end of the month.

產品已投產了，所以月底前你可以獲得。

623 When do you expect to have this ready for sale?

你希望此種商品何時上市出售呢？

624 What's the suggested retail price?

建議零售價格是多少呢？

625 What do you expect it to go for?

你們的試銷情況如何？

626 How did you decide that product was safe?

你怎樣決定產品是安全的呢？

627 What's the basis of your belief that the product is safe?

你憑什么相信產品是安全的？

628 I'd like to know how you reached your conclusions.

我想知道你們是如何得出結論的。

629 How much will it cost?

這種商品成本價是多少？

630 We've priced it at $ 98, almost 30% less than the competition.

我們訂價為98美元，幾乎少于競爭對手30%。

631 What does the test marketing show?

試銷說明了什么？

632 It was well-received in all markets, so a gain of three market share points can be expected.

這在所有市場銷售良好，所以獲得三成的市場占有率是指日可待的。

633 I'd say the expected delivery date should be by the end of the month.

我得說預定發貨日期應該在本月底。

634 The end of next month looks like the most probable sales date.

下個月底好像是最佳的銷售日。

635 We're aiming its price for $ 98.

我們訂價為98美元。

636 To answer the first part of your question, I'd like to say that our studies were very extensive.

你問題的第一部分，我要說的就是我們的研究非常廣泛。

637 If you have further questions, please contact the people listed on the last page of the report.

如果你還有問題的話，請和報告最后一頁名單上的人員聯系。

638 Excuse me. Are you Susan Davis from Western Electronics?

對不起，你是來自西方電子公司的蘇姍·戴衛斯嗎？

639 Yes, I am. And you must be Mr. Takeshita.

是的，我就是，你一定是竹下先生吧。

640 Pardon me. Are you Ralph Meyers from National Fixtures?

對不起，請問你是從國家裝置公司來的雷夫·梅耶史先生嗎？

641 I'm Dennis. I am here to meet you today.

我是丹尼斯，今天我到這里來接你。

642 I'm Donald. We met the last time you visited Taiwan.

我是唐納德，上次你來臺灣時我們見過面。

643 I'm Edwin. I'll show you to your hotel.

我是愛德溫，我帶你去旅館。

644 How was your flight? Was it comfortable?

你坐的班機怎么樣？還舒服嗎？

645 It was quite good. But it was awfully long.

班機很好，就是時間太長了。

646 Did you have a good flight?

你旅途愉快嗎？

647 Not really, I'm afraid. We were delayed taking off, and we encountered a lot of bad weather.

不太好，我們起飛延誤了，還遭遇了惡劣的氣候。

648 How was your flight?

你的航班怎樣？

649 Did you get any sleep on the plane?

你在飛機上睡覺了嗎？

650 Mr. Wagner, do you have a hotel reservation?

華格納先生，你預訂過旅館嗎？

651 No, I don't. Will it be a problem?

不，我沒有，會有困難嗎？

652 I don't think so. I know several convenient hotels. Let me make some calls.

我認為沒有，我知道有幾家便利旅館，讓我打幾個電話。

653 I've made a reservation at the hotel you used last time.

我已預訂了你上次住過的旅館。

654 We've booked a Western-style room for you.

我們已為你訂了一間西式的房間。

655 Let's go to the station to get a train into town.

我們到火車站去乘車進城。

656 Does it take long to get into Taibei from here?

從此地去臺北要很久嗎？

657 It's about an hour.

大概要一個小時。

658 We'll get a taxi from the station.

我們到火車站乘出租車。

659 There's a shuttle bus we can use.

我們可搭乘機場班車。

660 I've brought my car, so I can drive you to your hotel.

我開車來的，所以我開車送你到旅館。

661 You must be hungry. Shall we get something to eat?

你一定餓了，我們吃點東西好嗎？

662 That sounds good. Let's get something at the hotel restaurant. I feel a little tired.

那太棒了，我們就到旅館餐廳吃點東西，我有點累了。

663 Would you like to have some dinner?

你想吃飯嗎？

664 What would you like to eat?

你想吃什么呢？

665 Can I take you out to dinner? It'll be my treat.

我帶你出去吃飯好嗎？這次我請客。

666 If you're hungry, we can eat dinner now.

如果你餓了，我們現在就去吃飯。

667 Have you had breakfast yet?

你吃過早餐了嗎？

668 Yes. It was delicious.

是的，味道很好。

669 Good. Let's go to the office.

好的，我們去辦公室吧。

670 How is your room?

你的房間怎樣？

671 Did you sleep well last night?

你昨晚睡得好嗎？

672 Why don't we go to the office now?

為何我們現在不去辦公室呢？

673 We'll start with an orientation video. It runs about 15 minutes.

我們將從一個電視簡報開始，大概放15分鐘。

674 The tour will take about an hour and a half. We ought to be back here by 3:00.

參觀大概要一個半小時，3點鐘以前回到這里。

675 Our new product line has been very successful. We've expanded the factory twice this year already.

我們新的生產線非常成功，我們今年已把工廠擴展了兩倍。

676 I'd like to introduce you to our company. Is there anything in particular you'd like to know?

我將向你介紹我們的公司，你有什么特別想知道的嗎？

677 We have some reports to show you for background information.

我們還有一些報告向你介紹背景資料。

678 Is your factory any different from other plastics factories?

你們工廠和其他塑膠工廠有何差別呢？

679 Yes, our production speed is almost twice the industry-wide average.

是的，我們的生產速度是其他工廠兩倍。

680 I'd like to explain what makes this factory special.

我要向你說明本工廠的特性。

681 This is the most fully-automated factory we have.

這是我們的全自動化工廠。

682 It's the most up-to-date in the industry.

這是同業中最新型的。

683 We've increased our efficiency by 20% through automation.

通過自動化我們的效率增加了20%。

684 Could you tell me the cost of production per unit?

請你告訴我每件成品的生產成本好嗎？

685 I'm afraid I don't know. Let me ask the supervisor in this section.

恐怕我不知道，讓我來詢問一下該組的負責人。

686 I'm not really sure about that. Mr. Jiang should know the answer to that.

關于那事我不敢確定，蔣先生應該知道答案。

687 Let me direct that question to the manager.

讓我直接問經理好了。

688 I'm not familiar with that part. Let me call someone who is more knowledgeable.

那部分我不熟悉，讓我找專業人士來說明。

689 Yes, I'd like to know your daily production.

是的，我想知道你們的日生產額。

690 Is there anything you'd like to know?

你想知道什么？

691 Is there anything I can explain fully?

有什么事情要我詳細說明的嗎？

692 What did you think of our factories?

你認為我們的工廠怎樣？

693 I was impressed very much.

我有深刻的印象。

694 Thank you very much for giving us your valuable time.

我們占用了你寶貴的時間，非常感謝。

695 We have a small gift for you to take with you when you leave the factory.

你離開工廠時，我們有件小禮物要送給你。

696 I want to purchase some computers from your company.

我想從貴公司購買一些電腦。

697 We are very interested in your printed pure silk scarves, could you give us some idea about your price?

我們對貴方的印花真絲圍巾很感興趣，請介紹一下貴方的價格好嗎？

698 We'd like to know your availability and conditions of sale of this line.

我們想了解一下你方在這方面的供貨能力及銷售條件。

699 We are in great need of Grade A.

我們急需一等品。

700 If Grade A is not available, Grade B will do.

如果一等品無貨，二等品也可以。

701 We know that you are leading exporters of coal and you can provide the quantity we need.

我們知道貴方是主要煤炭出口商，能滿足我們的需求量。

702 Please tell us the Article Number of the Product.

請您把商品貨號告訴我們。

703 Could you give me an indication of the price?

您能提供一個參考價嗎？

704 We look forward to your quotations for the arts and crafts which we are interested in. 希望貴方對我們感興趣的工藝品報一下價。

705 Do you offer FOB or CIF?

你們報船上交貨價還是到岸價？

706 Please quote us as soon as you receive our inquiry.

請接到我們的詢價單后馬上給我們報價。

707 Some of our customers have recently expressed interest in your woolen carpets and inquired about their quality and prices.

目前我們的一些客戶對你們的純毛地毯頗有興趣，并詢問其質量和價格。

708 We are thinking of placing an order for your Flying Pigeon Brand bicycles. We would be very grateful if you could make us an offer for 200 ones with details.

我們正打算訂購你方的飛鴿牌自行車。如果你們能給我們（購買）200臺的詳細報盤將不勝感激。

709 Please send us all the data concerning your Hero Brand fountain pens and ball pens, so we can introduce your products to our customers.

請寄給我們有關你方英雄牌自來水筆和圓球筆的資料，以便我們向顧客介紹你們的產品。

710 We think your Chunlan brand air conditioners will be selling well at this end and we are looking forward to receiving your samples soon.

我們認為你方的春蘭牌空調機在這里會很暢銷，希望很快收到你們的樣品。

711 Please send us your price list of quartz clocks.

請寄給我們貴方的石英鐘價目單。

712 We must make it clear from the very beginning that competitive quotations are acceptable.

必須一開始就講清的是，有競爭力的報價可以接受。

713 The above inquiry was forwarded to you on Oct. 10, but we haven't received your reply until now. Your early offer will be highly appreciated.

上述詢價已于10月10日發往你方，可是我們到現在還沒收到你方答復，請早日發盤不甚感謝。

714 We are looking forward to your reply to our inquiry.

我們期待你方對我方的詢盤做出答復。

715 We have confidence in your bamboo wares.

我們對貴方的竹制品質量充滿信心。

716 If you don't have the quality inquired for, please offer us its nearest equivalent.

如果貴方沒有所要求質量的產品，請提供與之最接近的產品。

717 Thank you for your inquiry. Please tell us the quantity you require so that we can work out the offers.

感謝貴方詢價。請告訴我們貴方所需數量以便我方報價。

718 I don't think price is a problem. The most important thing is that how many you can supply.

我認為價格不成問題。最重要的是你方能供貨多少。

719 You'd better give us a rough idea of your price.

您最好給我們一個粗略的價格。

720 We are delighted with your products and are thinking of placing an order. The size of our order will depend greatly on your price.

我們對你方的產品非常滿意，正欲訂購。我們定單的大小主要取決于你方的價格。

721 If your prices are more favorable than those of your competitors we shall send you our order.

如果你方價格比其他競爭對手的優惠，我們將向你們訂貨。

722 Would you please tell us the price of these electric heaters so as to help us make the decision.

能否告知這些電熱器的價格，以便我們作出決定。

723 Please inform us the quantity that can be supplied from stock.

請告知可供現貨的數量。

724 We are anxious to know how long it will take you to deliver the goods.

我們急于知道貴方多長時間能交貨。

725 We trust that you will quote us your most favorable price for big quantities.

相信由于我方大量訂購貴方能報最優惠價格。

726 We trust you can meet our requirements.

相信貴方能滿足我們的要求。

727 We hope this will be a good start for profitable business relations and assure you that your offer will receive our careful consideration.

希望這將是我們互利商業往來的良好開端。我們保證將對貴方的報價予以認真的考慮。

728 We usually deal on a 20% trade discount basis with an additional quantity discount for orders over 1000 units.

我們通常給予20%的商業折扣，外加訂貨1000件以上的數量折扣。

729 We would also like to point out that we mainly settle our accounts on a documents-against-acceptance basis.

我們還想指出我們主要以承兌交單方式結帳。

730 We would appreciate it if you let us know whether you allow cash or trade discounts.

若能告知你方是否給現金折扣或商業折扣，將不勝感激。

731 We intend to place large regular orders, and would therefore like to know what quantity discounts you allow.

我方將定期大量訂購，因此想知道你方給多少數量折扣。

732 Provided you can offer favorable quotations and guarantee delivery within four weeks from receipt of order, we will place regular orders with you.

貴方若能報優惠價并保證在收到定單后4周內交貨，我方將定期訂購。

733 We would like to point out that delivery before Christmas is essential and hope you can offer us that guarantee.

我們想指出圣誕節前交貨很重要并希望貴方能就此向我們作出保證。

734 Prompt delivery would be necessary as we have a fast turnover in this trade. We would therefore need your assurance that you could meet all delivery dates.

即期交貨很重要，因為這種貨流轉很快。所以我們需要你方保證及時交貨。

735 We are delighted to know that you deal with export of Chinese chinaware. Could you supply us 300 sets of tableware for shipment before the end of May?

欣悉你方是中國瓷器出口商。能否給我方供應300套餐具，五月底前交貨。

736 We want to purchase Chinese tea. Please send us your best offer by fax indicating origin packing, quantity available and the earliest time of shipment.

我們欲購中國茶。請用電傳給我們報最好價，并說明產地、包裝、可供數量及最早發貨日期。

737 Please quote us your price on FOB basis, indicating the postage for dispatch by parcel post to Dalian via Tianjin.

請報FOB價，注明郵寄包裹途經青島至大連的郵資。

738 Could you please let us know what discount you can give for an order exceeding 400 sets?

能否告知定貨超過400臺你方所能給的折扣。

739 Since we are likely to place sizable orders regularly we hope that you will make some special concessions.

由于我方將定期大批量訂購，希望貴方作出一些特殊的讓步。

740 We do business on a commission basis. A commission on your prices would make it easier for us to promote sales. Even 2 or 3 percent would help.

我們是通過取得傭金來進行商業活動的。從你方價格中收取傭金，便于我方推銷。即便只有2%或3%也行。

741 I understand all your prices are on CIF basis. We'd rather have you quote us FOB prices.

得知你方報的都是到岸價，希望能給我們報船上交貨價。

742 Would you please give us a rough idea of the quantity you require?

請告知你方大概要訂多少？

743 We handle export of microwave ovens and would take the liberty to send you our price list for your reference.

我們經營微波爐出口業務，現冒昧給你方寄去我方報價單供參考。

744 We were pleased to hear from your letter of 6 August that you were impressed with our selection of toys.

我們很高興收到你方8月6日來函得知你方對我們的玩具非常感興趣。

745 We have a wide selection of sweaters that will appeal to all ages, and in particular the teenager market which you specified.

我們有各種各樣適合各個年齡層次的羊毛衫，特別是您專門提到的青少年市場。

746 Our factory would have no problem in turning out the 2000 units you asked for in your inquiry.

我們工廠完全可以生產出你方詢價單中要求的2000件貨品。

747 We can supply from stock and will have no trouble in meeting your delivery date.

我們可提供現貨并按你方所定日期交貨。

748 I am pleased to say that we will be able to deliver the transport facilities you require.

很高興告訴您你方要求的運輸設備我方可以發貨。

749 We can offer door-to-door delivery services.

我們可提供送貨上門服務。

750 We can assure you that our products are the most outstanding ones on the market today, and we offer a five-year guarantee.

我們可以向您保證我方產品是當今市場上最好的，并且可提供5年保修期。

751 Please find enclosed our current catalogue and price-list quoting CIF New York.

隨函附上我方最新的產品目錄及CIF紐約報價單。

752 The samples you asked for will follow by separate post.

貴方所要樣品另行郵寄。

753 Our stock of this commodity is limited, please place your order without delay.

我方此類商品的存貨有限，請盡快訂貨。

754 Here is a price list together with a booklet illustrating our products.

這兒有一份價目單和介紹說明我方產品的小冊子。

755 All our garments are now poly-cotton, which is stronger, needs little ironing, and allows variations in patterns.

現在我們的服裝都是滌棉料的，質地堅韌，不用熨燙并且花樣繁多。

756 We hope to hear from you soon and can assure you that your order will be dealt with promptly.

希望盡快收到貴方答復，我們保證及時處理對方定單。

757 I hope we can conclude the transaction at this price.

希望我們能就此價格達成交易。

758 I am sorry that we are unable to make you an offer for the time being.

很抱歉目前我們不能報盤。

759 Thank you for your inquiry, but we cannot make you an offer right now because we are presently unable to obtain appropriate materials.

謝謝貴方詢價，但我們不能馬上發盤，因為目前我們得不到合適的原料。

760 Since Tom Lee is our sole agent for our products in Korea, we can't make you a direct offer.

因為湯姆·李是我方產品在韓國的獨家代理人，所以我們不能直接向您發盤。

761 The goods we offered last week are running out, therefore, the offer terminates on 20th July.

上周我們報價的貨物現已售完，所以，此報價在7月20日終止。

762 We no longer manufacture pure cotton shirts as their retail prices tend only to attract that upper end of the market.

我方已不再生產純棉襯衫因為其零售價格只能吸引高檔消費者。

763 Referring to your inquiry letter dated 29th September, we are offering you the following subject to our final confirmation.

關于貴方9月29日的詢價信，我方就如下產品報價，以我方最后確認為準。

764 At your request, we are offering you the following items. This offer will remain open within 3 days.

應你方要求，我方就如下產品報價，此報價3日內有效。

765 Against your enquiry, we are pleased to make you a special offer as follows and hope to receive your trial order in the near future.

根據你方要求，我方很高興就如下商品向你方特殊報價，希望不久能收到你方的試訂單。

766 This is our official offer for each item, CIF Shanghai.

這是我方對每項產品的CIF上海的正式報價。

767 This offer is firm subject to your acceptance reaching us not later than December 15.

此報盤為實盤，但以我方在12月15日前收到你方答復為準。

768 This offer remains open until 10th February, beyond which date the terms and prices should be negotiated anew.

此盤有效期至2月10日，超過此期限條件及價格需重新協商。

769 This price is subject to change without notice.

此價格可以不經通知自行調整。

770 The offer isn't subject to prior sale.

本報盤以貨物未售出為條件。

781 I think your price is on the high side.

我認為貴方價格偏高。

782 Your price is 20% higher than that of last year.

你方價格比去年高出20%。

783 It must be rather difficult for us to push any sales if we buy it at this price.

如果我們按這個價格購買，將很能難推銷。

784 Competition for this kind of goods is tough.

這種商品的競爭非常激烈。

785 We can't persuade the end-users to buy your products at this price.

按這個價格，我們不能說服用戶購買你們的產品。

786 To conclude the business, you need to cut your price at least by 4%,I believe.

我認為要做成這筆交易，您至少要降價4%。

787 The German quotation is lower than yours.

德國報價比你們的低。

788 You know that some countries are selling this kind of products at cheap prices in large quantities.

您知道有的國家對這種商品正在削價拋售。

789 I'd like to point out that your original price exceeded the market price already. We cannot accept it.

我想指出提你方原始價格已經超出市場價格。我們不能接受。

790 If you do have the sincerity to do business with us, please show me your cards and put them on the table.

如果您確有誠意與我們做生意，請攤牌吧。

791 If your price is unacceptable, our end-users will turn to other suppliers.

如果您的價格難以接受，我們的客戶就會轉向其他的供應商。

792 If you insist on your original price, I'm afraid you will have little chance to get the business.

如果您堅持原來的價格，恐怕您獲得這筆交易的可能性極小。

793 Other suppliers have almost identical goods at the price 10% to 14% cheaper.

別的供應商有和這幾乎相同的貨，價格便宜10%至14%。

794 The market is declining, we recommend your immediate acceptance.

市場在萎縮，我們建議你方馬上接受。

795 I'm glad that we've settled the price.

很高興我們就價格達成了共識。

796 I appreciate your efforts and cooperation and hope that this will be the forerunner of other transactions in future.

非常感謝貴方的努力與合作，希望這只是我們今后業務往來的開端。

797 What's your counter-offer?

您的還價是多少？

798 It's impossible. You may notice that the cost of raw materials has gone up in recent years.

不可能，您可能注意到了近年來原材料的價格上漲了。

799 Compared with the price in the international market, our quotation is quite reasonable.

和國際市場價格相比，我方報價相比較合理。

800 The price we offered is more favorable than the quotations you can get from our competitors, I'm afraid.

恐怕我方報價比您從我方競爭對手那兒得到的報價更優惠。

801 If you take quality into consideration, you will find our price reasonable.

如果您把質量考慮進去的話，您會發現我方價格是合理的。

802 We guarantee quality products which can stand fierce competition.

我們保證提供能經得起激烈競爭的高質量產品。

803 I still have some questions concerning our contract.

就合同方面我還有些問題要問。

804 We are always willing to cooperate with you and if necessary make some concessions.

我們總是愿意合作的，如果需要還可以做些讓步。

805 If you have any comment about these clauses, do not hesitate to make.

對這些條款有何意見，請盡管提，不必客氣。

806 Do you think there is something wrong with the contract?

你認為合同有問題嗎？

807 We'd like you to consider our request once again.

我們希望貴方再次考慮我們的要求。

808 We'd like to clear up some points connected with the technical part of the contract.

我們希望搞清楚有關合同中技術方面的幾個問題。

809 The negotiations on the rights and obligations of the parties under contract turned out to be very successful.

就合同保方的權利和義務方面的談判非常成功。

810 We can't agree with the alterations and amendments to the contract.

我們無法同意對合同工的變動和修改。

811 We hope that the next negotiation will be the last one before signing the contract.

我們希望下一交談判將是簽訂合同前的最后一輪談判。

812 We don't have any different opinions about the contractual obligations of both parties.

就合同雙方要承擔的義務方面，我們沒有什么意見。

813 That's international practice. We can't break it.

這是國際慣例，我們不能違背。

814 We are prepared to reconsider amending the contract.

我們可以重新考慮修改合同。

815 We'll have to discuss about the total contract price.

我們不得不討論一下合同的總價格問題。

816 Do you think the method of payment is OK for you?

你們認為結算方式合適嗎？

817 We are really glad to see you so constructive in helping settle the problems as regards the signing of the contract.

我們很高興您在解決有關合同的問題上如此具有建設性。

818 Here are the two originals of the contract we prepared.

這是我們準備好的兩份合同正本。

819 Would you please read the draft contract and make your moments about the terms?

請仔細閱讀合同草案，并就合同各條款提出你的看法好嗎？

820 When will the contract be ready?

合同何時準備好？

[821 Please sign a copy of our Sales Contract No.156 enclosed here in duplicate and return to us for our file.

請會簽第156號銷售合同一式兩份中的一份，將它寄回我方存檔。

822 The contract will be sent to you by air mail for your signature.

合同會航郵給你們簽字。

823 Don't you think it necessary to have a close study of the contract to avoid anything missing?

你不覺得應該仔細檢查一下合同，以免遺漏什么嗎？

824 We have agreed on all terms in the contract. Shall we sign it next week?

我們對合同各項條款全無異議，下周簽合同如何？

825 All disputes arising in the course of the consignment period shall be settled amicably through friendly negotiation.

所有在運輸途中引起的糾紛都將通過友好協商，妥善加以解決。

826 We'll ship our goods in accordance with the terms of the contract.

我們將按合同條款交貨。

827 You can stay assured that shipment will be effected according to the contract stipulation.

你盡管放心，我們將按合同規定如期裝船。

828 They've promised to keep both we quality and the quantity of the 300 bicycles in conformity with the contract stipulations.

他們已承諾那300輛自行車的質量和數量一定與合同規定相吻合。

829 We are sure the contract can be carried out smoothly.

我們確信合同會順利執行的。

830 The machines will be made of the best materials and the stipulations of the contract be strictly observed.

機器將用最好的材料生產，合同的規定也將得以嚴格履行。

831 The two parties involved in a contract have the obligation to execute the contract.

合同雙方有義務履行合同。

832 Unless there is a sudden change of political situation, it is not accepted to execute the contract only partially.

除非有什么突然的政局變化，否則執行部分合同不能被接受。

833 Any deviation from the contract will be unfavorable.

任何違背合同之事都是不利的。

834 The buyer has the option of cancelling the contract.

買主有權撤消合同。

835 Any kind of backing out of the contract will be charged a penalty as has been stated in the penalty clause.

任何背棄合同的行為將受到懲罰，這已在處罰條款里寫得很清楚了。

836 We want to cancel the contract because of your delay in delivery.

由于貴方交貨拖延，我方要求取消合同。

837 The buyer has the right to cancel the contract unilaterally if the seller fails to ship the goods within the L/C validity.

如果賣方不能在信用證有效期內交貨的話，買方有權單方面取消合同。

838 You cannot break the contract without any good reason.

如果沒有什么正當理由，你們不應撕毀合同。

839 We have every reason to cancel the contract because you've failed to fulfil your part of it.

我們完全有理由取消合同，因為你們沒有完成應遵守的合同內容，履行合同。

840 One party is entitled to cancel the contract if the other side cannot execute it.

如果一方不履行合同，另一方有權取消合同。

841 Generally speaking, a contract cannot be changed after it has been signed by both parties.

一般來講，合同一經雙方簽訂就不得更改。

842 Some relative clauses in the contract have to be amended owing to the unexpected situation.

由于這種難以預料的情況，合同中的有關條款不得不做些修改。

843 Since the contract is about to expire, shall we discuss a new one?

這個合同將到期，我們來談談新合同的事宜吧。

844 Packing has a close bearing on sales.

包裝直接關系到產品的銷售。

845 Packing will help push the sales.

包裝有助于推銷產品。

846 Buyers always pay great attention to packing.

買方通常很注意包裝。

847 Different articles require different forms of packing.

不同商品需要不同的包裝。

848 Buyers, generally speaking, bear the change of packing.

一般來說，買方應承擔包裝費用。

849 How much does packing take up of the total cost of the goods?

包裝占貨物總成本的百分比是多少？

850 The packing must be strong enough to withstand rough handing.

包裝必須很堅固，能承受野蠻裝卸。

851 Strong packing will protect the goods from any possible damage during transit.

堅固的包裝可以防止貨物在運輸途中受到任何損失。

852 Cartons are seaworthy.

紙箱適合海運。

853 This kind of article is often bought as a gift, so exquisite and tasteful design is of prime importance.

人們購買這種商品通常用來贈親友，所以精美高雅的設計至關重要。

854 We'd like to hear what you say concerning the matter of packing.

我們很想聽聽你們在包裝方面有什么意見。

855 Do you have nay objection to the stipulations about the packing and shipping marks?

有關包裝運輸嘜頭的條款你們有什么異議嗎？

856 We'll pack the goods according to your instruction.

我們將按你方的要求進行包裝。

857 The goods will be packed in wood wool to prevent damage.

貨物將用細刨花包裝，以防損壞。

858 Measures should be taken to reinforce the cartons.

應采取措施加固紙箱。

859 Suggestions on packing are greatly appreciated.

我們非常歡迎大家對包裝方面提出建議。

860 Our standardized packing has been approved by many foreign clients.

許多國外客戶已經認可了我們標準化的包裝。

861 It's urgent to improve the packing.

必須馬上改進包裝。

862 Packing charges are excluded in the quoted prices.

包裝費用未算在報價中。

863 To minimize any possible damage, we've packed our goods in the way to suit for long sea-voyage.

為使損失減少到最低限度，我們對貨物的包裝足以承受長途海運。

864 Please make an offer indicating the packing.

請報價并說明包裝情況。

865 Please make sure that the goods be protected from moisture.

請保證貨物不受潮。

866 We hope your design and the color will be strongly attractive to the American people.

我們希望你們的設計和顏色對美國人具有巨大吸引力。

867 This kind of box is not suitable for the transport of the tea sets by sea.

這種箱子不適合裝茶具海運。

868 We would like to know how you will pack the silk shirts.

我們想知道你們如何包裝這些真絲襯衫。

869 Although the cartons are light and easy to handle, we think it is not strong enough to be shipped.

雖然這些紙箱輕便、易拿，但我們認為它們在運輸中不太結實。

870 Please use normal export containers unless you receive special instructions from our agents.

除非你們收到我方代理的特別指示，否則請用正常出口集裝箱。

871 All bags contain an inner waterproof lining.

所有包內都有一層防水內襯。

872 The crates are charge to you at $5 each if they are not returned to us within 2 weeks.

如果木條箱兩星期內不歸還，則每只箱扣罰五美元。

873 Solid packing and overall stuffing can prevent the cases from vibration and jarring.

堅固的木箱和箱內嚴密的填充可防止木箱受震、開裂。

874 Those goods are available in strong wooden drums of 1,2,5,10 and 20 litres.

這些貨物分別裝入1、2、5、10、20升的木桶里。

875 Fifty-litre carboy would be the most economical size. Carboys may be retained without charge for two months.

50升的瓶子應是最經濟的尺碼，這些瓶子可免費保存兩個月。

876 The various items of your order will be packed into bundles of suitable size for shipment.

你們定單上的各種貨物被打成各種大小不同的捆兒，以便于運輸。

877 Please keep the cartons to 15kg each and metal-strap all cartons in stacks of 4.

請將每個紙箱重量限制在15公斤內，并將每4箱一組用鐵條兒固定起來。

878 Each item is to be wrapped separately in grease-paper.

每件貨物應單獨用油紙包好。

879 All measurements of each case must not exceed 1.5m*1m*1m.

每只木箱體積不應超過1.5m*1m*1m。

880 Each single crate is heavily padded and packed with 4 carboys.

每只木條箱內裝4只大瓶子將空余處填滿。

881 Full details regarding packing and marking must be strictly observed.

請嚴格遵守包裝及商標的細則。

882 To facilitate carrying, rope or metal handles are indispensable and should be fixed to the boxes.

為便于搬運，繩子或鐵把手不可缺少，并將其固定在箱子上。

883 Our packing charge includes $1 for the drum, which sum will be credited on return.

包裝費中有1美元是包裝桶的費用，此費用在桶還給我們時可退回。

884 The whole carton is packed with double straps, each corner of the carton consolidated with metal angles.

紙箱外加了兩道箍，每個箱角都用金屬角加固。

885 Foam plastics are applied to protect the goods against press.

泡沫塑料用來防止擠壓。

886 It's essential to choose the right means of transportation.

選擇合適的運輸方式很重要。

887 To ensure faster delivery, you are asked to forward the order by air freight.

為了確保迅速交貨，我方要求此訂貨用空運。

888 Generally speaking, it's cheaper but slower to ship goods by sea than by rail.

總的來說，海運比鐵路運輸更便宜，但速度慢一些。

889 It's faster but more expensive to ship goods by air.

空運較快但運費較高。

890 Since we need the goods urgently, we must insist on express shipment.

由于我方急需這批貨物，我方堅持使用快遞裝運。

891 Because of the type of purchase, we can only ship by road.

由于商品的性質，我方只能使用公路運輸。

892 If the customer requests a carrier other than truck, he must bear the additional charge.

如果顧客堅持用卡車以外的運輸工具，就必須負擔額外費用。

893 The goods will be transhipped in Hong Kong.

貨物將在香港轉船。

894 There may be some quantity difference when loading the goods, but not more than 5%.

貨物裝船時可能會有一些數量出入，但不會超過5%。

895 To make it easier for us to get the goods ready for shipment, we hope that partial shipment is allowed.

為了便于我方備貨裝船，希望允許分批發運。

896 Delivery has to be put off due to the strike of the workers at the port.

由于港口工人罷工，交貨只好推遲。

897 We are sorry to delay the shipment because our manufacturer has met unexpected difficulties.

恕延期貨船，因為我們廠家遇到了預料不到的困難。

898 We assume that damage occurred while the consignment was in your care.

我們認為貨物是在你方保管時受到損害的。

899 The consignment appears to have been roughly handled and left near a heater.

看來貨物未受到細心的處理，并且被放置于加熱器附近。

900 I'm afraid I have some rather bad news for you.

我恐怕有些很壞的消息要告訴你。