Posts

Showing posts from June, 2023

SQL

I have put in my best efforts to ensure the task's completion meets the expected standards and aligns with the desired outcomes. I have also attached any relevant documents, reports, or deliverables associated with the task for your convenience. Should you require any further information or clarification regarding the completed task, please do not hesitate to reach out to me. I am available to discuss any aspects in more detail or provide additional support as needed. Thank you for entrusting me with this task. I look forward to your feedback and guidance on the next steps or any revisions required. SELECT (SELECT COUNT(*) FROM USER_TABLES) AS table_count, (SELECT COUNT(*) FROM USER_VIEWS) AS view_count, (SELECT COUNT(*) FROM USER_INDEXES) AS index_count FROM DUAL; SELECT      (SELECT COUNT(*) FROM USER_TABLES) AS table_count,     (SELECT COUNT(*) FROM USER_VIEWS) AS view_count,     (SELECT COUNT(*) FROM USER_INDEXES) AS index_count,     (SELECT COUNT(*) FROM USER_TABL

Code a simple html page with filter applied on table

  <!DOCTYPE html> <html> <head>     <title>Table Filter Example</title>     <style>         table {             border-collapse: collapse;             width: 100%;         }         th, td {             border: 1px solid black;             padding: 8px;             text-align: left;         }     </style> </head> <body>     <input type="text" id="filterInput" placeholder="Filter">     <br><br>     <table id="myTable">         <tr>             <th>Name</th>             <th>Age</th>             <th>City</th>         </tr>         <tr>             <td>John Doe</td>             <td>25</td>             <td>New York</td>         </tr>         <tr>             <td>Jane Smith</td>             <td>30</td>             <td>London</td>         &l

VDB template for Delphix

 --- version: 1 type: OracleVDB timeflowPointParameters:   type: OracleTimeflowPointSemantic   container: <SOURCE_CONTAINER_NAME> parameters:   dSource:     type: OracleDataNode     container: <SOURCE_CONTAINER_NAME>     config:       type: OracleSIConfig       logsyncEnabled: true       stageEnabled: false       recoveryModel: ARCHIVELOG       controlFileAutoBackup: false       openResetLogs: false       backupRedundancy: 1       rmanChannels: 4       rmanParallelism: 4       onlineRedoLogGroups: 8       onlineRedoLogSize: 100M       memoryTarget: 6G       sgaTarget: 2G       pgaAggregationTarget: 2G       sharedPoolSize: 512M       largePoolSize: 256M       javaPoolSize: 256M       streamsPoolSize: 0M       dbWriterProcesses: 4       logBuffer: 10M       dbFiles: 128       dbFileMultiblockReadCount: 16       maxSharedServers: 8       parallelMaxServers: 4       undoManagement: AUTO       undoTablespace: UNDOTBS1       undoRetention: 14400       sessions: 200       process