René's URL Explorer Experiment


Title: ORA-00922: 选项缺失或无效 · Issue #432 · APIJSON/APIJSON · GitHub

Open Graph Title: ORA-00922: 选项缺失或无效 · Issue #432 · APIJSON/APIJSON

X Title: ORA-00922: 选项缺失或无效 · Issue #432 · APIJSON/APIJSON

Description: 环境信息 系统: Windows 11 JDK: 1.8.0_17 数据库: Oracle 12C APIJSON: 5.1.0 问题描述 查询时使用性能分析关键字 @explain 报错 查询参数 { "Access": { "id": 1 }, "@explain": true } 错误信息 "ORA-00922: 选项缺失或无效" 生成的 SQL 如下: SET STATISTICS PROFILE ON SELECT * FROM (SELECT "Access...

Open Graph Description: 环境信息 系统: Windows 11 JDK: 1.8.0_17 数据库: Oracle 12C APIJSON: 5.1.0 问题描述 查询时使用性能分析关键字 @explain 报错 查询参数 { "Access": { "id": 1 }, "@explain": true } 错误信息 "ORA-00922: 选项缺失或无效" 生成的 SQL 如下: SET STATISTICS ...

X Description: 环境信息 系统: Windows 11 JDK: 1.8.0_17 数据库: Oracle 12C APIJSON: 5.1.0 问题描述 查询时使用性能分析关键字 @explain 报错 查询参数 { "Access": { "id": 1 }, "@explain": true } 错误信息 "ORA-00922: 选...

Opengraph URL: https://github.com/APIJSON/APIJSON/issues/432

X: @github

direct link

Domain: github.com


Hey, it has json ld scripts:
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"ORA-00922: 选项缺失或无效","articleBody":"**环境信息**\r\n - 系统:  Windows 11\r\n - JDK: 1.8.0_17\r\n - 数据库: Oracle 12C\r\n - APIJSON:  5.1.0\r\n\r\n**问题描述**\r\n\r\n查询时使用性能分析关键字 `@explain` 报错\r\n\r\n查询参数\r\n```json\r\n{\r\n  \"Access\": {\r\n    \"id\": 1\r\n  },\r\n  \"@explain\": true\r\n}\r\n```\r\n\r\n**错误信息**\r\n\r\n\"ORA-00922: 选项缺失或无效\"\r\n\r\n生成的 SQL 如下:\r\n```sql\r\nSET STATISTICS PROFILE ON  SELECT * FROM (SELECT \"Access\".*, ROWNUM RN FROM (SELECT * FROM \"CRUD_ACCESS\" WHERE  (  (\"id\" = 1)  ) ) \"Access\"  WHERE ROWNUM \u003c= 1) WHERE RN > 0\r\n```\r\n如上sql在oracle中手动执行也报 \u003c选项缺失或无效> 错误,怀疑 oracle 不支持 `SET STATISTICS PROFILE ON` 参数\r\n\r\n是不是我oracle哪里没设置对或者其他问题?\r\n\r\n\r\n\r\n","author":{"url":"https://github.com/ifooling","@type":"Person","name":"ifooling"},"datePublished":"2022-08-08T08:15:37Z","url":"https://github.com/APIJSON/APIJSON/issues/432"}

react-profiling0
react-import-mapreact,react-dom,react-dom/client,react-dom/profiling,react-is,react/compiler-runtime,react/jsx-dev-runtime,react/jsx-runtime,scheduler@b8488ee2c322
route-pattern/_view_fragments/issues/show/:user_id/:repository/:id/issue_layout(.:format)
route-controllervoltron_issues_fragments
route-actionissue_layout
fetch-noncev2:645e7120-b77c-fc88-5fab-c48d70fa9984
current-catalog-service-hash81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114
request-idEC4A:361535:313003:440A35:6AFCAF4A
html-safe-nonce9f718d3f79ccec018290ea5a9120e82da604d28836fa3a8b1407605020ec9607
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJFQzRBOjM2MTUzNTozMTMwMDM6NDQwQTM1OjZBRkNBRjRBIiwidmlzaXRvcl9pZCI6IjEyNTI4NzM2MjAyNDIwODM2NTgiLCJyZWdpb25fZWRnZSI6ImlhZCIsInJlZ2lvbl9yZW5kZXIiOiJpYWQifQ==
visitor-hmace97310465416218c19203eb006ffbc52d9442e876c379bf4bdd4f83663cb0cf0
hovercard-subject-tagissue:1331502485
github-keyboard-shortcutsrepository,issues,copilot
google-site-verificationApib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I
octolytics-urlhttps://collector.github.com/github/collect
analytics-location///voltron/issues_fragments/issue_layout
fb:app_id1401488693436528
apple-itunes-appapp-id=1477376905, app-argument=https://github.com/_view_fragments/issues/show/APIJSON/APIJSON/432/issue_layout
twitter:imagehttps://opengraph.githubassets.com/2adbbf7cd51f4e11c41833e0212ef696f6481cab69209625f0f4e66dad949f38/APIJSON/APIJSON/issues/432
twitter:cardsummary_large_image
og:imagehttps://opengraph.githubassets.com/2adbbf7cd51f4e11c41833e0212ef696f6481cab69209625f0f4e66dad949f38/APIJSON/APIJSON/issues/432
og:image:alt环境信息 系统: Windows 11 JDK: 1.8.0_17 数据库: Oracle 12C APIJSON: 5.1.0 问题描述 查询时使用性能分析关键字 @explain 报错 查询参数 { "Access": { "id": 1 }, "@explain": true } 错误信息 "ORA-00922: 选项缺失或无效" 生成的 SQL 如下: SET STATISTICS ...
og:image:width1200
og:image:height600
og:site_nameGitHub
og:typeobject
og:author:usernameifooling
hostnamegithub.com
expected-hostnamegithub.com
Nonee3084aead77cbcb4f4904fba53851fa1a0546b0dec3619bd250815e72588dc6d
turbo-cache-controlno-preview
go-importgithub.com/APIJSON/APIJSON git https://github.com/APIJSON/APIJSON.git
octolytics-dimension-user_id41146037
octolytics-dimension-user_loginAPIJSON
octolytics-dimension-repository_id74359442
octolytics-dimension-repository_nwoAPIJSON/APIJSON
octolytics-dimension-repository_publictrue
octolytics-dimension-repository_is_forkfalse
octolytics-dimension-repository_network_root_id74359442
octolytics-dimension-repository_network_root_nwoAPIJSON/APIJSON
turbo-body-classeslogged-out env-production page-responsive
disable-turbofalse
browser-stats-urlhttps://api.github.com/_private/browser/stats
browser-errors-urlhttps://api.github.com/_private/browser/errors
release5410e4bebd3e45b138c853ecef3992279d86d5af
ui-targetfull
theme-color#1e2327
color-schemelight dark
react-app-nameissues

Links:

Skip to contenthttps://github.com/APIJSON/APIJSON/issues/432#start-of-content
https://github.com/
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2FAPIJSON%2FAPIJSON%2Fissues%2F432
GitHubRepository hosting, code review, and collaborationhttps://github.com/platform
CopilotAI coding agent for tasks, projects, and automated workhttps://github.com/features/copilot
ActionsCI/CD and automationhttps://github.com/features/actions
Code QualityQuality analysis, fixes, and enforcementhttps://github.com/features/code-quality
CodespacesCloud development environmentshttps://github.com/features/codespaces
Code SecurityVulnerability detection and remediationhttps://github.com/security/advanced-security/code-security
Secret ProtectionSecret scanning and leak preventionhttps://github.com/security/advanced-security/secret-protection
All Featureshttps://github.com/features
Documentationhttps://docs.github.com/en
Traininghttps://learn.github.com/skills
Certificationshttps://learn.github.com/credentials
Build with Copilothttps://github.com/features/ai
Customize Copilothttps://docs.github.com/en/copilot/how-tos/copilot-on-github/customize-copilot/customize-copilot-overview
Integrationshttps://github.com/marketplace
Trending reposhttps://github.com/trending
GitHub Sponsorshttps://github.com/open-source/sponsors
Developer articleshttps://github.com/resources/articles
ChangelogYour source for the latest features, improvements, and fixes across GitHub products, all in one place.https://github.blog/changelog/
Enterpriseshttps://github.com/enterprise
Teamhttps://github.com/team
Startupshttps://github.com/enterprise/startups
Nonprofitshttps://github.com/solutions/industry/nonprofits
Healthcarehttps://github.com/solutions/industry/healthcare
Financial serviceshttps://github.com/solutions/industry/financial-services
Manufacturinghttps://github.com/solutions/industry/manufacturing
Governmenthttps://github.com/solutions/industry/government
See all industrieshttps://github.com/solutions/industry
Why GitHubhttps://github.com/why-github
Customer Storieshttps://github.com/customer-stories
Business insightshttps://github.com/solutions/executive-insights
Trust Centerhttps://github.com/trust-center
GitHub Advanced SecurityEnterprise-grade code securityhttps://github.com/security/advanced-security
Copilot for businessEnterprise-grade AI featureshttps://github.com/features/copilot/copilot-business
Premium SupportEnterprise-grade 24/7 supporthttps://github.com/enterprise/premium-support
Documentationhttps://docs.github.com/en
Resource centerhttps://github.com/resources
Bloghttps://github.blog/
Events & webinarshttps://github.com/resources/events
Community Forumhttps://github.com/orgs/community/discussions
Customer Storieshttps://github.com/customer-stories
Integrationshttps://github.com/marketplace
Customer supporthttps://help.github.com/
Traininghttps://learn.github.com/skills
GitHub Statushttps://www.githubstatus.com/
Abouthttps://github.com/about
Partnershttps://github.com/partners
Changeloghttps://github.blog/changelog/
GitHub UniverseThe event for developers, by developers — talks, workshops, and what’s next for GitHub.https://githubuniverse.com/
Pricinghttps://github.com/pricing
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2FAPIJSON%2FAPIJSON%2Fissues%2F432
Sign uphttps://github.com/signup?ref_cta=Sign+up&ref_loc=header+logged+out&ref_page=%2F%3Cuser-name%3E%2F%3Crepo-name%3E%2Fvoltron%2Fissues_fragments%2Fissue_layout&source=header-repo&source_repo=APIJSON%2FAPIJSON
Reloadhttps://github.com/APIJSON/APIJSON/issues/432
Reloadhttps://github.com/APIJSON/APIJSON/issues/432
Reloadhttps://github.com/APIJSON/APIJSON/issues/432
APIJSONhttps://github.com/APIJSON
APIJSONhttps://github.com/APIJSON/APIJSON
Codehttps://github.com/APIJSON/APIJSON
Issues237 (237)https://github.com/APIJSON/APIJSON/issues
Pull requestshttps://github.com/APIJSON/APIJSON/pulls
Actionshttps://github.com/APIJSON/APIJSON/actions
Wikihttps://github.com/APIJSON/APIJSON/wiki
Security and qualityhttps://github.com/APIJSON/APIJSON/security
Insightshttps://github.com/APIJSON/APIJSON/insights
https://github.com/APIJSON/APIJSON
New issuehttps://github.com/login?return_to=https://github.com/APIJSON/APIJSON/issues/432
New issuehttps://github.com/login?return_to=https://github.com/APIJSON/APIJSON/issues/432
#434https://github.com/APIJSON/APIJSON/pull/434
ORA-00922: 选项缺失或无效https://github.com/APIJSON/APIJSON/issues/432#top
#434https://github.com/APIJSON/APIJSON/pull/434
Bug 漏洞https://github.com/APIJSON/APIJSON/issues?q=state%3Aopen%20label%3A%22Bug%20%E6%BC%8F%E6%B4%9E%22
Oraclehttps://github.com/APIJSON/APIJSON/issues?q=state%3Aopen%20label%3A%22Oracle%22
help wanted请求帮助https://github.com/APIJSON/APIJSON/issues?q=state%3Aopen%20label%3A%22help%20wanted%22
https://github.com/ifooling
ifoolinghttps://github.com/ifooling
on Aug 8, 2022https://github.com/APIJSON/APIJSON/issues/432#issue-1331502485
TommyLemonhttps://github.com/TommyLemon
Oraclehttps://github.com/APIJSON/APIJSON/issues?q=state%3Aopen%20label%3A%22Oracle%22
on Aug 8, 2022https://github.com/APIJSON/APIJSON/issues/432#event-7145041965
https://github.com/TommyLemon
TommyLemonhttps://github.com/TommyLemon
on Aug 8, 2022https://github.com/APIJSON/APIJSON/issues/432#issuecomment-1207918511
@ifoolinghttps://github.com/ifooling
https://docs.oracle.com/cd/B10501_01/server.920/a96533/ex_plan.htmhttps://docs.oracle.com/cd/B10501_01/server.920/a96533/ex_plan.htm
https://user-images.githubusercontent.com/5738175/183393121-3d2a8f30-907f-44da-b362-3b2e9efe08bb.png
https://github.com/Tencent/APIJSON/blob/master/APIJSONORM/src/main/java/apijson/orm/AbstractSQLConfig.java#L3982https://github.com/Tencent/APIJSON/blob/master/APIJSONORM/src/main/java/apijson/orm/AbstractSQLConfig.java#L3982
https://user-images.githubusercontent.com/5738175/183392954-86bfd40a-a900-47f6-9f7e-c83f571dccf1.png
https://user-images.githubusercontent.com/5738175/179498656-963dc7d3-dce7-4be3-8d2e-e4f8ad5f2a43.png
https://github.com/Tencent/APIJSON/blob/master/CONTRIBUTING.md#%E4%B8%BA%E4%BB%80%E4%B9%88%E4%B8%80%E5%AE%9A%E8%A6%81%E8%B4%A1%E7%8C%AE%E4%BB%A3%E7%A0%81https://github.com/Tencent/APIJSON/blob/master/CONTRIBUTING.md#%E4%B8%BA%E4%BB%80%E4%B9%88%E4%B8%80%E5%AE%9A%E8%A6%81%E8%B4%A1%E7%8C%AE%E4%BB%A3%E7%A0%81
#406https://github.com/APIJSON/APIJSON/issues/406
TommyLemonhttps://github.com/TommyLemon
Bug 漏洞https://github.com/APIJSON/APIJSON/issues?q=state%3Aopen%20label%3A%22Bug%20%E6%BC%8F%E6%B4%9E%22
help wanted请求帮助https://github.com/APIJSON/APIJSON/issues?q=state%3Aopen%20label%3A%22help%20wanted%22
on Aug 8, 2022https://github.com/APIJSON/APIJSON/issues/432#event-7148325001
ifoolinghttps://github.com/ifooling
on Aug 9, 2022https://github.com/APIJSON/APIJSON/issues/432#event-7151664671
fix:解决数据源为Oracle时,@Explain 报错问题https://github.com/ifooling/APIJSON/commit/f3e7ed16a33fd148dc039532273f1840311087b7
@Explainhttps://github.com/Explain
f3e7ed1https://github.com/ifooling/APIJSON/commit/f3e7ed16a33fd148dc039532273f1840311087b7
https://github.com/ifooling
ifoolinghttps://github.com/ifooling
on Aug 11, 2022https://github.com/APIJSON/APIJSON/issues/432#issuecomment-1211819681
@TommyLemonhttps://github.com/TommyLemon
@Explainhttps://github.com/Explain
TommyLemonhttps://github.com/TommyLemon
completedhttps://github.com/APIJSON/APIJSON/issues?q=is%3Aissue%20state%3Aclosed%20archived%3Afalse%20reason%3Acompleted
#434https://github.com/APIJSON/APIJSON/pull/434
on Aug 12, 2022https://github.com/APIJSON/APIJSON/issues/432#event-7178145863
https://github.com/TommyLemon
TommyLemonhttps://github.com/TommyLemon
on Aug 12, 2022https://github.com/APIJSON/APIJSON/issues/432#issuecomment-1212965599
@TommyLemonhttps://github.com/TommyLemon
@Explainhttps://github.com/Explain
Sign up for freehttps://github.com/signup?return_to=https://github.com/APIJSON/APIJSON/issues/432
Sign in to commenthttps://github.com/login?return_to=https://github.com/APIJSON/APIJSON/issues/432
Bug 漏洞https://github.com/APIJSON/APIJSON/issues?q=state%3Aopen%20label%3A%22Bug%20%E6%BC%8F%E6%B4%9E%22
Oraclehttps://github.com/APIJSON/APIJSON/issues?q=state%3Aopen%20label%3A%22Oracle%22
help wanted请求帮助https://github.com/APIJSON/APIJSON/issues?q=state%3Aopen%20label%3A%22help%20wanted%22
https://github.com
Termshttps://docs.github.com/site-policy/github-terms/github-terms-of-service
Privacyhttps://docs.github.com/site-policy/privacy-policies/github-privacy-statement
Securityhttps://github.com/security
Statushttps://www.githubstatus.com/
Communityhttps://github.community/
Docshttps://docs.github.com/
Contacthttps://support.github.com?tags=dotcom-footer

Viewport: width=device-width


URLs of crawlers that visited me.