Results for DESC


1 to 20 of 107 results. Prev  Next
Results per page:   20  | 40 | 60


Error Messages, 10g Release 1 (10.1)

13 ORA-12700 to ORA-19361

ORA-14134: indexes cannot use both DESC and REVERSEMODIFY. Action: Make sure that MOVE is the only operation specified in ALTER TABLE statement; ORA-14134: indexes cannot use both DESC and REVERSE

Error Messages, 10g Release 1 (10.1)

36 PLS-00049 to PLS-01913

PLS-01704: The expressions in a sort clause must be column specs or unsigned integers, with optional…in a sort clause must be column specs or unsigned integers, with optional ASC or DESC

Guide, 10g Release 1 (10.1)

21 SQL for Analysis and Reporting

FIRST/LAST Syntax[ DESC | ASC ] [NULLS { FIRST | LAST }] [, expr [ DESC | ASC ] [NULLS { FIRST | LAST }]]...) [OVER

Pro*COBOL® Programmer's Guide, 10g Release 1 (10.1)

4 Datatypes and Host Variables

4.5.3 Referencing VARCHAR Variables… ... 01 PART-NUMBER PIC X(5). 01 PART-DESC PIC X(20) VARYING. EXEC SQL END DECLARE SECTION END-EXEC … .... PROCEDURE DIVISION.... EXEC SQL SELECT PDESC INTO:PART-DESC FROM PARTS WHERE PNUM =:PART … -NUMBER END-EXEC. After the query executes, PART-DESC-LEN holds the actual length of the character string retrieved from the database

SQL*Plus® User's Guide and Reference, 10g Release 1 (10.1)

6 Using Scripts in SQL*Plus

Appending Text to a Linewith the text. Example 6-5 Appending Text to a Line To append a space and the clause DESC to line 4 of … (be sure to type two spaces between APPEND and DESC): APPEND DESC 4* ORDER BY SALARY DESC Type RUN to … JOB_ID='SA_MAN' 4* ORDER BY SALARY DESC EMPLOYEE_ID LAST_NAME JOB_ID MONTHLY SALARY

Guide, 10g Release 1 (10.1)

22 SQL for Modeling

Base SchemaORDER BY SUM(amount_sold) DESC) OVER (PARTITION BY country_name, prod_name) best_year, MAX … (calendar_year) KEEP (DENSE_RANK LAST ORDER BY SUM(amount_sold) DESC) OVER (PARTITION BY country_name, prod_name

Application Developer's Guide, 10g Release 1 (10.1)

7 Performance Tuning

7.7.9 How do I make a ORDER BY score query faster?CONTAINS (TEXT, 'searchterm', 1) > 0 ORDER BY SCORE(1) DESC; Note that for this to work efficiently

SQL Quick Reference, 10g Release 1 (10.1)

2 SQL Functions

Syntax for SQL Functions(analytic_clause) ] CUME_DIST (aggregate) CUME_DIST(expr[,expr ]...) WITHIN GROUP (ORDER BY expr [ DESC | ASC … ] [ NULLS { FIRST | LAST } ] [, expr [ DESC | ASC ] [ NULLS { FIRST | LAST } ] ]... ) CUME_DIST … BY expr [ DESC | ASC ] [ NULLS { FIRST | LAST } ] [,expr [ DESC | ASC ] [ NULLS { FIRST | LAST … , XPath_string

DML Reference, 10g Release 1 (10.1)

FILEVIEW

FILEVIEWspecifying the format of the input and the processing of the output. Syntax FILEVIEW  fileunit  [ field-desc...] Arguments

Application Developer's Guide, 10g Release 1 (10.1)

7 Performance Tuning

7.7.19 What optimizer hints are available, and what do they do?SCORE(n) DESC tells Oracle Text to accept a sorted set from the text index, and not to do a further

Reference, 10g Release 1 (10.1)

11 CWM2_OLAP_DIMENSION_ATTRIBUTE

11.2 Example: Creating a Dimension AttributeNames', 'Short Desc Product', 'Short Name of Products', TRUE);

Guide, 10g Release 1 (10.1)

21 SQL for Analysis and Reporting

Hypothetical Rank and Distribution SyntaxBY order by expression [ASC|DESC] [NULLS FIRST|NULLS LAST][,...] ) Here, constant expression refers … that define the sorting order on which the ranking will be based. ASC, DESC, NULLS FIRST, NULLS LAST … cust_city, RANK(6000) WITHIN GROUP (ORDER BY CUST_CREDIT_LIMIT DESC) AS HRANK, TO_CHAR(PERCENT_RANK(6000 … GROUP (ORDER BY

Release 1.8, 10g Release 1 (10.1)

Oracle Reserved Words, Keywords, and Namespaces

ACCESS ELSE MODIFY STARTVARCHAR2 DELETE LONG ROWID VIEW DESC MAXEXTENTS ROWLABEL WHENEVER DISTINCT MINUS ROWNUM WHERE DROP MODE ROWS WITH

Reference, 10g Release 1 (10.1)

2 Creating OLAP Catalog Metadata with CWM2

Column Name Data TypeDescription', 'Long Descriptions', 'Long Desc', 'Long Product Descriptions', true); exec … ', 'Long Description', 'L4', 'Long Description', 'PRODUCT_LABEL', 'L4 Long Desc', 'Long Labels for … ', 'Long Description', 'L3', 'Long Description', 'SUBCATEGORY_LABEL', 'L3 Long Desc', 'Long Labels … ', 'PRODUCT_DIM', 'Long Description',

Guide, 10g Release 1 (10.1)

21 SQL for Analysis and Reporting

RANK and DENSE_RANK Functionsvalues depends on the ASC or DESC arguments. Null values are considered larger than any other values. If … -deterministic. Ranking Order The following example shows how the [ASC | DESC] option changes the … (amount_sold) DESC NULLS LAST) AS custom_rank FROM sales, products, customers, times, channels, countries … TRUNC(SUM(amount_sold),

Application Developer's Guide, 10g Release 1 (10.1)

7 Performance Tuning

7.2.4 Improved Response Time with Local Partitioned Index for Order by Scorecontains(doc, 'oracle', 1)>0 order by score(1) desc; and you are only interested in fetching top 20 rows … where contains(doc, 'oracle', 1)>0 order by score(1) desc) where rownum See Also: Oracle Database

JDBC Developer's Guide and Reference, 10g Release 1 (10.1)

13 Working with Oracle Object Types

13.4.4 Creating Subtype Objectsconnection StructDescriptor desc = StructDescriptor.createDescriptor ("SCOTT.PARTTIMESTUDENT", conn … defined in // PARTTIMESTUDENT_T }; STRUCT s = new STRUCT (desc, conn, attrs); s is initialized with data

Application Developer's Guide, 10g Release 1 (10.1)

1 Oracle Text Application Development

1.6.3 Combining Oracle Text features with Oracle XML DBdesc') > 0; You can specify more complex criteria with XPATH expressions using INPATH operator … : SELECT id from po_tab where CONTAINS(doc, 'Pentium INPATH (/purchaseOrder/items/item/desc') > 0; 1.6.3.2 … . For example:SELECT Extract(doc, '/purchaseOrder//desc{ora:contains(.,"pentium")>0]', 'xmlns:ora

Replication Administrator's Guide, 10g Release 1 (10.1)

14 Multiple Source Replication Example

Make DML and DDL Changes to Tables in the hr Schema… CONNECT hr/hr@mult1.net DESC hr.jobs CONNECT hr/hr@mult2.net DESC hr.jobs CONNECT hr/hr@mult3.net … DESC hr.jobs Each database should show job_name as the second column in the table.

JDBC Developer's Guide and Reference, 10g Release 1 (10.1)

13 Working with Oracle Object Types

13.6.2 Steps for Retrieving Object Meta Datadescriptor StructDescriptor desc = StructDescriptor.createDescriptor (type_name, conn); // get type meta





Was this page helpful?

Integrated Cloud Applications & Platform Services