首页 \ 问答 \ 将ORACLE表字段的默认值设置为公式(Set ORACLE table fields default value to a formular)

将ORACLE表字段的默认值设置为公式(Set ORACLE table fields default value to a formular)

 我有一个像这样的oracle表：  
create table tms_transaction_tbl
(
trans_id number primary key,
location_id number,
trans_date date,
resource_id number,
ts_id number,
max_value number,
booked_units number default 0,
remaining number default (select max_value-booked_units),
booked number not null ,
user_id number,
trans_time timestamp
);
 
 如你所见，我试图将剩余的默认值设置为（max_value-booked_units）  
remainging number default (select max_value-booked_units),
 
 但它给了我这个错误这个错误  
ora-22818:subquery expression not allowed here

I have an oracle table like this: 
create table tms_transaction_tbl
(
trans_id number primary key,
location_id number,
trans_date date,
resource_id number,
ts_id number,
max_value number,
booked_units number default 0,
remaining number default (select max_value-booked_units),
booked number not null ,
user_id number,
trans_time timestamp
);
 
as you can see I tried to set default value of remaining to (max_value-booked_units) 
remainging number default (select max_value-booked_units),
 
but it gives me this error this error 
ora-22818:subquery expression not allowed here

原文：

更新时间：2022-03-10 20:03

最满意答案

 您正在使用错误的库来完成工作。 urllib模块提供发送http请求并在程序中捕获结果的函数。 它与Web浏览器无关。 您正在寻找的是webbrowser模块。 这是一个例子：  
import webbrowser
webbrowser.open('http://google.com')
 
 这将在您的浏览器中显示该网页。 

You are using wrong library for the job. urllib module provides functions to send http requests and capture the result in your program. It has nothing to do with a web browser. What you are looking for is the webbrowser module. Here is an example: 
import webbrowser
webbrowser.open('http://google.com')
 
This will show the web page in your browser.

将ORACLE表字段的默认值设置为公式(Set ORACLE table fields default value to a formular)

最满意答案

相关问答

python3.5中没有urllib2怎么处理？[2023-04-09]

使用python 3.5和urllib禁用SSL认证(Disable SSL authentification using python 3.5 and urllib)[2022-05-14]

需要运行Python 3.5(Need to run Python 3.5)[2023-06-27]

Python 3.5无法打开url-错误（http 403）(Python 3.5 can not open a url- error (http 403))[2022-05-29]

Urllib Python 3.5中的西里尔语编码(Cyrillic Encoding in Urllib Python 3.5)[2022-04-20]

Python urllib简单的登录脚本(Python urllib simple login script)[2022-02-23]

Python 3.5 Selenium Webdriver Chrome(Python 3.5 Selenium Webdriver Chrome)[2023-07-31]

python urllib的问题(Problem with python urllib)[2023-09-01]

Python 3.5 urllib不会在浏览器中打开网页(Python 3.5 urllib won't open webpage in browser)[2022-02-08]

无法在python 3.5中导入urllib3(Unable to import urllib3 in python 3.5)[2022-11-09]

相关文章

最新问答