This article describes the steps to take to create your own custom Siebel login. Through modifying Siebel Web Template (. Digitech Docking Station Sata Hdd Drivers here. swt) files. Siebel Spool File. Jun 21, 2016 How to generate the Spool File: Spool files are basically generating SQL Queries. What are Debugging Techniques in Siebel. Debugging Techniques in. Please add below commands in input.txt file and then run the command. Spool /siebel/IBMIHS7. Siebel Server Manager Commands. This will generate a list of.
Ok, so I got duped into doing some database design for an Oracle database where I work. The problem is, I'm not much of a DB guy:-). I'm currently using Rational Application Developer (RAD) to do the modeling of my database schema. What I'd ideally like to do is generate a series of Word documents, containing information from my DB schema (primarily table/column information, constraints, and triggers as tables in a Word doc). I can't seem to find any way to do this with RAD, so I was wondering if anyone knows of a tool that can take an SQL DDL script file (containing the CREATE commands for the schema), and generate Word-type reports? Any pointers greatly appreciated.
It's probably easiest just to run commands directly against the Oracle data dictionary tables themselves rather than trying to parse SQL files containing create statements. For example, to get all the tables in schema X, you can do: SELECT table_name FROM all_tables WHERE owner = 'X' To get all the columns for table 'T', owner 'U', you can do: SELECT column_name FROM all_tab_columns WHERE table_name = 'T' AND owner = 'U' Complete Example Here's a complete example that would allow you to get all the tables and their columns back for all tables owned by 'owner'. It can be done with a single SQL statement: SELECT t.table_name, c.column_name FROM all_tables t, all_tab_columns c WHERE t.TABLE_NAME = c.TABLE_NAME AND t.OWNER = c.OWNER AND t.OWNER = 'owner' ORDER BY t.TABLE_NAME, c.COLUMN_NAME As far as getting the data into Word documents, I'd just start with getting the data into text files first, then you can use other means to get it into Word if necessary. To get it into a text file, you can just run the above command in sql*plus, and just spool to a text file (i.e. Issue a spool file.txt command in sql*plus) before running the SQL statement. Then your output will be written to a file. @Steve - Are you aware that you can run your own instance of Oracle absolutely free?
It's called the Oracle Express Edition, and you can get it here: I highly recommend it, and it's great for doing the thing you are doing now, because you don't have to wait on DBA's to create your schema, you can do it on your sandbox DB. Plus, this allows you to make all the tweaks, etc. To your design and get it like you want it before bothering the DBA's. If you do that, you'll be able to use the solution above.
– Jul 21 '10 at 19:31 •.