Is it possible to add a ORDER SIBLINGS BY fieldName inside a view? I\'ve got a hierarchical structure, in which I\'m successfully using a query with the CONNECT BY feature.
I have the following materialized view - CREATE MATERIALIZED VIEW TESTRESULT ON PREBUILT TABLE WITH REDUCED PRECISION
I\'m new to PL-SQL, and struggling to find clear documentation of operations are nested tables.Please correct any misused terminology etc.
Closed. This question is seeking recommendations for books, tools, software libraries, and more. It does not meet Stack Overflow guidelines guidelines. It is not currently accepting answers.
I have a table with 2 columns Input Co开发者_StackOverflow社区l 1 ---- Col 2 1---- aaaa 1---- bbbb 1---- cccc
Trailing spaces in the spooled output rpad(\' \',40)are getting truncated.If i remove the SET TRIMSPOOL on option the line size becomes 400 and there is a extra new line after each 开发者_开发百科sele
Is it possible to provide the direction once for all columns in an order by statement? i.e. select * from my_table
Can anyone help me spooling of data into different sheets for different queries in a excel from Oracle.
I\'m trying to build a Materialized View on top of a prebuilt table.I can use the below syntax with no modifiers and it works fine.
I a开发者_JAVA技巧m running a query on production and it is say returning me 500 rows and I have the same copy on my dev and the query is returning only 497 rows.
加载中,请稍侯......