~ubuntu-branches/ubuntu/natty/postgresql-8.4/natty-updates

E141 Basic integrity constraints 04 Basic FOREIGN KEY constraint with the NO ACTION default for both referential delete action and referential update action YES

125

E141 Basic integrity constraints 06 CHECK constraints YES

126

E141 Basic integrity constraints 07 Column defaults YES

127

E141 Basic integrity constraints 08 NOT NULL inferred on PRIMARY KEY YES

128

E141 Basic integrity constraints 10 Names in a foreign key can be specified in any order YES

129

E151 Transaction support YES

130

E151 Transaction support 01 COMMIT statement YES

131

E151 Transaction support 02 ROLLBACK statement YES

132

E152 Basic SET TRANSACTION statement YES

133

E152 Basic SET TRANSACTION statement 01 SET TRANSACTION statement: ISOLATION LEVEL SERIALIZABLE clause YES

134

E152 Basic SET TRANSACTION statement 02 SET TRANSACTION statement: READ ONLY and READ WRITE clauses YES

135

E153 Updatable queries with subqueries NO

136

E161 SQL comments using leading double minus YES

137

E171 SQLSTATE support YES

138

E182 Module language NO

139

F021 Basic information schema YES

140

F021 Basic information schema 01 COLUMNS view YES

141

F021 Basic information schema 02 TABLES view YES

142

F021 Basic information schema 03 VIEWS view YES

143

F021 Basic information schema 04 TABLE_CONSTRAINTS view YES

144

F021 Basic information schema 05 REFERENTIAL_CONSTRAINTS view YES

145

F021 Basic information schema 06 CHECK_CONSTRAINTS view YES

146

F031 Basic schema manipulation YES

147

F031 Basic schema manipulation 01 CREATE TABLE statement to create persistent base tables YES

148

F031 Basic schema manipulation 02 CREATE VIEW statement YES

149

F031 Basic schema manipulation 03 GRANT statement YES

150

F031 Basic schema manipulation 04 ALTER TABLE statement: ADD COLUMN clause YES

151

F031 Basic schema manipulation 13 DROP TABLE statement: RESTRICT clause YES

152

F031 Basic schema manipulation 16 DROP VIEW statement: RESTRICT clause YES

153

F031 Basic schema manipulation 19 REVOKE statement: RESTRICT clause YES

154

F032 CASCADE drop behavior YES

155

F033 ALTER TABLE statement: DROP COLUMN clause YES

156

F034 Extended REVOKE statement YES

157

F034 Extended REVOKE statement 01 REVOKE statement performed by other than the owner of a schema object YES

158

F034 Extended REVOKE statement 02 REVOKE statement: GRANT OPTION FOR clause YES

159

F034 Extended REVOKE statement 03 REVOKE statement to revoke a privilege that the grantee has WITH GRANT OPTION YES

160

F041 Basic joined table YES

161

F041 Basic joined table 01 Inner join (but not necessarily the INNER keyword) YES

162

F041 Basic joined table 02 INNER keyword YES

163

F041 Basic joined table 03 LEFT OUTER JOIN YES

164

F041 Basic joined table 04 RIGHT OUTER JOIN YES

165

F041 Basic joined table 05 Outer joins can be nested YES

166

F041 Basic joined table 07 The inner table in a left or right outer join can also be used in an inner join YES

167

F041 Basic joined table 08 All comparison operators are supported (rather than just =) YES

168

F051 Basic date and time YES

169

F051 Basic date and time 01 DATE data type (including support of DATE literal) YES

170

F051 Basic date and time 02 TIME data type (including support of TIME literal) with fractional seconds precision of at least 0 YES

171

F051 Basic date and time 03 TIMESTAMP data type (including support of TIMESTAMP literal) with fractional seconds precision of at least 0 and 6 YES

172

F051 Basic date and time 04 Comparison predicate on DATE, TIME, and TIMESTAMP data types YES

173

F051 Basic date and time 05 Explicit CAST between datetime types and character string types YES

174

F051 Basic date and time 06 CURRENT_DATE YES

175

F051 Basic date and time 07 LOCALTIME YES

176

F051 Basic date and time 08 LOCALTIMESTAMP YES

177

F052 Intervals and datetime arithmetic YES

178

F053 OVERLAPS predicate YES

179

F081 UNION and EXCEPT in views YES

180

F111 Isolation levels other than SERIALIZABLE YES

181

F111 Isolation levels other than SERIALIZABLE 01 READ UNCOMMITTED isolation level YES

182

F111 Isolation levels other than SERIALIZABLE 02 READ COMMITTED isolation level YES

183

F111 Isolation levels other than SERIALIZABLE 03 REPEATABLE READ isolation level YES

184

F121 Basic diagnostics management NO

185

F121 Basic diagnostics management 01 GET DIAGNOSTICS statement NO

186

F121 Basic diagnostics management 02 SET TRANSACTION statement: DIAGNOSTICS SIZE clause NO

187

F122 Enhanced diagnostics management NO

188

F123 All diagnostics NO

189

F131 Grouped operations YES

190

F131 Grouped operations 01 WHERE, GROUP BY, and HAVING clauses supported in queries with grouped views YES

191

F131 Grouped operations 02 Multiple tables supported in queries with grouped views YES

192

F131 Grouped operations 03 Set functions supported in queries with grouped views YES

193

F131 Grouped operations 04 Subqueries with GROUP BY and HAVING clauses and grouped views YES

194

F131 Grouped operations 05 Single row SELECT with GROUP BY and HAVING clauses and grouped views YES

195

F171 Multiple schemas per user YES

196

F181 Multiple module support NO

197

F191 Referential delete actions YES

198

F200 TRUNCATE TABLE statement YES

199

F201 CAST function YES

200

F202 TRUNCATE TABLE: identity column restart option NO

201

F221 Explicit defaults YES

202

F222 INSERT statement: DEFAULT VALUES clause YES

203

F231 Privilege tables YES

204

F231 Privilege tables 01 TABLE_PRIVILEGES view YES

205

F231 Privilege tables 02 COLUMN_PRIVILEGES view YES

206

F231 Privilege tables 03 USAGE_PRIVILEGES view YES

207

F251 Domain support YES

208

F261 CASE expression YES

209

F261 CASE expression 01 Simple CASE YES

210

F261 CASE expression 02 Searched CASE YES

211

F261 CASE expression 03 NULLIF YES

212

F261 CASE expression 04 COALESCE YES

213

F262 Extended CASE expression NO

214

F263 Comma-separated predicates in simple CASE expression NO

215

F271 Compound character literals YES

216

F281 LIKE enhancements YES

217

F291 UNIQUE predicate NO

218

F301 CORRESPONDING in query expressions NO

219

F302 INTERSECT table operator YES

220

F302 INTERSECT table operator 01 INTERSECT DISTINCT table operator YES

221

F302 INTERSECT table operator 02 INTERSECT ALL table operator YES

222

F304 EXCEPT ALL table operator YES

223

F311 Schema definition statement NO

224

F311 Schema definition statement 01 CREATE SCHEMA YES

225

F311 Schema definition statement 02 CREATE TABLE for persistent base tables YES

226

F311 Schema definition statement 03 CREATE VIEW YES

227

F311 Schema definition statement 04 CREATE VIEW: WITH CHECK OPTION NO

228

F311 Schema definition statement 05 GRANT statement YES

229

F312 MERGE statement NO

230

F313 Enhanced MERGE statement NO

231

F321 User authorization YES

232

F341 Usage tables NO

233

F361 Subprogram support YES

234

F381 Extended schema manipulation YES

235

F381 Extended schema manipulation 01 ALTER TABLE statement: ALTER COLUMN clause YES

236

F381 Extended schema manipulation 02 ALTER TABLE statement: ADD CONSTRAINT clause YES

237

F381 Extended schema manipulation 03 ALTER TABLE statement: DROP CONSTRAINT clause YES

238

F382 Alter column data type YES

239

F391 Long identifiers YES

240

F392 Unicode escapes in identifiers YES

241

F393 Unicode escapes in literals YES

242

F394 Optional normal form specification NO

243

F401 Extended joined table YES

244

F401 Extended joined table 01 NATURAL JOIN YES

245

F401 Extended joined table 02 FULL OUTER JOIN YES

246

F401 Extended joined table 04 CROSS JOIN YES

247

F402 Named column joins for LOBs, arrays, and multisets YES

248

F403 Partitioned joined tables NO

249

F411 Time zone specification YES differences regarding literal interpretation

250

F421 National character YES

251

F431 Read-only scrollable cursors YES

252

F431 Read-only scrollable cursors 01 FETCH with explicit NEXT YES

253

F431 Read-only scrollable cursors 02 FETCH FIRST YES

254

F431 Read-only scrollable cursors 03 FETCH LAST YES

255

F431 Read-only scrollable cursors 04 FETCH PRIOR YES

256

F431 Read-only scrollable cursors 05 FETCH ABSOLUTE YES

257

F431 Read-only scrollable cursors 06 FETCH RELATIVE YES

258

F441 Extended set function support YES

259

F442 Mixed column references in set functions YES

260

F451 Character set definition NO

261

F461 Named character sets NO

262

F471 Scalar subquery values YES

263

F481 Expanded NULL predicate YES

264

F491 Constraint management YES

265

F501 Features and conformance views YES

266

F501 Features and conformance views 01 SQL_FEATURES view YES

267

F501 Features and conformance views 02 SQL_SIZING view YES

268

F501 Features and conformance views 03 SQL_LANGUAGES view YES

269

F502 Enhanced documentation tables YES

270

F502 Enhanced documentation tables 01 SQL_SIZING_PROFILES view YES

271

F502 Enhanced documentation tables 02 SQL_IMPLEMENTATION_INFO view YES

272

F502 Enhanced documentation tables 03 SQL_PACKAGES view YES

273

F521 Assertions NO

274

F531 Temporary tables YES

275

F555 Enhanced seconds precision YES

276

F561 Full value expressions YES

277

F571 Truth value tests YES

278

F591 Derived tables YES

279

F611 Indicator data types YES

280

F641 Row and table constructors NO

281

F651 Catalog name qualifiers YES

282

F661 Simple tables YES

283

F671 Subqueries in CHECK NO intentionally omitted

284

F672 Retrospective check constraints YES

285

F690 Collation support NO

286

F692 Enhanced collation support NO

287

F693 SQL-session and client module collations NO

288

F695 Translation support NO

289

F696 Additional translation documentation NO

290

F701 Referential update actions YES

291

F711 ALTER domain YES

292

F721 Deferrable constraints NO foreign keys only

293

F731 INSERT column privileges YES

294

F741 Referential MATCH types NO no partial match yet

295

F751 View CHECK enhancements NO

296

F761 Session management YES

297

F762 CURRENT_CATALOG YES

298

F763 CURRENT_SCHEMA YES

299

F771 Connection management YES

300

F781 Self-referencing operations YES

301

F791 Insensitive cursors YES

302

F801 Full set function YES

303

F812 Basic flagging NO

304

F813 Extended flagging NO

305

F821 Local table references NO

306

F831 Full cursor update NO

307

F831 Full cursor update 01 Updatable scrollable cursors NO

308

F831 Full cursor update 02 Updatable ordered cursors NO

309

F841 LIKE_REGEX predicate NO

310

F842 OCCURENCES_REGEX function NO

311

F843 POSITION_REGEX function NO

312

F844 SUBSTRING_REGEX function NO

313

F845 TRANSLATE_REGEX function NO

314

F846 Octet support in regular expression operators NO

315

F847 Nonconstant regular expressions NO

316

F850 Top-level <order by clause> in <query expression> YES

317

F851 <order by clause> in subqueries YES

318

F852 Top-level <order by clause> in views YES

319

F855 Nested <order by clause> in <query expression> YES

320

F856 Nested <fetch first clause> in <query expression> YES

321

F857 Top-level <fetch first clause> in <query expression> YES

322

F858 <fetch first clause> in subqueries YES

323

F859 Top-level <fetch first clause> in views YES

324

F860 <fetch first row count> in <fetch first clause> YES

325

F861 Top-level <result offset clause> in <query expression> YES

326

F862 <result offset clause> in subqueries YES

327

F863 Nested <result offset clause> in <query expression> YES

328

F864 Top-level <result offset clause> in views YES

329

F865 <offset row count> in <result offset clause> YES

330

S011 Distinct data types NO

331

S011 Distinct data types 01 USER_DEFINED_TYPES view NO

332

S023 Basic structured types NO

333

S024 Enhanced structured types NO

334

S025 Final structured types NO

335

S026 Self-referencing structured types NO

336

S027 Create method by specific method name NO

337

S028 Permutable UDT options list NO

338

S041 Basic reference types NO

339

S043 Enhanced reference types NO

340

S051 Create table of type NO

341

S071 SQL paths in function and type name resolution YES

342

S081 Subtables NO

343

S091 Basic array support NO partially supported

344

S091 Basic array support 01 Arrays of built-in data types NO

345

S091 Basic array support 02 Arrays of distinct types NO

346

S091 Basic array support 03 Array expressions NO

347

S092 Arrays of user-defined types YES

348

S094 Arrays of reference types NO

349

S095 Array constructors by query YES

350

S096 Optional array bounds YES

351

S097 Array element assignment NO

352

S098 ARRAY_AGG NO ORDER BY clause not supported

353

S111 ONLY in query expressions YES

354

S151 Type predicate NO

355

S161 Subtype treatment NO

356

S162 Subtype treatment for references NO

357

S201 SQL-invoked routines on arrays NO

358

S201 SQL-invoked routines on arrays 01 Array parameters NO

359

S201 SQL-invoked routines on arrays 02 Array as result type of functions NO

360

S202 SQL-invoked routines on multisets NO

361

S211 User-defined cast functions YES

362

S231 Structured type locators NO

363

S232 Array locators NO

364

S233 Multiset locators NO

365

S241 Transform functions NO

366

S242 Alter transform statement NO

367

S251 User-defined orderings NO

368

S261 Specific type method NO

369

S271 Basic multiset support NO

370

S272 Multisets of user-defined types NO

371

S274 Multisets of reference types NO

372

S275 Advanced multiset support NO

373

S281 Nested collection types NO

374

S291 Unique constraint on entire row NO

375

S301 Enhanced UNNEST NO

376

S401 Distinct types based on array types NO

377

S402 Distinct types based on distinct types NO

378

S403 MAX_CARDINALITY NO

379

S404 TRIM_ARRAY NO

380

T011 Timestamp in Information Schema NO

381

T021 BINARY and VARBINARY data types NO

382

T022 Advanced support for BINARY and VARBINARY data types NO

383

T023 Compound binary literal NO

384

T024 Spaces in binary literals NO

385

T031 BOOLEAN data type YES

386

T041 Basic LOB data type support NO

387

T041 Basic LOB data type support 01 BLOB data type NO

388

T041 Basic LOB data type support 02 CLOB data type NO

389

T041 Basic LOB data type support 03 POSITION, LENGTH, LOWER, TRIM, UPPER, and SUBSTRING functions for LOB data types NO

390

T041 Basic LOB data type support 04 Concatenation of LOB data types NO

391

T041 Basic LOB data type support 05 LOB locator: non-holdable NO

392

T042 Extended LOB data type support NO

393

T043 Multiplier T NO

394

T044 Multiplier P NO

395

T051 Row types NO

396

T052 MAX and MIN for row types NO

397

T053 Explicit aliases for all-fields reference NO

398

T061 UCS support NO

399

T071 BIGINT data type YES

400

T101 Enhanced nullability determiniation NO

401

T111 Updatable joins, unions, and columns NO

402

T121 WITH (excluding RECURSIVE) in query expression YES

403

T122 WITH (excluding RECURSIVE) in subquery YES

404

T131 Recursive query YES

405

T132 Recursive query in subquery YES

406

T141 SIMILAR predicate YES

407

T151 DISTINCT predicate YES

408

T152 DISTINCT predicate with negation YES

409

T171 LIKE clause in table definition YES

410

T172 AS subquery clause in table definition YES

411

T173 Extended LIKE clause in table definition YES

412

T174 Identity columns NO

413

T175 Generated columns NO

414

T176 Sequence generator support NO

415

T177 Sequence generator support: simple restart option NO

416

T178 Identity columns: simple restart option NO

417

T191 Referential action RESTRICT YES

418

T201 Comparable data types for referential constraints YES

419

T211 Basic trigger capability NO

420

T211 Basic trigger capability 01 Triggers activated on UPDATE, INSERT, or DELETE of one base table YES

421

T211 Basic trigger capability 02 BEFORE triggers YES

422

T211 Basic trigger capability 03 AFTER triggers YES

423

T211 Basic trigger capability 04 FOR EACH ROW triggers YES

424

T211 Basic trigger capability 05 Ability to specify a search condition that must be true before the trigger is invoked NO

425

T211 Basic trigger capability 06 Support for run-time rules for the interaction of triggers and constraints NO

426

T211 Basic trigger capability 07 TRIGGER privilege YES

427

T211 Basic trigger capability 08 Multiple triggers for the same event are executed in the order in which they were created in the catalog NO intentionally omitted

428

T212 Enhanced trigger capability YES

429

T213 INSTEAD OF triggers NO

430

T231 Sensitive cursors YES

431

T241 START TRANSACTION statement YES

432

T251 SET TRANSACTION statement: LOCAL option NO

433

T261 Chained transactions NO

434

T271 Savepoints YES

435

T272 Enhanced savepoint management NO

436

T281 SELECT privilege with column granularity YES

437

T285 Enhanced derived column names NO

438

T301 Functional dependencies NO

439

T312 OVERLAY function YES

440

T321 Basic SQL-invoked routines NO

441

T321 Basic SQL-invoked routines 01 User-defined functions with no overloading YES

442

T321 Basic SQL-invoked routines 02 User-defined stored procedures with no overloading NO

443

T321 Basic SQL-invoked routines 03 Function invocation YES

444

T321 Basic SQL-invoked routines 04 CALL statement NO

445

T321 Basic SQL-invoked routines 05 RETURN statement NO

446

T321 Basic SQL-invoked routines 06 ROUTINES view YES

447

T321 Basic SQL-invoked routines 07 PARAMETERS view YES

448

T322 Overloading of SQL-invoked functions and procedures YES

449

T323 Explicit security for external routines YES

450

T324 Explicit security for SQL routines NO

451

T325 Qualified SQL parameter references NO

452

T326 Table functions NO

453

T331 Basic roles NO

454

T332 Extended roles NO

455

T351 Bracketed SQL comments (/*...*/ comments) YES

456

T431 Extended grouping capabilities NO

457

T432 Nested and concatenated GROUPING SETS NO

458

T433 Multiargument GROUPING function NO

459

T434 GROUP BY DISTINCT NO

460

T441 ABS and MOD functions YES

461

T461 Symmetric BETWEEN predicate YES

462

T471 Result sets return value NO

463

T491 LATERAL derived table NO

464

T501 Enhanced EXISTS predicate YES

465

T511 Transaction counts NO

466

T541 Updatable table references NO

467

T551 Optional key words for default syntax YES

468

T561 Holdable locators NO

469

T571 Array-returning external SQL-invoked functions NO

470

T572 Multiset-returning external SQL-invoked functions NO

471

T581 Regular expression substring function YES

472

T591 UNIQUE constraints of possibly null columns YES

473

T601 Local cursor references NO

474

T611 Elementary OLAP operations NO

475

T612 Advanced OLAP operations NO

476

T613 Sampling NO

477

T614 NTILE function NO

478

T615 LEAD and LAG functions NO

479

T616 Null treatment option for LEAD and LAG functions NO

480

T617 FIRST_VALUE and LAST_VALUE function NO

481

T618 NTH_VALUE function NO

482

T621 Enhanced numeric functions YES

483

T631 IN predicate with one list element NO

484

T641 Multiple column assignment NO only some syntax variants supported

485

T651 SQL-schema statements in SQL routines NO

486

T652 SQL-dynamic statements in SQL routines NO

487

T653 SQL-schema statements in external routines NO

488

T654 SQL-dynamic statements in external routines NO

489

T655 Cyclically dependent routines NO

490

M001 Datalinks NO

491

M002 Datalinks via SQL/CLI NO

492

M003 Datalinks via Embedded SQL NO

493

M004 Foreign data support NO

494

M005 Foreign schema support NO

495

M006 GetSQLString routine NO

496

M007 TransmitRequest NO

497

M009 GetOpts and GetStatistics routines NO

498

M010 Foreign data wrapper support NO

499

M011 Datalinks via Ada NO

500

M012 Datalinks via C NO

501

M013 Datalinks via COBOL NO

502

M014 Datalinks via Fortran NO

503

M015 Datalinks via M NO

504

M016 Datalinks via Pascal NO

505

M017 Datalinks via PL/I NO

506

M018 Foreign data wrapper interface routines in Ada NO

507

M019 Foreign data wrapper interface routines in C NO

508

M020 Foreign data wrapper interface routines in COBOL NO

509

M021 Foreign data wrapper interface routines in Fortran NO

510

M022 Foreign data wrapper interface routines in MUMPS NO

511

M023 Foreign data wrapper interface routines in Pascal NO

512

M024 Foreign data wrapper interface routines in PL/I NO

513

M030 SQL-server foreign data support NO

514

M031 Foreign data wrapper general routines NO

515

X010 XML type YES

516

X011 Arrays of XML type YES

517

X012 Multisets of XML type NO

518

X013 Distinct types of XML type NO

519

X014 Attributes of XML type NO

520

X015 Fields of XML type NO

521

X016 Persistent XML values YES

522

X020 XMLConcat YES

523

X025 XMLCast NO

524

X030 XMLDocument NO

525

X031 XMLElement YES

526

X032 XMLForest YES

527

X034 XMLAgg YES

528

X035 XMLAgg: ORDER BY option NO

529

X036 XMLComment YES

530

X037 XMLPI YES

531

X038 XMLText NO

532

X040 Basic table mapping NO

533

X041 Basic table mapping: nulls absent YES

534

X042 Basic table mapping: null as nil YES

535

X043 Basic table mapping: table as forest YES

536

X044 Basic table mapping: table as element YES

537

X045 Basic table mapping: with target namespace YES

538

X046 Basic table mapping: data mapping YES

539

X047 Basic table mapping: metadata mapping YES

540

X048 Basic table mapping: base64 encoding of binary strings YES

541

X049 Basic table mapping: hex encoding of binary strings YES

542

X051 Advanced table mapping: nulls absent YES

543

X052 Advanced table mapping: null as nil YES

544

X053 Advanced table mapping: table as forest YES

545

X054 Advanced table mapping: table as element YES

546

X055 Advanced table mapping: target namespace YES

547

X056 Advanced table mapping: data mapping YES

548

X057 Advanced table mapping: metadata mapping YES

549

X058 Advanced table mapping: base64 encoding of binary strings YES

550

X059 Advanced table mapping: hex encoding of binary strings YES

551

X060 XMLParse: Character string input and CONTENT option YES

552

X061 XMLParse: Character string input and DOCUMENT option YES

553

X065 XMLParse: BLOB input and CONTENT option NO

554

X066 XMLParse: BLOB input and DOCUMENT option NO

555

X068 XMLSerialize: BOM NO

556

X069 XMLSerialize: INDENT NO

557

X070 XMLSerialize: Character string serialization and CONTENT option YES

558

X071 XMLSerialize: Character string serialization and DOCUMENT option YES

559

X072 XMLSerialize: Character string serialization YES

560

X073 XMLSerialize: BLOB serialization and CONTENT option NO

561

X074 XMLSerialize: BLOB serialization and DOCUMENT option NO

562

X075 XMLSerialize: BLOB serialization NO

563

X076 XMLSerialize: VERSION NO

564

X077 XMLSerialize: explicit ENCODING option NO

565

X078 XMLSerialize: explicit XML declaration NO

566

X080 Namespaces in XML publishing NO

567

X081 Query-level XML namespace declarations NO

568

X082 XML namespace declarations in DML NO

569

X083 XML namespace declarations in DDL NO

570

X084 XML namespace declarations in compound statements NO

571

X085 Predefined namespace prefixes NO

572

X086 XML namespace declarations in XMLTable NO

573

X090 XML document predicate YES

574

X091 XML content predicate NO

575

X096 XMLExists NO

576

X100 Host language support for XML: CONTENT option NO

577

X101 Host language support for XML: DOCUMENT option NO

578

X110 Host language support for XML: VARCHAR mapping NO

579

X111 Host language support for XML: CLOB mapping NO

580

X112 Host language support for XML: BLOB mapping NO

581

X113 Host language support for XML: STRIP WHITESPACE option NO

582

X114 Host language support for XML: PRESERVE WHITESPACE option NO

583

X120 XML parameters in SQL routines YES

584

X121 XML parameters in external routines YES

585

X131 Query-level XMLBINARY clause NO

586

X132 XMLBINARY clause in DML NO

587

X133 XMLBINARY clause in DDL NO

588

X134 XMLBINARY clause in compound statements NO

589

X135 XMLBINARY clause in subqueries NO

590

X141 IS VALID predicate: data-driven case NO

591

X142 IS VALID predicate: ACCORDING TO clause NO

592

X143 IS VALID predicate: ELEMENT clause NO

593

X144 IS VALID predicate: schema location NO

594

X145 IS VALID predicate outside check constraints NO

595

X151 IS VALID predicate with DOCUMENT option NO

596

X152 IS VALID predicate with CONTENT option NO

597

X153 IS VALID predicate with SEQUENCE option NO

598

X155 IS VALID predicate: NAMESPACE without ELEMENT clause NO

599

X157 IS VALID predicate: NO NAMESPACE with ELEMENT clause NO

600

X160 Basic Information Schema for registered XML Schemas NO

601

X161 Advanced Information Schema for registered XML Schemas NO

602

X170 XML null handling options NO

603

X171 NIL ON NO CONTENT option NO

604

X181 XML(DOCUMENT(UNTYPED)) type NO

605

X182 XML(DOCUMENT(ANY)) type NO

606

X190 XML(SEQUENCE) type NO

607

X191 XML(DOCUMENT(XMLSCHEMA)) type NO

608

X192 XML(CONTENT(XMLSCHEMA)) type NO

609

X200 XMLQuery NO

610

X201 XMLQuery: RETURNING CONTENT NO

611

X202 XMLQuery: RETURNING SEQUENCE NO

612

X203 XMLQuery: passing a context item NO

613

X204 XMLQuery: initializing an XQuery variable NO

614

X205 XMLQuery: EMPTY ON EMPTY option NO

615

X206 XMLQuery: NULL ON EMPTY option NO

616

X211 XML 1.1 support NO

617

X221 XML passing mechanism BY VALUE NO

618

X222 XML passing mechanism BY REF NO

619

X231 XML(CONTENT(UNTYPED)) type NO

620

X232 XML(CONTENT(ANY)) type NO

621

X241 RETURNING CONTENT in XML publishing NO

622

X242 RETURNING SEQUENCE in XML publishing NO

623

X251 Persistent XML values of XML(DOCUMENT(UNTYPED)) type NO

624

X252 Persistent XML values of XML(DOCUMENT(ANY)) type NO

625

X253 Persistent XML values of XML(CONTENT(UNTYPED)) type NO

626

X254 Persistent XML values of XML(CONTENT(ANY)) type NO

627

X255 Persistent XML values of XML(SEQUENCE) type NO

628

X256 Persistent XML values of XML(DOCUMENT(XMLSCHEMA)) type NO

629

X257 Persistent XML values of XML(CONTENT(XMLSCHEMA)) type NO

630

X260 XML type: ELEMENT clause NO

631

X261 XML type: NAMESPACE without ELEMENT clause NO

632

X263 XML type: NO NAMESPACE with ELEMENT clause NO

633

X264 XML type: schema location NO

634

X271 XMLValidate: data-driven case NO

635

X272 XMLValidate: ACCORDING TO clause NO

636

X273 XMLValidate: ELEMENT clause NO

637

X274 XMLValidate: schema location NO

638

X281 XMLValidate: with DOCUMENT option NO

639

X282 XMLValidate with CONTENT option NO

640

X283 XMLValidate with SEQUENCE option NO

641

X284 XMLValidate NAMESPACE without ELEMENT clause NO

642

X286 XMLValidate: NO NAMESPACE with ELEMENT clause NO

643

X300 XMLTable NO

644

X301 XMLTable: derived column list option NO

645

X302 XMLTable: ordinality column option NO

646

X303 XMLTable: column default option NO

647

X304 XMLTable: passing a context item NO

648

X305 XMLTable: initializing an XQuery variable NO

649

X400 Name and identifier mapping NO

Older »