this is for file transfer between databases, spreadsheets, platforms, etc NOTE: TOAD & Discoverer also have this feature filename: xxx.sql set heading off set linesize 100 set pagesize 0 set feedback off spool c:\test.txt select jobno ||'","',nyctpm ||'","', descr || '","' from jobxref; spool off - - - - - - - - - - output - - - - - - - - - outfile: test.

AAD allows you to retrieve your search results in a comma-separated format. Comma separated files are sometimes known as comma delimited, comma separated value, or CSV files. This simply means that a comma separates the individual pieces of data so other programs can import the database and correctly handle it. Nearly every application designed to handle data, such as most spreadsheet and database applications, can import and display comma-separated files. See similar questions...

EMS SQL Manager for Oracle is a powerful graphical tool for Oracle administration and development. It makes creating and editing Oracle database objects easy and fast, and allows you to run SQL scripts, manage users and their privileges, build SQL queries visually, extract, print metadata, export data to 14 available formats and import them from most popular formats, view and edit BLOB fields, and much more. See similar questions...

I am trying to use an SQL database which uses trusted (or mixed) security. The Test button works but it doesn't let me in. however I am getting 31, ODBC error with statement, error number is: 3704 The operation requested by the application is not allowed if the object is closed. I've moved on from the Standard and Custom ODBC Select statement and I am in the process of setting up with the "Advanced" ODBC string. Tell me more about this. See similar questions...

A collection of 22 FAQs on PL/SQL language basics or DBA and developers. It can also be used as learning tutorials on defining variables, assigning values, using "loop" statements, setting "if" conditions, and working with null values. See similar questions...

The Oracle Migration technology web site provides tools and documentation on moving your database to Oracle. See similar questions...

The sim.tcl and 'ns' must be in the same directory. Running command: ns sim.tcl will produce a trace.out file if the sim.tcl is stored in the same directory as 'ns' program. See similar questions...

Michael Roussin, Director of the Kombucha Consumer Research Group ™ says ". . . the colony brings to the ferment everything it needs to reproduce itself. And fermenting without a colony will breed out some of the symbiotes, and it will also breed in new ones." ". . .I strongly recommend that you introduce a colony to each new ferment you start. It has all of the information necessary to replicate itself, and while some of that information is not necessary, much of it is. See similar questions...

Oracle data file is a big unit of physical storage in the OS file system. One or many Oracle data files are organized together to provide physical storage to a single Oracle tablespace. See similar questions...

In Excel, make sure your columns have data in the correct order (press F1 for Help while in the Import screen and it will tell you the correct order) or click (or right-click) here to get a sample Excel file as a template (erase the header and sample rows after adding your data). Leave any columns blank where no data exists (look at the Alumni Information Screen using the Demo Reunion to match up the Excel Columns with the fields on the screen). See similar questions...

In 2005, there were 18.2 trillion cubic feet (Tcf) of dry natural gas produced in the U.S. The top producing states are: See similar questions...

ColdFusion lists are not CSV comma-delimited lists and do not behave as CSV lists do. ColdFusion ignores empty list elements, so ListLen("a,b,,d,e") will return 4 (not 5), and ListGetAt("a,b,,d,e", 5) will throw an error. To convert a ColdFusion list to a CSV list, use Replace() and replace all ",," (comma comma) with ", ," (comma space comma) - a space is a valid list member value and ColdFusion will not ignore it. See similar questions...

We can link any server provided we have the OLE-DB provider from Microsoft to allow a link. For Oracle we have a OLE-DB provider for oracle that microsoft provides to add it as a linked server to the sql server group. See similar questions...

No, Wintility does not require that you purchase a separate database. Wintility installs on your network and creates references to the documents located anywhere in the LAN. See similar questions...

Rach) We use MySQL, others use PostgreSQL and it has been run up on Oracle and I think even MS-SQL. If you have a corporate policy supporting a particular database then we are likely to be able to accomodate it (/Rach) See similar questions...

As of VB ELF 2.0, we now support SQL Server 7.0 T-SQL as well as Oracle's PL/SQL dialect. Every feature available in the earlier Jet-only version of the software has been extended to these new dialects -- whether or not they are natively supported by the language. In other words, you can ask pivot table questions, like: "Show the average order subtotal, giving the customer down and month of order date across during 1999." -- VB ELF will create SQL for either SQL Server 7. See similar questions...

These editions of SQL Manager for Oracle differ in price and features. To register EMS SQL Manager for Oracle see our Purchase Page, and to learn about the difference in features please go to our Feature Matrix Page. See similar questions...

First of all you must have an opportunity to connect to some local or remote Oracle server to work with EMS SQL Manager for Oracle. Besides, you need your computer to satisfy the system requirements of SQL Manager for Oracle. EMS SQL Manager for Oracle runs on Windows NT4/2000/XP and Pentium II 300, 64 Mb RAM or above is recommended. See similar questions...

We would like to learn what you came here to find out. We plan on answering your top questions. If you include your contact information below when you answer, we will add you to our list so we can let you know when your questions have been answered! This is entirely free of charge. See similar questions...