亚洲日本一区二区一本一道,亚洲午夜久久久精品电影院,亚洲AV无码专区在线观看成人 http://www.tkk7.com/zl4393753/just do itzh-cnSat, 12 Jul 2025 03:43:42 GMTSat, 12 Jul 2025 03:43:42 GMT60oracle sign()http://www.tkk7.com/zl4393753/archive/2010/11/15/338084.htmlNeil's NoteBookNeil's NoteBookMon, 15 Nov 2010 05:47:00 GMThttp://www.tkk7.com/zl4393753/archive/2010/11/15/338084.htmlhttp://www.tkk7.com/zl4393753/comments/338084.htmlhttp://www.tkk7.com/zl4393753/archive/2010/11/15/338084.html#Feedback0http://www.tkk7.com/zl4393753/comments/commentRss/338084.htmlhttp://www.tkk7.com/zl4393753/services/trackbacks/338084.html
比較大小
select decode(sign(變量1-變量2),-1,變量1,變量2) from dual; --取較小值
sign()函數根據某個值是0、正數還是負數,分別返回0、1、-1

取最大值
select greatest('3', '5') from dual



Neil's NoteBook 2010-11-15 13:47 發表評論
]]>
ORACLE 調整數據庫內存http://www.tkk7.com/zl4393753/archive/2010/11/11/337786.htmlNeil's NoteBookNeil's NoteBookThu, 11 Nov 2010 03:03:00 GMThttp://www.tkk7.com/zl4393753/archive/2010/11/11/337786.htmlhttp://www.tkk7.com/zl4393753/comments/337786.htmlhttp://www.tkk7.com/zl4393753/archive/2010/11/11/337786.html#Feedback0http://www.tkk7.com/zl4393753/comments/commentRss/337786.htmlhttp://www.tkk7.com/zl4393753/services/trackbacks/337786.html

如何才能優化oracle的內存占用情況呢?為了開發的方便,想減少oracle平時占用的內存。下面就為您介紹一個通過調整oracle內存參數實現減少內存占用的方法,供您參考學習。

解決方法:

sqlplus “/ as sysdba"  

 create pfile='d:/cj.ora' from spfile;  

然后去你的oracle安裝目錄

找一個init數據庫名.ora這樣一個文件

把幾個oracle內存參數改小點

一個2G的內存是如下配置的:

*.sga_max_size=712M

*.large_pool_size=8M

*.shared_pool_size=250M

*.sort_area_size=0.5M

*.db_cache_size=350M

然后shutdown數據庫

shutdown immediate;  

 create spfile from pfile='d:/cj2.ora';  

 startup;  

然后啟動,就可以了。

以上就是調整oracle內存參數,減少數據庫內存占用的方法介紹。



Neil's NoteBook 2010-11-11 11:03 發表評論
]]>
Oracle 動態調用存儲過程http://www.tkk7.com/zl4393753/archive/2010/11/08/337510.htmlNeil's NoteBookNeil's NoteBookMon, 08 Nov 2010 03:30:00 GMThttp://www.tkk7.com/zl4393753/archive/2010/11/08/337510.htmlhttp://www.tkk7.com/zl4393753/comments/337510.htmlhttp://www.tkk7.com/zl4393753/archive/2010/11/08/337510.html#Feedback0http://www.tkk7.com/zl4393753/comments/commentRss/337510.htmlhttp://www.tkk7.com/zl4393753/services/trackbacks/337510.html1 EXECUTE IMMEDIATE 'begin '||proc_name|| '(:name, :name2); end;' using v_name, v_name2;

Neil's NoteBook 2010-11-08 11:30 發表評論
]]>
oracle 遞歸查詢http://www.tkk7.com/zl4393753/archive/2010/10/19/335526.htmlNeil's NoteBookNeil's NoteBookTue, 19 Oct 2010 02:19:00 GMThttp://www.tkk7.com/zl4393753/archive/2010/10/19/335526.htmlhttp://www.tkk7.com/zl4393753/comments/335526.htmlhttp://www.tkk7.com/zl4393753/archive/2010/10/19/335526.html#Feedback0http://www.tkk7.com/zl4393753/comments/commentRss/335526.htmlhttp://www.tkk7.com/zl4393753/services/trackbacks/335526.html1. 通過子節點向根節點追朔,語法:
select * from da_tree start with id='195' connect by prior parentid=id;
2. 通過根節點遍歷子節點,語法:
select * from da_tree start with parentid='21' connect by prior id=parentid;

oracle中的select語句可以用START WITH...CONNECT BY PRIOR子句實現遞歸查詢,connect by 是結構化查詢中用到的,其基本語法是:

Java代碼

select * from tablename start with cond1 connect by cond2 where cond3;

簡單說來是將一個樹狀結構存儲在一張表里,比如一個表中存在兩個字段:

id,parentid那么通過表示每一條記錄的parent是誰,就可以形成一個樹狀結構。

用上述語法的查詢可以取得這棵樹的所有記錄。




Neil's NoteBook 2010-10-19 10:19 發表評論
]]>
創建自定義返回按鈕http://www.tkk7.com/zl4393753/archive/2010/10/13/335069.htmlNeil's NoteBookNeil's NoteBookWed, 13 Oct 2010 14:14:00 GMThttp://www.tkk7.com/zl4393753/archive/2010/10/13/335069.htmlhttp://www.tkk7.com/zl4393753/comments/335069.htmlhttp://www.tkk7.com/zl4393753/archive/2010/10/13/335069.html#Feedback0http://www.tkk7.com/zl4393753/comments/commentRss/335069.htmlhttp://www.tkk7.com/zl4393753/services/trackbacks/335069.html
UIBarButtonItem *backButton = [[[UIBarButtonItem alloc] initWithTitle:@"my back button" style:UIBarButtonItemStyleBordered target:nil action:nil] autorelease]; 
self.navigationItem.leftBarButtonItem = backButton;


Neil's NoteBook 2010-10-13 22:14 發表評論
]]>
Iphone 修改默認返回的名稱http://www.tkk7.com/zl4393753/archive/2010/10/06/333848.htmlNeil's NoteBookNeil's NoteBookWed, 06 Oct 2010 13:50:00 GMThttp://www.tkk7.com/zl4393753/archive/2010/10/06/333848.htmlhttp://www.tkk7.com/zl4393753/comments/333848.htmlhttp://www.tkk7.com/zl4393753/archive/2010/10/06/333848.html#Feedback0http://www.tkk7.com/zl4393753/comments/commentRss/333848.htmlhttp://www.tkk7.com/zl4393753/services/trackbacks/333848.html

Iphone默認返回按鈕的文字是前一個view的title,

如果需要修改默認的返回名稱,需要在前一個頁面的viewDidLoad事件中進行設置:

 UIBarButtonItem *backButton = [[UIBarButtonItem alloc] initWithTitle:@"取消" style:UIBarButtonItemStylePlain target:nil action:nil];

self.navigationItem.backBarButtonItem = backButton;
[backButton release];


Neil's NoteBook 2010-10-06 21:50 發表評論
]]>
Iphone 帶NavigationBar的ModalViewhttp://www.tkk7.com/zl4393753/archive/2010/10/06/333832.htmlNeil's NoteBookNeil's NoteBookWed, 06 Oct 2010 10:16:00 GMThttp://www.tkk7.com/zl4393753/archive/2010/10/06/333832.htmlhttp://www.tkk7.com/zl4393753/comments/333832.htmlhttp://www.tkk7.com/zl4393753/archive/2010/10/06/333832.html#Feedback0http://www.tkk7.com/zl4393753/comments/commentRss/333832.htmlhttp://www.tkk7.com/zl4393753/services/trackbacks/333832.html 悲劇的thinkpad。。。所以不能截圖。。。稀爛!
1. 創建一個viewcontroller,比如SettingViewController,同時創建實現文件和頭文件,不多說
2. 創建該viewcontroller對應的view文件,比如SettingView.xib,沒什么好說的
3. 雙擊剛才創建的xib文件,指定class為第一步創建的viewcontroller,在interface builder中將view和file owner連接起來
4. 在創建的SettingViewController.h文件中定義一個bool類型的變量,該變量用來指示modal view是否已彈出,代碼如下:

@interface SettingViewController : UIViewController {

BOOL isPushedView;

}

@property (nonatomic, readwrite) BOOL isPushedView;

5. 在SettingViewController.m文件中添加具體實現代碼,如下:

@implementation SettingViewController

@synthesize isPushedView;

- (void)viewDidLoad {

    [super viewDidLoad];

    if(isPushedView == NO) {

        self.navigationItem.title = @"設置";

        self.navigationController.navigationBar.barStyle = UIBarStyleBlack;

        self.navigationItem.leftBarButtonItem = [[[UIBarButtonItem alloc] initWithTitle:@"完成" style:UIBarButtonItemStylePlain target:self     action:@selector(cancel_Clicked:)] autorelease];

    }

}


-(void) cancel_Clicked:(id)sender {    

    [self.navigationController dismissModalViewControllerAnimated:YES];     

}


- (BOOL)shouldAutorotateToInterfaceOrientation:(UIInterfaceOrientation)interfaceOrientation {

    // Return YES for supported orientations

    return (interfaceOrientation == UIInterfaceOrientationPortrait);

}

6. 在RootViewController.h文件中定義變量,代碼如下:

@class SettingViewController;

@interface RootViewController : UITableViewController {

SettingViewController *settingViewController;

UINavigationController *settingNavController;

}

7. 在RootViewController.m文件中添加實現代碼,如下:

- (void) settingClicked {  

if(settingViewController == nil) {

settingViewController = [[SettingViewController alloc] initWithNibName:@"SettingView" bundle:[NSBundle mainBundle]];

settingViewController.isPushedView = NO;

}

    if(settingNavController == nil) {

        settingNavController = [[UINavigationController alloc] initWithRootViewController:settingViewController];

[self.navigationController presentModalViewController:settingNavController animated:YES];  

}

}

8. DONE!!!



Neil's NoteBook 2010-10-06 18:16 發表評論
]]>
Iphone 不同頁面間跳轉http://www.tkk7.com/zl4393753/archive/2010/10/06/333828.htmlNeil's NoteBookNeil's NoteBookWed, 06 Oct 2010 08:34:00 GMThttp://www.tkk7.com/zl4393753/archive/2010/10/06/333828.htmlhttp://www.tkk7.com/zl4393753/comments/333828.htmlhttp://www.tkk7.com/zl4393753/archive/2010/10/06/333828.html#Feedback1http://www.tkk7.com/zl4393753/comments/commentRss/333828.htmlhttp://www.tkk7.com/zl4393753/services/trackbacks/333828.html 2. 創建一個view,比如 NewOrderView.xib
3. 雙擊打開NewOrderView.xib,指定其class為 NewOrderViewController,并在 Interface Builder中將view與File Owner連接起來
4. 在RootViewController.h文件中定義 NewOrderViewController, 設置其為屬性,代碼如下:

@class NewOrderViewController;

@interface RootViewController : UITableViewController {

NewOrderViewController *newOrderViewController;

}

@property (nonatomic, retain) NewOrderViewController *newOrderViewController;

5. 在RootViewController.m文件中實現跳轉,代碼如下:
//添加按鈕

- (void)viewDidLoad {

    [super viewDidLoad];


    self.navigationItem.title = @"訂單列表";

    self.navigationController.navigationBar.barStyle = UIBarStyleBlack;

    UIBarButtonItem *buttonEdit = [[[UIBarButtonItem alloc] initWithTitle:@"編輯" style:UIBarButtonItemStyleBordered target:self            action:@selector(editCharacters)] autorelease];

    UIBarButtonItem *buttonAdd = [[[UIBarButtonItem alloc] initWithBarButtonSystemItem:UIBarButtonSystemItemAdd target:self action:@selector(showNewOrderView)] autorelease];

    self.navigationItem.leftBarButtonItem=buttonEdit;

    self.navigationItem.rightBarButtonItem=buttonAdd;

//實現跳轉

- (void) showNewOrderView {

    if (self.newOrderViewController == nil) {

        NewOrderViewController *newOrder = [[NewOrderViewController alloc] initWithNibName:@"NewOrderView" bundle:nil];

        self.newOrderViewController = newOrder;

        [newOrder release];

    }

    [self.navigationController pushViewController:self.newOrderViewController animated:YES];



Neil's NoteBook 2010-10-06 16:34 發表評論
]]>
Iphone開發 可編輯表格http://www.tkk7.com/zl4393753/archive/2010/10/04/333730.htmlNeil's NoteBookNeil's NoteBookMon, 04 Oct 2010 07:53:00 GMThttp://www.tkk7.com/zl4393753/archive/2010/10/04/333730.htmlhttp://www.tkk7.com/zl4393753/comments/333730.htmlhttp://www.tkk7.com/zl4393753/archive/2010/10/04/333730.html#Feedback0http://www.tkk7.com/zl4393753/comments/commentRss/333730.htmlhttp://www.tkk7.com/zl4393753/services/trackbacks/333730.html

In some of the iPhone's default apps, you may find that you can "edit" a table, then have little red minus signs appear to the left of the table, giving you the option to delete those rows. So, how do you do that in your own programs?

The answers, it turns out, is a very simple one:

[self.tableView setEditing:YES animated:YES];

That's literally all you need to do to set up those deletion marks. Then you just need to respond to tableView:commitEditingStyle: forRowAtIndexPath:.

However, there are some nuances, particularly the questions of how you start up a table's editing and how you end it, and I'm going to show some real-world examples of those methods over the course of this article ...

An Actual Example

The program that I've showed off elsewhere in this series makes uses of a tableView's editing functionality by allowing the user to delete characters from the app, each of whom are represented by a table row

First, you need to set up some way to activate the functionality:

- (void)editCharacters {
    [self.tableView setEditing:YES animated:YES];
    UIBarButtonItem *doneButton = [[UIBarButtonItem alloc]
        initWithBarButtonSystemItem:UIBarButtonSystemItemDone
                                           target:self
                                           action:@selector(endTableEditing)];
    self.navigationItem.leftBarButtonItem = doneButton;
    [doneButton release];

    self.navigationItem.rightBarButtonItem = nil;
}

This method is triggered when a user selects an "Edit" button. You'll note that besides starting the editing, I also change around the button in my navbar. That's because when a user is editing I no longer need an "Edit" button, but instead require a "Done" button. You might alternatively set buttons' enabled properties to NO ... but in any case, you always need to give users a way to get out of editing mode.

Your tableView: method will probably delete the table item from your table and/or the data store that it originates from:

- (void)tableView:(UITableView *)tableView commitEditingStyle:(UITableViewCellEditingStyle)editingStyle forRowAtIndexPath:(NSIndexPath *)indexPath {

    if (editingStyle == UITableViewCellEditingStyleDelete) {
        [self recordWasDeleted:indexPath.row];
    }
}

For completeness state, I'll also include the method call generated when the "Done" button is clicked:

- (void)endTableEditing {
    [self.tableView setEditing:NO animated:YES];
    [self updateButtons];
}

This is pretty much the opposite of my editCharacters method: the editing is turned back off, then the buttons are returned to their original state.

And that's really all you need to do to edit a table: turn editing on, respond to the deletion message, and turn it back off at the end.

Doing More with Table Edits

You do have some other editing possibilities that I'm not going to cover in depth in this article. Most notably, you can adjust the editingStyle property of any individual cell. Apple claims it's set to UITableViewCellEditingStyleNone by default, but it sure looks to me like it's set to UITableViewCellEditingStyleDelete, which is what shows those handsome red minus marks. If you instead want to insert rows, you can set it to UITableViewCellEditingStyleInsert, and then do the appropriate thing when tableView:commitEditingStyle:forRowAtIndexPath: receives input of type insert.

That's it for me and tables for the nonce. If there's any other topics that you'd like covered regarding them, let me know in the comments. In the meantime, I'm planning to next return to my splashView topic, as some folks have requested in comments.



Neil's NoteBook 2010-10-04 15:53 發表評論
]]>
雪豹開機http://www.tkk7.com/zl4393753/archive/2010/09/03/330887.htmlNeil's NoteBookNeil's NoteBookFri, 03 Sep 2010 06:48:00 GMThttp://www.tkk7.com/zl4393753/archive/2010/09/03/330887.htmlhttp://www.tkk7.com/zl4393753/comments/330887.htmlhttp://www.tkk7.com/zl4393753/archive/2010/09/03/330887.html#Feedback0http://www.tkk7.com/zl4393753/comments/commentRss/330887.htmlhttp://www.tkk7.com/zl4393753/services/trackbacks/330887.html每次開機時在Bootthink選擇雪豹分區很麻煩,如果你還需要-x32之類的Flag就更麻煩了。進入F8黑白界面后選擇雪豹的20GB分區后,輸入“# b=0”回車,下次啟動時Bootthink就會跳過選擇界面,要重現選擇界面開機時按住Alt鍵,你也可以輸入“#b=X”:自定義倒計時X秒進入mac系統。進入雪豹后,用PlistEditPro打開/Library/Preference/SystemConfiguaration/com.apple.Boot.plist文件,添加-x32等你需要的啟動選項到Kernel Flag項下面即可。這樣,你只需要在開機時候選擇Windows還是Bootthink,選擇了bootthink后,就會自動進入。
如下:
<plist version="1.0">
<dict>
<key>Kernel</key>
<string>mach_kernel</string>
<key>Kernel Flags</key>
<string>-x32</string>
<key>Boot Graphics</key>
<string>Yes</string>
    <key>GraphicsEnabler</key>
<string>Yes</string>
    <key>Quiet Boot</key>
    <string>No</string>
    <key>Timeout</key>
    <string>5</string>
    <key>Graphics Mode</key>
    <string>1280x800x32</string>
</dict>
</plist>


Neil's NoteBook 2010-09-03 14:48 發表評論
]]>
主站蜘蛛池模板: 国产亚洲老熟女视频| 日韩在线a视频免费播放| 久久青青草原亚洲av无码app | 无码人妻久久一区二区三区免费| 亚洲?V无码乱码国产精品| 亚洲AV综合色区无码一二三区 | 亚洲天堂2017无码中文| 国产大片免费网站不卡美女| 亚洲高清美女一区二区三区| 日韩插啊免费视频在线观看| 色婷婷六月亚洲婷婷丁香| 24小时日本韩国高清免费| 亚洲人成免费电影| 成年女人毛片免费观看97| 亚洲另类自拍丝袜第五页| 四虎永久在线精品免费影视| 一级人做人爰a全过程免费视频| 久久精品国产精品亚洲人人| 成在线人视频免费视频| 亚洲国产精品不卡在线电影| 2021国内精品久久久久精免费| 亚洲日本在线观看网址| 最近免费中文字幕视频高清在线看 | 亚洲国产精品激情在线观看| 亚洲阿v天堂在线2017免费| 国产精品亚洲аv无码播放| 久久久久久夜精品精品免费啦| 亚洲乱码一二三四五六区| 天天摸天天碰成人免费视频| 黄色一级毛片免费看| 午夜免费福利小电影| 亚洲人成网网址在线看| 在线观看国产情趣免费视频| 国产精品免费久久久久久久久| 亚洲AV无码国产精品色午友在线 | 久久久受www免费人成| 免费国产综合视频在线看| 亚洲精品视频免费| 精品日韩亚洲AV无码| 国产免费卡一卡三卡乱码| baoyu777永久免费视频|