Oracle PLSQL Tutorial SQL Data Types 154 codes

  1. Home
  2. Oracle PLSQL Tutorial
  3. SQL Data Types
1 -
2 (sysdate-start_date)365
3 A D or B C
4 A M or P M
5 A normalization to DB timezone
6 AD or BC
7 Add an index to a varchar2 type column
8 Add condition constraint to date type column
9 Add the time zone to your TIMESTAMP clause
10 AM or PM
11 BETWEEN for date type value
12 By default, the database outputs dates in the format DD-MON-YY
13 Call SYSDATE in insert statement
14 Cast string to date in where clause
15 CC
16 Change datatype of an existing column
17 Change timezone
18 CHAR type column
19 Character varying column
20 Check Date format before inserting
21 Combining TO_CHAR() and TO_DATE() Calls
22 Compare date type value in where clause
23 Compare Number type in where clause
24 Compare VARCHAR2 type value for equlity
25 Concatenate strings
26 Convert char to number implicit in where clause
27 Converting a DATE to Another Language
28 Converting a Number Representation to DATE Format
29 Converting a Spelled Date to DATE Format
30 Converting Datetimes Using TO_CHAR() and TO DATE()
31 D
32 Date calculation
33 Datetime Formatting Parameters for TO_CHAR() function
34 DAY
35 DAY MON, YY AD
36 DD
37 DDD
38 DDSPTH of MONTH, YEAR A D
39 Default time field
40 DY
41 Format interval type column
42 Greater than a date
43 HH
44 HH24
45 I
46 Insert data into timestamp column
47 Insert data into timestamp with local time zone type column
48 Insert data to timestamp with time zone type column
49 Insert Date value with default format
50 Insert value to interval type column
51 INSTR(first_name,,, 1)
52 INTERVAL 0-5 YEAR TO MONTH
53 INTERVAL 1 YEAR
54 INTERVAL 11 MONTH
55 INTERVAL 123 2
56 INTERVAL 123 YEAR(3) TO MONTH
57 INTERVAL 1234 2
58 INTERVAL 1234 YEAR(3)
59 INTERVAL 1-3 YEAR TO MONTH
60 INTERVAL 14 MONTH
61 INTERVAL -1-5 YEAR TO MONTH
62 INTERVAL 2 HOUR
63 INTERVAL 25 MINUTE
64 INTERVAL 3 2
65 INTERVAL -3 2
66 INTERVAL 3 DAY
67 INTERVAL 45 SECOND
68 Interval type column
69 IW
70 IY
71 IYY
72 IYYY
73 J
74 MI
75 MM
76 MON
77 MONTH
78 National char type column
79 NOT BETWEEN with varchar type
80 Not equal operator for varchar
81 Number column
82 NUMBER data type
83 NUMBER datatype
84 NUMBER(4,2) as column type
85 Oracle SQL Types
86 Plus two number type columns together
87 Process and store a specific date and time
88 Proper Use of the Default Format Mask
89 Q
90 Query for NULL Date type data
91 RM
92 Round a timestamp
93 RR
94 RRRR
95 Save HTML value to table
96 Save xml data to varchar2 type column
97 SCC
98 Search for String Across Columns
99 Select 5 1d, 42f from dual
100 SELECT TO_CHAR(ADD_MONTHS(TO_DATE(01-JAN-2005 19
101 SELECT TO_CHAR(SYSDATE, DDMMYYYY)
102 SELECT TO_CHAR(SYSDATE, P M ) (2)
103 SELECT TO_CHAR(SYSDATE, PM)
104 SELECT TO_CHAR(TO_DATE(05-FEB-1968), MONTH DD, YYYY)
105 SELECT TO_DATE(7 4 06, MM DD YY)
106 SELECT TO_DATE(July 4, 2006, MONTH DD, YYYY)
107 Setting the Default Date Format
108 SS
109 Storing and Retrieving Dates
110 Supply a time zone region
111 SYYYY
112 The Database Time Zone and Session Time Zone
113 TIMESTAMP literal supports Time Zone (as offset from UTC) Default is SESSION Timezone
114 Time Zone-Related Functions
115 Timestamp column
116 Timestamp with local time zone type column
117 Timestamp with time zone type column
118 TO_CHAR() with select statement
119 TO_CHAR(start_date, MM-DD-YYYY HH24
120 TO_CHAR(SYSDATE, B C ) (2)
121 TO_CHAR(SYSDATE, BC)
122 TO_CHAR(SYSDATE, MONTH DD, YYYY, HH24
123 TRUNC(Start_date)
124 Understanding Time Zones
125 Update VARCHAR column
126 Use concatenated string in where clause
127 Use IN for number value
128 Use IN for varchar type
129 Use int as column type
130 Use Like operator on VARCHAR2 column
131 Use the DATE keyword to supply a date literal to the database
132 Use TIMESTAMP in insert statement to add value to interval type column
133 Use TIMESTAMP(4) WITH LOCAL TIME ZONE as column type
134 Use timestamp in insert statement
135 Use timestamp with time zone type column in where clause
136 Use timestamps
137 Using the INTERVAL DAY TO SECOND Type
138 Using the TIMESTAMP Type
139 Using the TIMESTAMP WITH LOCAL TIME ZONE Type
140 Using the TIMESTAMP WITH TIME ZONE Type
141 Using Time Intervals
142 Using TO_CHAR() to Convert a Datetime to a String
143 Varchar type column
144 Varchar type not equals or not null value
145 Varchar type not equals or null value
146 Varchar2 type column with default value
147 W
148 WW
149 Y
150 Y,YYY
151 YEAR
152 YY
153 YYY
154 YYYY