{
"printConfig":{
"units":"INCHES"
,"paperSize":"LETTER"
,"width":8.5
,"height":11
,"orientation":"VERTICAL"
,"pageHeader":"IRR"
,"pageHeaderFontColor":"#000000"
,"pageHeaderFontFamily":"Helvetica"
,"pageHeaderFontWeight":"normal"
,"pageHeaderFontSize":"12"
,"pageHeaderAlignment":"CENTER"
,"pageFooterFontColor":"#000000"
,"pageFooterFontFamily":"Helvetica"
,"pageFooterFontWeight":"normal"
,"pageFooterFontSize":"12"
,"headerBgColor":"#EEEEEE"
,"headerFontColor":"#000000"
,"headerFontFamily":"Helvetica"
,"headerFontWeight":"bold"
,"headerFontSize":"10"
,"bodyBgColor":"#FFFFFF"
,"bodyFontColor":"#000000"
,"bodyFontFamily":"Helvetica"
,"bodyFontWeight":"normal"
,"bodyFontSize":"10"
,"borderWidth":0.5
,"borderColor":"#666666"
}
,"timeZone":"+00:00"
,"nls":{
"nlsTerritory":"AMERICA"
,"nlsLanguage":"AMERICAN"
,"nlsDateFormat":"DS"
,"nlsTimestampFormat":"DS"
,"nlsTimestampTZFormat":"DS"
,"nlsNumericCharacters":".,"
}
,"columns":[
{
"name":"ename"
,"heading":"Employee Name"
,"label":"Employee Name"
,"oraDataType":"VARCHAR2"
,"xlsxFormatMask":"General"
,"headingAlignment":"LEFT"
,"valueAlignment":"LEFT"
,"type":"plain"
,"escape":true
}
,{
"name":"job"
,"heading":"Job"
,"label":"Job"
,"oraDataType":"VARCHAR2"
,"xlsxFormatMask":"General"
,"headingAlignment":"LEFT"
,"valueAlignment":"LEFT"
,"type":"plain"
,"escape":true
}
,{
"name":"mgr"
,"heading":"Manager"
,"label":"Manager"
,"oraDataType":"VARCHAR2"
,"xlsxFormatMask":"General"
,"headingAlignment":"LEFT"
,"valueAlignment":"LEFT"
,"type":"plain"
,"escape":true
}
,{
"name":"hiredate"
,"heading":"Hired"
,"label":"Hired"
,"oraDataType":"DATE"
,"oraFormatMask":"DS"
,"xlsxFormatMask":"[$-409]mm\/dd\/yyyy"
,"headingAlignment":"LEFT"
,"valueAlignment":"LEFT"
,"type":"plain"
,"escape":true
}
,{
"name":"sal"
,"heading":"Salary"
,"label":"Salary"
,"oraDataType":"NUMBER"
,"xlsxFormatMask":"General"
,"headingAlignment":"RIGHT"
,"valueAlignment":"RIGHT"
,"type":"plain"
,"escape":true
}
,{
"name":"comm"
,"heading":"Commission"
,"label":"Commission"
,"oraDataType":"NUMBER"
,"xlsxFormatMask":"General"
,"headingAlignment":"RIGHT"
,"valueAlignment":"RIGHT"
,"type":"plain"
,"escape":true
}
,{
"name":"deptno"
,"heading":"Department"
,"label":"Department"
,"oraDataType":"VARCHAR2"
,"xlsxFormatMask":"General"
,"headingAlignment":"LEFT"
,"valueAlignment":"LEFT"
,"type":"plain"
,"escape":true
}
]
,"rowset":[
{
"ename":"DELMAR"
,"job":"CLERK"
,"mgr":"BROWN"
,"hiredate":"2024-07-30T00:00:00"
,"sal":850
,"comm":null
,"deptno":"OPERATIONS"
}
,{
"ename":"TWOHY"
,"job":"ENGINEER"
,"mgr":"BROWN"
,"hiredate":"2025-01-02T00:00:00"
,"sal":2000
,"comm":null
,"deptno":"OPERATIONS"
}
,{
"ename":"DUPREE"
,"job":"ENGINEER"
,"mgr":"BROWN"
,"hiredate":"2025-01-02T00:00:00"
,"sal":2000
,"comm":null
,"deptno":"OPERATIONS"
}
,{
"ename":"CLARK"
,"job":"MANAGER"
,"mgr":"KING"
,"hiredate":"1981-06-09T00:00:00"
,"sal":2450
,"comm":null
,"deptno":"ACCOUNTING"
}
,{
"ename":"JONES"
,"job":"MANAGER"
,"mgr":"KING"
,"hiredate":"1981-04-02T00:00:00"
,"sal":2975
,"comm":null
,"deptno":"RESEARCH"
}
,{
"ename":"BLAKE"
,"job":"MANAGER"
,"mgr":"KING"
,"hiredate":"1981-05-01T00:00:00"
,"sal":1875
,"comm":null
,"deptno":"SALES"
}
,{
"ename":"BROWN"
,"job":"MANAGER"
,"mgr":"KING"
,"hiredate":"2024-06-07T00:00:00"
,"sal":2200
,"comm":null
,"deptno":"OPERATIONS"
}
,{
"ename":"ALLEN"
,"job":"SALESMAN"
,"mgr":"BLAKE"
,"hiredate":"1981-02-20T00:00:00"
,"sal":1600
,"comm":300
,"deptno":"SALES"
}
,{
"ename":"WARD"
,"job":"SALESMAN"
,"mgr":"BLAKE"
,"hiredate":"1981-02-22T00:00:00"
,"sal":1250
,"comm":500
,"deptno":"SALES"
}
,{
"ename":"MARTIN"
,"job":"SALESMAN"
,"mgr":"BLAKE"
,"hiredate":"1981-09-28T00:00:00"
,"sal":1250
,"comm":1400
,"deptno":"SALES"
}
,{
"ename":"TURNER"
,"job":"SALESMAN"
,"mgr":"BLAKE"
,"hiredate":"1981-09-08T00:00:00"
,"sal":1500
,"comm":null
,"deptno":"SALES"
}
,{
"ename":"JAMES"
,"job":"CLERK"
,"mgr":"BLAKE"
,"hiredate":"1981-12-03T00:00:00"
,"sal":950
,"comm":null
,"deptno":"SALES"
}
,{
"ename":"MILLER"
,"job":"CLERK"
,"mgr":"CLARK"
,"hiredate":"1982-01-23T00:00:00"
,"sal":1300
,"comm":null
,"deptno":"ACCOUNTING"
}
,{
"ename":"SCOTT"
,"job":"ANALYST"
,"mgr":"JONES"
,"hiredate":"1982-12-09T00:00:00"
,"sal":3000
,"comm":null
,"deptno":"RESEARCH"
}
,{
"ename":"FORD"
,"job":"ANALYST"
,"mgr":"JONES"
,"hiredate":"1981-12-03T00:00:00"
,"sal":3000
,"comm":null
,"deptno":"RESEARCH"
}
,{
"ename":"ADAMS"
,"job":"CLERK"
,"mgr":"SCOTT"
,"hiredate":"1983-01-12T00:00:00"
,"sal":1100
,"comm":null
,"deptno":"RESEARCH"
}
,{
"ename":"SMITH"
,"job":"CLERK"
,"mgr":"FORD"
,"hiredate":"1980-12-17T00:00:00"
,"sal":800
,"comm":null
,"deptno":"RESEARCH"
}
,{
"ename":"KING"
,"job":"PRESIDENT"
,"mgr":null
,"hiredate":"1981-11-17T00:00:00"
,"sal":5000
,"comm":null
,"deptno":"ACCOUNTING"
}
]
}