Built-in functions/operators available for manipulating Strings The most useful ones are LENGTH, SUBSTR, INSTR, and ||: LENGTH(str) returns the length of str in characters. SUBSTR(str,m,n) returns a portion of str, beginning at character m, n characters long. If n is omitted, all characters to the end of str will be returned. INSTR(str1,str2,n,m) searches str1 beginning [...]
Tech Blog
Blog Stats
- 56,060 hits
Tea Break
Blog Post History
| M | T | W | T | F | S | S |
|---|---|---|---|---|---|---|
| « Apr | ||||||
| 1 | 2 | 3 | ||||
| 4 | 5 | 6 | 7 | 8 | 9 | 10 |
| 11 | 12 | 13 | 14 | 15 | 16 | 17 |
| 18 | 19 | 20 | 21 | 22 | 23 | 24 |
| 25 | 26 | 27 | 28 | 29 | 30 | |
Oracle Blogs
Oracle Documentation
UNIX/LINUX
Categories
- Backup and Recovery (11)
- Business Intelligence (1)
- Data Dictionary (7)
- Dictionary Tables (2)
- Performance Views (1)
- Data Storage (1)
- DBA Tasks and Interview Stuff (1)
- Hardware (1)
- oracle (1)
- Oracle Architecture (23)
- Initialization parameters (5)
- Memory Architecture (4)
- Oracle Memory (3)
- Process Architecture (3)
- SGA (2)
- Storage Architecture (11)
- Tablespaces (3)
- Oracle Concepts (2)
- Oracle DBA (2)
- Oracle Installation Creation Configuration (2)
- Oracle Issues (3)
- Oracle Network (4)
- Listener (2)
- Oracle TNS (2)
- Oracle SQL (9)
- Dynamic SQL (1)
- SQL Functions (1)
- String Functions (1)
- SQL Hints (1)
- Table SQL (2)
- Oracle Tools (1)
- Oracle Utilities (6)
- Performance Monitoring and Maintenance (1)
- Performance Tuning (14)
- SQL Optimization (5)
- SQL Joins (1)
- STATISTICS (1)
- SQL Optimization (5)
- PL SQL (6)
- Functions (1)
- Packages (2)
- Procedures (2)
- Portals (1)
- Schema Objects (10)
- Security (4)
- Privileges (1)
- Table (1)
- Users (2)
- SQL Server (3)
- Streams (1)
- Uncategorized (5)
- UNIX (7)
- AWK and SED (2)
- Utilities (3)
- Windows Utilities (1)
Category Cloud
Backup and Recovery Data Dictionary Indexes Initialization parameters Listener Logical Backup Export Import Memory Architecture Oracle Architecture Oracle DBA Oracle Issues Oracle Memory Oracle Network Oracle SQL Oracle TNS Oracle Utilities Performance Tuning PL SQL Process Architecture RMAN backup and recovery Schema Objects SGA SQL Optimization SQL Server Storage Architecture Tables Tablespaces Table SQL Uncategorized UNIX Utilities
Blog at WordPress.com. Theme: Spring Loaded by the449.
