I am Using Oracle 9i and I want to use continue statement or its equivalent in PL/SQL. So is there any keyword called "continue" in oracle 9i. If not, please let me know the solution for this.
We have a xml column in SQL Server 2008. We need to do reporting off the data in the xml so we're going to select the xml into a flat table. The flat table has columns that correspond to various nodes in the xml.
What is the best way to do this using SSIS?
Is this a good approach? Or should we just try and write the reports directly off the xml column?
I have laptop with an external e-sata/USB combo port. I have an internal Seagate SATA drive removed from another laptop. I want to recover the data in this disc. Is it possible to connec t this hardisk through the e-SATA port? If so, what cable would I need to connect in?
I'm working on a web based form builder that uses a mix of Jquery and PHP server side interaction. While the user is building the form I'm trying to determine the best method to store each of one of the form items before all the data is sent to the server. I've looked at the following methods
Javascript arrays
XML document
Send each form item to the server side to be stored in a session
We have a database setup that consists of two parts: a static structure, and dynamic additions. For each database, the dynamic can be different, and sometimes we don't have data for all the dynamic fields. Rigt now, we check for empties by looking at the total count of records in the entire table, but we want to move to a more refined method of checking for empties if possible. Is it possible to quickly check through several hundred fields and see which ones are empty and which ones are populated?
Thank you for taking the time to read my question. I'm trying to get a dialog box to open using Jquery mobile. I followed the documentation and used the data-rel="dialog" notation along with the data-transition="pop". Instead of a dialog appearing on the same page, I get a brand new page with the dialog appearing. Can someone kindly assist me on how to fix this functionality.
Here is my code for the initial main page:
<article>
<ul data-role="listview" data-split-icon="star" data-split-theme="d" data-inset="true">
<li><a href="#black_seed_desc" data-rel="dialog" ><img src="black_seed.jpg"/>
<h3>Black Seed Oil</h3>
</a>
<a href="#black_seed_purchase" data-rel="dialog" data-transition="pop">Purchase Black Seed Oil</a>
</li>
</ul>
</article>
Here is my code for the dialog page:
<div data-role="dialog" id="black_seed_purchase" data-theme="c">
<section data-role="content">
<h1>Purchase Black Seed Oil?</h1>
<p>By purchasing Black Seed Oil you will receive
an email receipt copy sent to you for your reference.</p>
<a href="#purchase_blackseed" data-inline="true" data-corners="true" data-rel="back" data-role="button" data-shadow="true" data-iconshadow="true"
data-wrapperrels="span">
<span>
<span>Buy: $49.99</span>
<span> </span>
</span>
</a>
<a href="#" data-role="button" data-rel="back" data-inline="true" data-corners="true"
data-wrapperrels="span" data-shadow="true" data-iconshawdow="true">
<span>
Cancel
</span>
</a>
</section>
</div>
Here is a working example. http://jsfiddle.net/Gajotres/w3ptm/?
Am about to do a homework, and i need to store quite a lot of information (Dictionary) in a data structure of my choice. I heard people in my classroom saying hash-tables are the way to go. How come?
I am facing this problem when I try to run OracleDBConsoleoracle in oracle 11
"Windows could not start the OracleDBConsoleoracle on Local Computer.For more information,
review the System Event Log.If this is a non-Microsoft service, contact the service vendor, and refer to
service-specific error code 2."
Noteice:I was online when I installed Oracle 11.
What's the problem?
Thanks...
Hi,
Ok so I have 2 list boxes one is connected to a database the other isnt.
I want to be able to send the selected item from the listbox connected to the database to the one that isnt.
Ive written this code
listBox2.Items.Add(listBox1.SelectedItem);
But instead of copyin the item i get "
System.Data.DataRowView
Anyone havin any advice?
I'm getting average prices by week on 7 million rows, it's taking around 30 seconds to get the job done.
This is the simple query:
SELECT AVG(price) as price, yearWEEK(FROM_UNIXTIME(timelog)) as week from pricehistory where timelog > $range and product_id = $id GROUP BY week
The only week that actually gets data changed and is worth averaging every time is always the last one, so this calculation for the whole period is a waste of resources. I just wanted to know if mysql has a tool to help out on this.
I think the question is clear enough. Some of the columns in my datawarehouse table could have a relationship to a primary key. But is it good practice? It is denormalized, so it should never be deleted again (data in datawarehouse). Hope question is somewhat clear enough.
Hi I need some sample MS SQL Employee database with data such as id, surname, name, age, adress etc. It must be quite big, I search with google, but I don't find any good sample.
Can any body help ?
None of the scribe examples I've seen actually mention the best way to take logs/logfiles and send them to scribe. I could configure a logrotate script that has a postrotate section that "cats" the rotated file to scribe (but then I get minutes latency at best).
The other option is to keep a "tail -f= | my_scribe_sender" and hope that the process never gets killed. However then you really can't guarantee that you're not missing/duplicating data.
Hi, is it possible to handle two data sources in the UIPickerView?
I have here a segmented control that would control the display of the picker view.
So, for example, when first segment is clicked, the picker will display person's name. Then, when second segment is clicked, picker will display place's name.
Thanks
I want to send the below data to default.ctp, I want to display menus in all the pages, I'm using Auth, The problem is if I'm logged in I get the Menus correctly, but if I logout, I'm getting error saying variable'$topMenu' not found.
The MenuController can be accessed only if logged in.
$this->loadModel('Menu');
$this->set('topMenu',$this->Menu->find('all'));
Any help on how to solve this?
I'm searching files and returning lines that include the search text, and I'm not really sure the best way to display the information I get. Every time I get a match, I want to show, in some sort of control, the File it came from, and the whole text line. (aka streamreader.ReadLine() result). First I tried just putting it all in a read-only text box, but it doesn't have a scroll bar.
What is the best form control to help me display this data neatly?
I have a three column Table View populated by two NSMutableDictionaries which share the same keys (ie key | value1 | value2 ) with dict1(key,value1) and dict2(key,value2).
I want to manually enter data in the third column and create the key/value objects in dict2. But when I do that, my code picks the wrong key :S
Here's the code for the delegate :
- (void)tableView:(NSTableView *)aTableView setObjectValue:(id)anObject forTableColumn:(NSTableColumn *)aTableColumn row:(NSInteger)rowIndex
{
if ([[aTableColumn identifier] isEqualToString:@"value2"])
{
[dict2 setValue:anObject forKey:[[[aTableView tableColumnWithIdentifier:@"key"] dataCellForRow:rowIndex] stringValue ]];
}
}
Any idea ?
how do i write a query that returns aggregate sales data for California in the past x months.
----------------------- -----------------------
| order | | customer |
|-----------------------| |-----------------------|
| orderId int | | customerId int |
| customerId int | | state varchar |
| deposit decimal | -----------------------
| orderDate date |
-----------------------
-----------------------
| orderItem |
|-----------------------|
| orderId int |
| itemId int |
| qty int |
| lineTotal decimal |
| itemPrice decimal |
-----------------------
Hi all,
I've a scenario where my java program has to continuously communicate with the database table, example my java program has to get the data of my table when new rows are added to it at runtime. There should be continuous communication between my program and database.
if the table has 10 rows initially and 2 rows are added by the user, it must detect this and return the rows.
My program shouldn't use AJAX and timers.
Please Help.
The Core Data Programming Guide talks a lot about what not to overwrite. So the question is: What is good to overwrite?
Like I see it, I can't overwrite -init or -initWithEntity:insertIntoManagedObjectContext:
So where else would be a good overwrite point to set up some basic stuff? Or is it generally not needed to do custom initialization? Does the whole thing rely only on accessing properties which then start to do fancy things? So no custom initializations?
I recently read that using flexible array members in C was poor software engineering practice. However, that statement was not backed by any argument. Is this an accepted fact?
(Flexible array members are a C feature introduced in C99 whereby one can declare the last element to be an array of unspecified size. For example: )
struct header {
size_t len;
unsigned char data[];
};