Main Menu

Resources

Resources

Random Errors

ORA-00161: transaction branch length string is illegal (maximum allowed string)

linux

Cause: An external transaction branch ID with a length either too large or 0 was passed in.

Action: Report the problem to your external transaction coordinator vendor.

Random Errors

ORA-00151: invalid transaction ID

linux

Cause: The specified transaction ID does not correspond to an existing valid transaction.

Action: Check your application.


Designed by:
SiteGround web hosting Joomla Templates
Relational Database Definition PDF Print E-mail

linux

Oracle Relational Database Management System (RDBMS)

Oracle Relational Database Management System is a general purpose relational database package which is available on SSA, and can be bought for Suns and PCs under a site licence. Files produced on one computer system can easily be migrated to another system.

Definition of database terms

A database is a collection of data relating to a particular topic. The data is arranged in tables consisting of rows and columns.

Each row is a single entry or record in the table and is divided into fields, one for each column in the table. Data records are usually accessed by their content, rather than their position in the table.

A relational database can contain more than one table, which may be related to each other using one or more columns in common.

Example database

For example, a database containing information about cars built before 1960 might be divided into two tables, one with information about each model of car and one with information about the manufacturers of the cars. Since each manufacturer might make several models of car, having two tables avoids duplicating the information about the manufacturer.

The tables are related by the column 'make' in the CAR table which is the same as the column 'name' in the MANUFACTURER table.

This database is used as an example together with the Injury database in local documents describing Oracle.

 

Write comment (1 Comment)
 
linux
ASCII Codes PDF Print E-mail

linux

ASCII CHARCODES

Dec Hex Oct Char
64 40 100 @
65 41 101 A
66 42 102 B
67 43 103 C
68 44 104 D
69 45 105 E
70 46 106 F
71 47 107 G
72 48 110 H
73 49 111 I
74 4A 112 J
75 4B 113 K
76 4C 114 L
77 4D 115 M
78 4E 116 N
79 4F 117 O
80 50 120 P
81 51 121 Q
82 52 122 R
83 53 123 S
84 54 124 T
85 55 125 U
86 56 126 V
87 57 127 W
88 58 130 X
89 59 131 Y
90 5A 132 Z
91 5B 133 [
92 5C 134 \
93 5D 135 ]
94 5E 136 ^
95 5F 137 _
96 60 140 `
97 61 141 a
98 62 142 b
99 63 143 c
100 64 144 d
101 65 145 e
102 66 146 f
103 67 147 g
104 68 150 h
105 69 151 i
106 6A 152 j
107 6B 153 k
108 6C 154 l
109 6D 155 m
110 6E 156 n
111 6F 157 o
112 70 160 p
113 71 161 q
114 72 162 r
115 73 163 s
116 74 164 t
117 75 165 u
118 76 166 v
119 77 167 w
120 78 170 x
121 79 171 y
122 7A 172 z
123 7B 173 {
124 7C 174 |
125 7D 175 }
126 7E 176 ~
127 7F 177 DEL

 

Dec Hex Oct Char Description
0 0 000   null
1 1 001   start of heading
2 2 002   start of text
3 3 003   end of text
4 4 004   end of transmission
5 5 005   enquiry
6 6 006   acknowledge
7 7 007   bell
8 8 010   backspace
9 9 011   horizontal tab
10 A 012   new line
11 B 013   vertical tab
12 C 014   new page
13 D 015   carriage return
14 E 016   shift out
15 F 017   shift in
16 10 020   data link escape
17 11 021   device control 1
18 12 022   device control 2
19 13 023   device control 3
20 14 024   device control 4
21 15 025   negative acknowledge
22 16 026   synchronous idle
23 17 027   end of trans. block
24 18 030   cancel
25 19 031   end of medium
26 1A 032   substitute
27 1B 033   escape
28 1C 034   file separator
29 1D 035   group separator
30 1E 036   record separator
31 1F 037   unit separator
32 20 040   space
33 21 041 !  
34 22 042 "  
35 23 043 #  
36 24 044 $  
37 25 045 %  
38 26 046 &  
39 27 047 '  
40 28 050 (  
41 29 051 )  
42 2A 052 *  
43 2B 053 +  
44 2C 054 ,  
45 2D 055 -  
46 2E 056 .  
47 2F 057 /  
48 30 060 0  
49 31 061 1  
50 32 062 2  
51 33 063 3  
52 34 064 4  
53 35 065 5  
54 36 066 6  
55 37 067 7  
56 38 070 8  
57 39 071 9  
58 3A 072 :  
59 3B 073 ;  
60 3C 074 <  
61 3D 075 =  
62 3E 076 >  
63 3F 077 ?  

 

Write comment (1 Comment)
 
linux
LENGTH

linux

ORACLE CHARACTER FUNCTIONS: LENGHT

In Oracle/PLSQL, the length function returns the length of the specified string.

SYNTAX:
result:= LENGTH ( input)

Data type:
char - CHAR, VARCHAR2, NCHAR, NVARCHAR2, CLOB, NCLOB
result - NUMBER


Modifications:
LENGTH, LENGTHB, LENGTHC, LENGTH2, LENGTH4

Applies To:
Oracle 8i, Oralce 9i, Oracle 10g, Oracle 11g

Length function example:

SELECT LENGTH('TEST') FROM DUAL;
 
Wynik
---------
4
Write comment (1 Comment)
 
linux
ASCII PDF Print E-mail

linux

ORACLE CHARACTER FUNCTIONS: ASCII

In Oracle/PLSQL, the ascii function returns the NUMBER representation of the specified character.

Syntax:
output := ascii( character )

character is the specified character to retrieve the NUMBER code for. If more than one character is entered, the function will return the value for the first character and ignore all of the characters after the first.

Applies To:
Oracle 8i, Oracle 9i, Oracle 10g, Oracle 11g

ASCII function example:
SELECT ASCII('Q') FROM DUAL;  
Result
---------
81
Write comment (1 Comment)
 
linux

Random Errors

ORA-00153: internal error in XA library

linux

Cause: The XA library could not access thread-specific pointers.

Action: Contact customer support.

Resources

Latest

Most popular

Poll

Which part of site should be developed first?
 
Oracle Database Support, Powered by Joomla! and designed by SiteGround web hosting