You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for SUBSTR


1 to 20 of 140 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


DML Reference, 10g Release 1 (10.1)

SUBSTR

stringseveral specified substrings of "abcdefg". SHOW SUBSTR('abcdefg',3,4) cdef SHOW SUBSTR('abcdefg',-5,4) cdef

SQL Reference, 10g Release 1 (10.1)

SUBSTR

SUBSTRSyntax substr::= Description of the illustration substr.gif Purpose The SUBSTR functions return a … portion of string, beginning at character position, substring_length characters long. SUBSTR … numbers passed as arguments to SUBSTR are automatically converted to integers. See Also: Oracle … Database Globalization

DML Reference, 10g Release 1 (10.1)

SUBSTR

SUBSTRThe SUBSTR function returns a portion of string, beginning at a specified character position, and a … specified number of characters long. SUBSTR calculates lengths using characters as defined by the … return value is the same data type as string. Syntax SUBSTR ( string, position [, substring_length ]) Arguments

Packages and Types Reference, 10g Release 1 (10.1)

45 DBMS_LOB

SUBSTR Functionthe beginning of the LOB. For fixed-width n -byte CLOBs, if the input amount for SUBSTR is greater … than (32767/ n ), then SUBSTR returns a character buffer of length (32767/ n ), or the length of the

Packages and Types Reference, 10g Release 1 (10.1)

161 UTL_RAW

SUBSTR FunctionThis function returns len bytes, starting at pos from RAW r.

Packages and Types Reference, 10g Release 1 (10.1)

161 UTL_RAW

Pragmaspragma restrict_references(substr, WNDS, RNDS, WNPS, RNPS);

Packages and Types Reference, 10g Release 1 (10.1)

45 DBMS_LOB

Pragmaspragma restrict_references(SUBSTR, WNDS, WNPS, RNDS, RNPS);

Packages and Types Reference, 10g Release 1 (10.1)

161 UTL_RAW

Defaults and Optional ParametersTable 161-42 SUBSTR Function Exceptions Optional Parameter Description len Position pos through to the end of r.

Packages and Types Reference, 10g Release 1 (10.1)

161 UTL_RAW

Usage NotesIf pos is positive, then SUBSTR counts from the beginning of r to find the first byte. If pos is … negative, then SUBSTR counts backward from the end of the r. The value pos cannot be 0. If len is … omitted, then SUBSTR returns all bytes to the end of r. The value len cannot be less than 1.

GeoRaster, 10g Release 1 (10.1)

4 SDO_GEOR Package Reference

georasterspatially referenced, rectified, and orthorectified. SELECT id, substr(sdo_geor.isSpatialReferenced … (tmimage),1,20) isSpatialReferenced, substr(sdo_geor.isRectified(tmimage),1,20) isRectified, substr

Packages and Types Reference, 10g Release 1 (10.1)

161 UTL_RAW

Return ValuesTable 161-43 SUBSTR Function Return Values Return Description portion of r Beginning at pos for len bytes long. NULL r input parameter was NULL.

Packages and Types Reference, 10g Release 1 (10.1)

161 UTL_RAW

ExceptionsTable 161-44 SUBSTR Function Exceptions Error Description VALUE_ERROR VALUE_ERROR is returned if: pos = 0 or > length of r len length of r - (pos-1)

GeoRaster, 10g Release 1 (10.1)

4 SDO_GEOR Package Reference

georastertable are specified as spatially referenced, rectified, and orthorectified. SELECT id, substr … (sdo_geor.isSpatialReferenced(tmimage),1,20) isSpatialReferenced, substr(sdo_geor.isRectified(tmimage),1,20 … ) isRectified, substr(sdo_geor.isOrthoRectified(tmimage),1,20) isOrthoRectified FROM landsat; ID

GeoRaster, 10g Release 1 (10.1)

4 SDO_GEOR Package Reference

georaster… SELECT id, substr(sdo_geor.isSpatialReferenced(tmimage),1,20) isSpatialReferenced, substr … (sdo_geor.isRectified(tmimage),1,20) isRectified, substr(sdo_geor.isOrthoRectified(tmimage),1,20) isOrthoRectified

GeoRaster, 10g Release 1 (10.1)

4 SDO_GEOR Package Reference

georastercolumn value of 4 in the LANDSAT table. (The output is reformatted for readability.) SELECT substr … (sdo_geor.getVAT(tmimage, 0),1,20) vatTable0, substr(sdo_geor.getVAT(tmimage, 1),1,20) vatTable1 … , substr(sdo_geor.getVAT(tmimage, 2),1,20) vatTable2, substr(sdo_geor.getVAT(tmimage, 3),1,20) vatTable3

Packages and Types Reference, 10g Release 1 (10.1)

45 DBMS_LOB

Return ValuesTable 45-53 SUBSTR Function Return Values Return Description RAW Function overloading that has a

GeoRaster, 10g Release 1 (10.1)

4 SDO_GEOR Package Reference

georasterobject (TMIMAGE column) in the row with the ID column value of 4 in the LANDSAT table. SELECT substr … (sdo_geor.getLayerID(tmimage, 0),1,12) layerID0, substr(sdo_geor.getLayerID(tmimage, 1),1,12) layerID1 … , substr(sdo_geor.getLayerID(tmimage, 2),1,12) layerID2, substr(sdo_geor.getLayerID(tmimage, 3),1,12

DML Reference, 10g Release 1 (10.1)

23 STDDEV to TRACKPRG

23 STDDEV to TRACKPRGThis chapter contains the following OLAP DML statements: STDDEV STDHDR SUBSTR SUBSTRB SUBTOTAL

GeoRaster, 10g Release 1 (10.1)

4 SDO_GEOR Package Reference

georasterreadability.) SELECT substr(sdo_geor.getHistogramTable(tmimage, 0),1,20) histogramTable0, substr … (sdo_geor.getHistogramTable(tmimage, 1),1,20) histogramTable1, substr(sdo_geor.getHistogramTable(tmimage … , 2),1,20) histogramTable2, substr(sdo_geor.getHistogramTable(tmimage, 3),1,20) histogramTable3 FROM

GeoRaster, 10g Release 1 (10.1)

4 SDO_GEOR Package Reference

georasterreformatted for readability.) SELECT substr(sdo_geor.getGrayScaleTable(tmimage, 0),1,20 … ) grayScaleTable0, substr(sdo_geor.getGrayScaleTable(tmimage, 1),1,20) grayScaleTable1, substr … (sdo_geor.getGrayScaleTable(tmimage, 2),1,20) grayScaleTable2, substr(sdo_geor.getGrayScaleTable(tmimage, 3),1,20