[sqlite] what is the tool name which worked as db2's performance monitor

Hi, i just want to find a tool in oracle which could format the log and tell me who eat much cpu time. as i know, it name is performance monitor, but i do not know which could do this job in oracle. thanks. daisy ___ sqlite-users mailing list

Re: [sqlite] binding an IN

how about (tableId=? or tableId=? or tableId=? or tableId=?) just convert IN to or. -- From: "Roger Binns" Sent: Monday, July 12, 2010 11:00 AM To: "General Discussion of SQLite Database" Subject:

[sqlite] when foreign key is PRIMARY KEY AUTOINCREMENT

(ParentId));after insert into Parent values('name1'); how to get parentId and set the parentId in table Child.Thanks, Zeal. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] how to install sqlite3 in windows+python2.5

ow to install sqlite3 in windows+python2.5 > http://www.sqlite.org/sqlitedll-3_6_23_1.zip > > Am 10.06.2010 08:05, schrieb zeal: >> Hi, >> >> i could not find the sqlite3.dll from >> http://www.sqlite.org/download.html >> or w

Re: [sqlite] how to install sqlite3 in windows+python2.5

real version, but it still old, i need 3.6.23 > please help me. > > >>>> import sqlite3 >>>> sqlite3.sqlite_version > '3.3.4' > > -- > From: "zeal" > <zealx...@hotmail.com> > Sent: Thur

Re: [sqlite] how to install sqlite3 in windows+python2.5

google told me, this is the real version, but it still old, i need 3.6.23 please help me. >>> import sqlite3 >>> sqlite3.sqlite_version '3.3.4' -- From: "zeal" <zealx...@hotmail.com> Sent: Thursday, June 10, 201

[sqlite] how to install sqlite3 in windows+python2.5

hi, i installed python2.5, it seems wrapped sqlite3, but the version is 2.3.2. sqlite3 2.3.2 could not use function group_concat, so i want to use latest version of sqlite3. i know how to install sqlite3 in linux/unix, but i have no idea install sqlite3 on windows. i have

Re: [sqlite] please help beginner on install issue

I have fixed the problem with google's help: just _sqlite3.so is not installed correctly. i reinstall python, the problem is gone. thanks. -- From: "zeal" <zealx...@hotmail.com> Sent: Wednesday, May 26, 2010 2:59 PM To: "General

[sqlite] please help beginner on install issue

Hi, beginner question: i installed python, sqlite3 in linux with step: 1cd sqlite-3.6.22 2./configure --prefix=/home/omc/daisy/python/ 3make 4make install when i run the python, and want to import sqlite3, error at: Python 2.5.2 (r252:60911, May 26 2010,

Re: [sqlite] OperationalError: no such function: group_concat

users@sqlite.org> Subject: Re: [sqlite] OperationalError: no such function: group_concat > On Tue, May 18, 2010 at 10:31:55AM +0800, zeal scratched on the wall: >> Dear sqlite user group, >> >>i just run a sqlstmt like: >> >>> conn=sqlite3.connect("c:/

[sqlite] OperationalError: no such function: group_concat

Dear sqlite user group, i just run a sqlstmt like: >>> conn=sqlite3.connect("c:/tmp/tree_db.txt") >>> conn.execute("select rdn, group_concat(child_rdn) as child from cm_tree >>> group by rdn") Traceback (most recent call last): File "", line 1, in OperationalError: no such function:

[sqlite] recursive select in sqlite

dear Sqlite group, i wonder is there RECURSIVE select function in sqlite? the background for the question are: create table objects (id INTEGER PRIMARY KEY AUTOINCREMENT, name text unique) create table tree(id int, child_id int, PRIMARY KEY(id, child_id)) i want to draw the whole tree, is