c*********l
发帖数: 17 | 1 If I have two relations:
Employee(SSN, salary, name) SSN is primary key
Position(pID, pName, state) pID is primary key, state is the US state in
which a position released
And one relationship which link the two tables:
EP(SSN, pID, tDate) SSN, pID is primary key. tDate is the date on which
position was taken
Now I wanna write a SQL to retrieve data that meet requirement below from the
database: List the last four positions that took place in Illinois
Please give my some ideas, thank |
|
n*******s
发帖数: 4 | 2 I am very new to PL/SQL. Wish somebody can help me out.
Try to write something to a local file from a procedure, not just spool the
buffer, coz the buffer has limit of 255 char per line which is not large
enough for me. If you know how to increase this, please let me know.
I googled and found a package called UTL_FILE. Following the syntex, I wrote
something like this:
DECLARE
f utl_file.file_type;
BEGIN
f := utl_file.fopen('c:/nerdgirl', 'test.txt', 'w');
utl_file.put_line(f, 'blahblah |
|
x**i
发帖数: 403 | 3 我在使用window server + was6.0,通过JDBC Driver连接到ORACLE数据库。每天第一次
连接的时候都会出现以下错误，但是再次连接就可以了。
SQL Exception: SQL state = null; error code = 17002; error Message = Io
exception: Connection reset by peer: socket write error
请问那位高人之道是什么原因？谢谢。 |
|
d*******n
发帖数: 524 | 4 We have a table (T_1) with e.g. 4 columns
T_1:
x y x z
1 2 3 4
3 6 1 -1
6 3 2 0
5 3 2 -10
I need a query to find out in each row which column has the max absolute value.
That is, I need to get the following table as output:
max_col
z
y
x
z
How to write this query in Oracle?
Thanks |
|
i****a
发帖数: 36252 | 5 My question is what kind of difference you want to see. If the query is
giving you the correct result then its a correct query.
Often there are multiple ways to write a query in sql. Access generated or
not, there is no need to rewrite a query just because you can. Unless you
thing there is a performance problem. |
|
l********u
发帖数: 195 | 6 table 1
product no. description
001 aa
002 bb
003 cc
table 2
Product no transcaction
001 111
001 222
003 rrr
how can I write query to find the product in table 1 that doesn't have any
transaction in table 2. query should return 2 by using the above data. |
|
i****i
发帖数: 18 | 7 I tried to use SQL server to get the aggregated donation summary (close date
between 10/1/2010 and 10/2/2011), and then put them into a new column.
I don't know how to write the query.
These data are downloaded from Salesforce platform, and I don't know whether
I can use SQL server to get the answer.
Here is the sample data:
Record ID Full Name Close Date Amount Sum
CON-737993 B Wanitta 12/21/2011 75
CON-737993 B Wanitta 11/21/2011 25
CON-194654 A. Bertsch ... 阅读全帖 |
|
m******o
发帖数: 162 | 8 我们公司急需一名IT Manager。要求有Oracle EBS R12 系统管理经验，懂Report
Writing (XML Publisher)，需要较好的英文语言和人际交流能力。需要较强 PROJECT
MANAGEMENT 能力。
公司50多人，如果能胜任工作，基本上是可以一直做到退休都不用担心 layoff 的公司
。我们的 Oracle EBS R12 上个月刚开始正式使用,负责安装的公司目前还在帮我们
DEVELOPE 一些日常使用的REPORT.开始工作可能会有点紧张，但走上正轨后工作会比较
轻松。公司只有这一个IT 职位，但硬件网络维护都外包，另外负责安装Oracle 的公司
会一直做我们的技术支持。
公司可以 sponsor 绿卡，但需要有 H-1 签证，因为今年的 H-1 配额已经用完，而我
们现在需要人开始工作越快越好。
工作稳定，环境宽松，薪酬优厚，福利还行。有意者请给我站内信简单介绍一下工作经
历，并注明薪水要求。
This is a position need to be able to deliver at least some simple repo... 阅读全帖 |
|
w****n
发帖数: 266 | 9 I am working on my course project and build an application with DB.
How to write a SQL statement to arise an trigger when the inventory of a
product is less than 5?
thanks. |
|
n***l
发帖数: 143 | 10 I have data stored in two servers, one for history and one for current data,
each one is over 500 GB. How to write ssrs reports using data from the two
servers? |
|
n***l
发帖数: 143 | 11 I have data stored in two servers, one for history and one for current data,
each one is over 500 GB. How to write ssrs reports using data from the two
servers? |
|
h****r
发帖数: 2056 | 12 Anyone can show an example on how to write an application using
Terminal Services, especially on Virtual Channel.
I Can not get examples by google.
Thanks a lot. |
|
d*r
发帖数: 238 | 13 For example, I have a class
class Class1
{
bool b;
int i;
string s;
}
How to write/read an object of Class1, say theClass, into/from an xml file
without worrying the structre of the class.
In java, I can use XmlEncoder.writeObject() and XmlDecoder.readObject(). |
|
c***m
发帖数: 2630 | 14 Rhino is a 3d program for architecture & engineering use. Very powerful
program.
I want to check if anyone is writing some plugins for it. |
|
w********i
发帖数: 244 | 15 All,
I wonder if there is benefits for performance for Writing CLR Stored
Procedures in C# ? Thank you!
hai |
|
|
m**v
发帖数: 373 | 17 1.5TB外接硬盘今天突然出现delayed write failed，
里面的目录都在但是文件都看不到了，是不是
硬盘坏了? 有没有办法把文件都拷出来？谢谢！ |
|
i*****s
发帖数: 438 | 18 Is read/write speed the same on normal hard drive,
on large data set (when the buffer size doesn't
matter)? |
|
i*****s
发帖数: 438 | 19
still, why read/write speed is not the same? |
|
|
|
f*****u
发帖数: 567 | 22 谢谢帮忙。我的确实是随机原配的，所以我也觉得应该是最佳的了。
等我试试你说的再来update。
你的Write Cache 动过没有？ |
|
|
a***e
发帖数: 27968 | 24 x201随机配的是intel?
怎么记得是samsung的
write |
|
t*****s
发帖数: 1309 | 25 ls问得好，另外write cache无疑问要开，方便的话贴一下你看的教程 |
|
t*****s
发帖数: 1309 | 26 这篇文章是在2009年，当时一代奇葩JMF602还大量在市，所以SSD多没有cache，现在除
了SF，大部分都不是这样
另外这个说法更奇怪，系统层面的writing cache不关主控的事，主控如果没有cache，
就更要开了
到160G这个升级很好，质变 |
|
|
f******e
发帖数: 3 | 28 Hi,
Could anybody give me some clue how to write search engine within my own site?
Thanks. |
|
s***w
发帖数: 521 | 29 请问Writely网站是用什么语言写的？
jsp, ruby? （我觉得ajax市技术，不是语言？） |
|
c*****t
发帖数: 1879 | 30 Does anyone know how to read/write XML configuration and/or
serialize to/from XML?
I know how to do it manually, but does Sun have tools that
just do that?
Thanks |
|
s****s
发帖数: 42 | 31 Two integer sets, how to write a subset method to check if one is the other's
subset? |
|
i*****1
发帖数: 7 | 32 Da xia,
My applications has different packages, and I want a different property file
in each package. How can I read/write some files located at the same directory
of the class file?
I can use:
InputStream in = this.getResource("filename").openStream();
To get the file content sucessfully.
But how can I change the file content? I tried
FileOutputStream out = new FileOutputStream(this.getResource("filename").
toString());
this.getResource("filename").toString() return a String like file:C://... |
|
m******t
发帖数: 2416 | 33
You guys... this isn't even about writing into a compressed file -
who says there is a compressed file to begin with? What if the class
is loaded from a URL? What if the class is loaded from a jar that
is loaded from a URL? |
|
m***r
发帖数: 294 | 34 I need to write a fuction "printing" in java swing. When you click the printer
button, you can print the display to a printer. How to do it?
Thanks |
|
h******q
发帖数: 97 | 35 hi,
i need to write a web survey to compare images. how to implement using
javascripts?
thanks |
|
S*A
发帖数: 7142 | 36 There are a few sprintf like public domain function
you can copy. MIT or BSD licensed.
If you don't deal with %f and the fancy ones, it is
actually very easy. I even write a version in assembler
before for some boot loader code. |
|
D******n
发帖数: 2836 | 37 I want to capture the video file info from the webpage, such as letv.com,
and
write a script(perl) to download it.
There is a python script for youtube ( youtube-dl ). But it doesnt work for
letv.com.
I guess it must parse some lines from the page, most likely the ones with "
swf","id=",
and then it uses some engine to dl it. But i dont know python. Any perl
package to do that? |
|
m***a
发帖数: 4 | 38 thanks for all you guys!
Just a conclusion: when you write a template, remember to put both the
declaration and the implementation into the header file. Otherwise, it might
prompt an 'unreferenced function' error.
`indexing::SortedLinkedList::push(indexing::ActiveNode*) |
|
k******r
发帖数: 2300 | 39 Do you mean you have an application, then you need project IE into your
application? I used to write a notepad plug-in. You might search for some
useful information from codeproject.com. |
|
T*****B
发帖数: 160 | 40 I want to output the the results in text format, which is in the range of 3GB.
Is there a way to open a writable File handle in gzip format, and write in
gzip format directly?
Many Thanks! |
|
m****d
发帖数: 331 | 41 I only used it under Windows...lots of stuff to learn to work under Unix/
Linux? Just wonder where to start if I want to write some codings in Unix/
Linux. Thanks. |
|
b*h
发帖数: 353 | 42 这 是 我 的 CODE：
#!C:\perl\bin\perl.exe -wT
use strict;
use CGI;
use CGI::Carp qw(fatalsToBrowser);
my $q = new CGI;
print $q->header;
print $q->start_html(-title=>'writing to a file');
open csv_file, "> /test.txt" or die "Could not open file$!";
print csv_file "It is a test!!!\n";
close csv_file;
print $q->end_html();
我 想 把 “It is a test!!!”写 到 Apache 的 DocumentRoot 下 一 个 叫 test.
txt 的文 件 里， 可 是 我 运 行 这 个 CODE 后， test.txt里 什 么 都 没 写 上
。 请 问 知 道 的 朋 友 这 是 为 什 么 ？ 我 如 何 |
|
I**********s
发帖数: 441 | 43 check your write permission |
|
b*h
发帖数: 353 | 44 上周曾问过这个问题，可能大家都去渡长周末了，只有一个人回了一下。到现在我这个
问题还没解决，请知道的朋友给指点一下。
这 是 我 的 CODE：
#!C:\perl\bin\perl.exe -wT
use strict;
use CGI;
use CGI::Carp qw(fatalsToBrowser);
my $q = new CGI;
print $q->header;
print $q->start_html(-title=>'writing to a file');
open csv_file, "> /test.txt" or die "Could not open file$!";
print csv_file "It is a test!!!\n";
close csv_file;
print $q->end_html();
我 想 把 “It is a test!!!”写 到 Apache 的 DocumentRoot 下 一 个 叫 test.
txt 的文 件 里， 可 是 我 运 行 这 个 CODE 后， test.txt里 什 么 都 没 写 上
。 请 |
|
g****z
发帖数: 2 | 45 How to read and write binary files (floating point data I/O) in Java?
Thanks! |
|
S*********r
发帖数: 42 | 46 I understand that it is supposed to have nothing related to C++/C. My
question is how I can write some code to enable the second monitor if it is
not enabled yet. |
|
a***a
发帖数: 92 | 47 我的程序读取一个很长的txt file，读到一半的时候，突然出现Access violation
writing location 0x43160036，但是查了出问题的地方，那个数据没有任何问题。那
么可能是什么原因呢？ |
|
c*******9
发帖数: 6411 | 48 I use the following code to write the xml string in UTF-8, the code does not
work in
Japanese SIJIS environment. The code that processed xml in UTF-8 format can
not
process the xml string written out this way.
DOMImplementation* impl =
DOMImplementationRegistry::getDOMImplementation(X(""));
m_theSerializer = ((DOMImplementationLS*)impl)->createDOMWriter();
string namespaceURI = "http://www.w3.org/2001/XMLSchema-instance";
string rootElement = "DMPrintRoot";
m_doc = impl->createDocume |
|
d*******n
发帖数: 524 | 49 so that later you can call this function by using any Container::
interator as input.
Say, I want function "f" to be called like this:
vector vi;
list ls;
......
f(vi.begin(), vi.end());
f(ls.begin(), ls.end());
I have not figured out how should I write the signature of f? |
|
