oracle
How can I get the best Hierarchical Query performance in oracle
I have a table reply of which structure is following: Idnameparent_id ... 1reply10 2reply21 3reply32 4reply43[详细]
2023-04-12 12:39 分类：问答Counting Pairs in SQL
I have a database that contains 2 tables: Users (user_id primary key), and Friends The friends table is organized into 2 columns friend1, friend2, both of which contain user_ids as (foreign keys ref[详细]
2023-04-12 11:43 分类：问答What should I change in the query below?
SELECT ERI.ATTACK_CASE_ID, LRM.REF_VALUE AS ATTACK_CASE_STATUS, WDR.RESTRICTION_NAME, LL.USER_LABEL AS ***RESTRICTION_STATUS***,[详细]
2023-04-12 11:39 分类：问答Does a "union all" materialized view take space?
Does a refresh fast on commit union all materialized view (in Oracle) copy all the underlying data, or does it just have a reference to it?[详细]
2023-04-12 11:38 分类：问答Oracle : SQL Optiomization - Part 2
How can I optimize this SQL below? this query takes forever to run :( SELECT DISTINCT CONNECT_BY_ROOT a.dst_ID_key AS root_ID_key, a.src_ID_key[详细]
2023-04-12 11:26 分类：问答How to return IDs on insert in mybatis and oracle with annotation
I am trying the following in Java @Insert(\"INSERT INTO USERS (ID,NAME,AGE) VALUES(USER_SEQ.NEXTVAL,#{name开发者_JAVA百科},#{age})\")[详细]
2023-04-12 11:09 分类：问答Stored Procedure COMPILE Error
Can Someone help me on this , this is the error message I am gett开发者_StackOverflow社区ing when I run this script[详细]
2023-04-12 11:04 分类：问答Deriving a column's data from a matching column in SQL
So I have a table that has, employee number, employee name, supervisor number. I want to run a query that will retrieve employee name, employee number, supervisor name and supervisor number. Only on[详细]
2023-04-12 09:05 分类：问答SQLPlus Sub-Query Difficulty
The schema is as follows: STUDENT(*snum: integer, sname: string, major: string, slevel: string, age: integer)[详细]
2023-04-12 08:55 分类：问答Easy SQL Plus Query (group by)
I\'m trying to query my database in the following fashion: Find the name, major and age of the youngest student who is either a Math major or is enrolled in a course taught by a professor that belong[详细]
2023-04-12 08:37 分类：问答
加载中,请稍侯......