## Syntax ```mermaid %%{init: { 'theme': 'base', 'flowchart': { 'padding': '7', 'nodeSpacing': '20', 'rankSpacing': '20' }, 'themeVariables': { 'fontSize': '11px', 'fontFamily': 'Arial' } }}%% flowchart LR stmt_start((START)) stmt_start --> stmt_0_0[RESULT_SET_NAME] stmt_0_0 --> stmt_0_1["("]:::quoted stmt_0_1 --> stmt_0_2[stringConstant] stmt_0_2 --> stmt_0_3[")"]:::quoted stmt_0_3 --> stmt_end((END)) ``` ## Purpose The `result_set_name`-hint specifies a string to be used as name of the result set during further processing. A query returns a result set. A result set has associated metadata, such as statistics, audit information and SQL execution steps used to retrieve the data. It is for instance included as an attribute in the XML or JSON output for a SQL batch, such as with Invantive Data Access Point. ## Examples The result set name is forced to equal `hello`: ```sql select /*+ result_set_name('hello') */ * from dual@datadictionary ```