STK格式的文件需要用什么软件读取呢?

STK格式的文件需要用什么软件读取呢?,第1张

STK是SIM Tool Kit的英文缩写即"用户识别应用开发工具"。它包含一组指令用于手机与SIM卡的交互,这样可以使SIM卡运行卡内的小应用程序,实现增值服务的目的。之所以称小应用程序,是因为受SIM卡空间的限制,STK卡中的应用程序都不大,而且功能简单易用。目前市场提供的主流STK卡主要有16K和32K两种;64K卡也在积极的市场推广中。
STK卡与普通SIM卡的区别在于,在STK卡中固化了应用程序。通过软件激活提供给用户一个文字菜单界面。这个文字菜单界面允许用户通过简单的按键 *** 作就可实现信息检索,甚至交易。例如终端用户想查询天气预报,在没有STK增值服务的情况下,用户需要手动编辑短消息"TQ 010",再将短消息发送到168服务平台。这样用户需要记住"TQ"是天气预报的命令代码和168服务平台号。事实上命令代码有很多如"GP"代表股票查询,"HF"代表电话费查询等。因此要用户将所有的命令代码记住是不现实的也是很不方便的。STK通过固化在卡中的程序,提供给用户"天气预报"等菜单提示,这样用户只需要输入想要查询地区的长途区号即可查询到天气情况。从而使用户不必记忆命令代码和服务平台号,达到方便用户的目的。

i
Report
the
value
of
each
stock
holding
in
UK
pounds
Sort
the
report
by
nation
and
firm
SELECT
bSTKCODE,bSTKFIRM,bSTKPRICEaExchange_Rate
AS
STKPRICE_NEW
FROM
nation
a
,stockinfo
b
WHERE
bnatcode=anatcode
ORDER
BY
bnatcode,bSTKFIRM
ii
Report
by
nation
the
total
value
of
stockholdings
SELECT
NATCODE,
sum(STKPRICESTKQTY)
AS
Tal_stockholdings
FROM
stockinfo
GROUP
BY
natcode
iii
Report
the
number
of
stocks
and
their
total
value
by
nation
SELECT
NATCODE,
COUNT(STKPRICESTKQTY)
AS
tal_num,sum(STKPRICESTKQTY)
AS
Tal_value
FROM
stockinfo
GROUP
BY
natcode
iv
Report
the
total
value
of
stocks
for
nations
with
two
or
more
listed
stocks
SELECT
NATCODE,
sum(STKPRICESTKQTY)
AS
Tal_stockholdings
FROM
stockinfo
GROUP
BY
natcode
HAVING
COUNT(STKPRICESTKQTY)>=2
v
How
many
firms
are
in
the
stock
portfolio
SELECT
COUNT()
FROM
stockinfo
vi
How
many
firms
have
stockholdings
greater
than
30000
SELECT
COUNT()
FROM
stockinfo
WHERE
STKQTY>=30001
vii
Find
the
average
dividend
SELECT
AVG(aSTKDIVbExchange_Rate)
AS
avg_div_pd
FROM
stockinfo
a
,
NATION
b
WHERE
anatcode=bnatcode
viii
What
is
the
average
yield
for
the
portfolio
SELECT
AVG((aSTKDIVSTKQTY)bExchange_Rate)
AS
avg_div_pd
FROM
stockinfo
a
,
NATION
b
WHERE
anatcode=bnatcode
Remarks:I
don't
know
what's
your
tablename
of
the
table
you
put
the
stock
portfolio
in
,so
I
set
it
"stockinfo",and
I
wish
you
can
think
about
it
that
why
I
wirte
it
like
that


欢迎分享,转载请注明来源:内存溢出

原文地址: http://outofmemory.cn/yw/12976986.html

(0)
打赏 微信扫一扫 微信扫一扫 支付宝扫一扫 支付宝扫一扫
上一篇 2023-05-29
下一篇 2023-05-29

发表评论

登录后才能评论

评论列表(0条)

保存