CodeProject - For those who code
- The Lounge 17WSO CCC OTD 2015-07-22 - The Lounge more procrastination Straw Poll Do you enjoy Software Development?We tend to think of ourselves as passionate about our art. - The Lounge 3Thought of the day - The Lounge 7Your super-human DNA may be worth a pile ? - The Insider News 40I am afraid about programmers future - The Lounge 7Ahhhh..
The locally managed tempfile is a new feature in Oracle8i to avoid recursive space management operations, which can occur in dictionary managed tablespaces. How to split Export or standard output into smaller pieces ? If you want to export the whole oracle database, or create a TAR archive of one of your filesystem, you may reach a filesize which is bigger than 2 GB
reply thatjeffsmith posted 1 year ago Yes, leave the Excel file alone, but setup DEFAULT values or BEFORE INSERT triggers on your table to get the static fields populated as the Excel file loads. Also, pls guide how to use the SQL Loader ? Many thanks, Nilam reply thatjeffsmith posted 2 years ago Get it into a SQL*Loader friendly format, like CSV
Outer Capture An outer capture occurs when a name in an inner scope, which once resolved to an entity in an inner scope, is resolved to an entity in an outer scope. Avoiding Inner Capture in DML Statements You can avoid inner capture in DML statements by following these rules: Specify an alias for each table in the DML statement
Because associative arrays are intended for temporary data rather than storing persistent data, you cannot use them with SQL statements such as INSERT and SELECT INTO. When the remote database performs operations such as FIRST and NEXT, it uses its own character order even if that is different from the order where the collection originated
How to use Cursor in Sql - CodeProject
In other word, Cursor is a database object used by applications to manipulate data in a set on a row-by-row basis, it's like recordset in ASP and Visual Basic
I prefer to use the system for this and simply get a count because you can assign the column count to a variable at the top of a query and then choose to proceed or not based on that. The trick is not to use the table alias for such columns (which is a frowned-upon practice in most situations, but in this case omitting the table alias helps you to resolve the issue)
If you have file1.sql alter table t1 add col1 date; alter table t1 add col2 date; alter table t1 add col3 date; And col2 is present,when the script is run, the other two columns would be added to the table and the log would show the error saying "col2" already exists, so you should be ok
No comments:
Post a Comment