asif4db.blogspot.com
Database Development Learning and Sharing: Data loading in Oracle
http://asif4db.blogspot.com/2006/03/data-loading-in-oracle.html
Database Development Learning and Sharing. Tuesday, March 14, 2006. Data loading in Oracle. By using INSERT command. This technique has three different cases,. Most basic and easiest option). Single Row Insert without Indexes update. This option can give you batter performance, but with large amount of existing data it is not a good option). Bulk Inserts without Indexes update. This will increase the complexity of loading program). By using External table in Oracle 9i. Posted by CFMX blogging @ 6:20 AM.
asif4db.blogspot.com
Database Development Learning and Sharing: February 2006
http://asif4db.blogspot.com/2006_02_01_archive.html
Database Development Learning and Sharing. Friday, February 10, 2006. UNION of Queries result. Idea is to combine two queries such a way that their result are stack on each other. Examples usually explain anything better, so here an example,. SELECT productname, category. SELECT '- -CATEGORIES LIST- - ', NULL. SELECT category, null. Posted by CFMX blogging @ 3:56 PM. Cary, North Carolina, United States. View my complete profile.
asif4db.blogspot.com
Database Development Learning and Sharing: Sorting query on basis of substring
http://asif4db.blogspot.com/2006/01/sorting-query-on-basis-of-substring.html
Database Development Learning and Sharing. Tuesday, January 31, 2006. Sorting query on basis of substring. Let see how can we sort query results by specifying a part of string. Here is a exmple,. ORDER BY substr(productname, 1, 3). Posted by CFMX blogging @ 8:57 PM. Comments: Post a Comment. Cary, North Carolina, United States. View my complete profile.
asif4db.blogspot.com
Database Development Learning and Sharing: Free MS SQL server tool - SQL Prompt
http://asif4db.blogspot.com/2006/06/free-ms-sql-server-tool-sql-prompt.html
Database Development Learning and Sharing. Tuesday, June 06, 2006. Free MS SQL server tool - SQL Prompt. WOW, nice tool and on top of that it is free. :-) I have used couple of other tools who does provide IntelliSense/codeguide for writing SQL statements, but this one is batter because of its small size. You can get SQL prompt software. From red gate site. Posted by CFMX blogging @ 9:14 AM. Hi , yesterday I visited refinance mortgage loan. Maybe you will found some good the artilce site. See you again,.
asif4db.blogspot.com
Database Development Learning and Sharing: Again sorting - this time conditional sorting
http://asif4db.blogspot.com/2006/01/again-sorting-this-time-conditional.html
Database Development Learning and Sharing. Tuesday, January 31, 2006. Again sorting - this time conditional sorting. There is another discovery I found recently that we can specify CASE expression in ORDER BY clause. It means that our sorting order can be dynamically change on bases of some values. Example will clear this more so here is an example,. SELECT productname, category, price. ORDER BY CASE WHEN category = 'science' THEN price ELSE productname END. Posted by CFMX blogging @ 8:59 PM.
asif4db.blogspot.com
Database Development Learning and Sharing: UNION of Queries result
http://asif4db.blogspot.com/2006/02/union-of-queries-result.html
Database Development Learning and Sharing. Friday, February 10, 2006. UNION of Queries result. Idea is to combine two queries such a way that their result are stack on each other. Examples usually explain anything better, so here an example,. SELECT productname, category. SELECT '- -CATEGORIES LIST- - ', NULL. SELECT category, null. Posted by CFMX blogging @ 3:56 PM. Comments: Post a Comment. Cary, North Carolina, United States. View my complete profile.
asif4db.blogspot.com
Database Development Learning and Sharing: May 2006
http://asif4db.blogspot.com/2006_05_01_archive.html
Database Development Learning and Sharing. Tuesday, May 16, 2006. Finding number of rows in schema table with TOAD. I have just start using TOAD Professional (yes finally I am bless by my company to buy this tool :-). It is amazing how much it offers to help not only DBAs but also normal developer. For example I just imported data from one Oracle server to another Oracle server. I was thinking to create. Select count(*) from tablename. Nicely TOAD allow me to do this through menu option.
asif4db.blogspot.com
Database Development Learning and Sharing: Inline views
http://asif4db.blogspot.com/2006/01/inline-views.html
Database Development Learning and Sharing. Tuesday, January 31, 2006. This is a very powerful way to compose queries. It acts like a table on which you can apply any other operations and specify further filtering. Here is a example,. SELECT price, productname. Posted by CFMX blogging @ 7:27 PM. Comments: Post a Comment. Cary, North Carolina, United States. View my complete profile.
asif4db.blogspot.com
Database Development Learning and Sharing: January 2006
http://asif4db.blogspot.com/2006_01_01_archive.html
Database Development Learning and Sharing. Tuesday, January 31, 2006. Again sorting - this time conditional sorting. There is another discovery I found recently that we can specify CASE expression in ORDER BY clause. It means that our sorting order can be dynamically change on bases of some values. Example will clear this more so here is an example,. SELECT productname, category, price. ORDER BY CASE WHEN category = 'science' THEN price ELSE productname END. Posted by CFMX blogging @ 8:59 PM. That return...
asif4db.blogspot.com
Database Development Learning and Sharing: Getting random number of rows from a table
http://asif4db.blogspot.com/2006/01/getting-random-number-of-rows-from.html
Database Development Learning and Sharing. Tuesday, January 31, 2006. Getting random number of rows from a table. I was trying to find a way to get random rows from an Oracle table. Here is my solution,. SELECT questionid, questiontext. ORDER BY dbms random.value(). This query will first randomly sort rows from test table then it returns first 10 rows from the query. Isn't simple? Posted by CFMX blogging @ 8:34 PM. Comments: Post a Comment. Cary, North Carolina, United States. View my complete profile.