One can issue the SQL*Plus command SET TIMING ON to get wall-clock times, but one can’t take, for example, fetch time out of that trivially. The AUTOTRACE setting, when used as SET AUTOTRACE TRACEONLY will suppress output, but still perform all of the work to satisfy the query and send the results back to SQL*Plus, … Read more
The first two answers seem to miss the topic, unless it is me not understanding the question. My understanding, a feature I searched myself, is that you want to skip a number of lines (when stepping in code) and set the program counter (to take assembly vocabulary) to the given line. It might be interesting … Read more
This is an interesting topic to me! I want to do some observations about it. The important point first: A Batch file is a file with .BAT or .CMD extension. Period. Batch files can achieve, besides the execution of usual DOS commands, certain specific Batch-file facilities, in particular: Access to Batch file parameters via %1 … Read more
First of all, passing a function as a parameter is telling the function that you’re calling that you would like it to call this function some time in the future. When exactly in the future it will get called depends upon the nature of what the function is doing. If the function is doing some … Read more
This should not be taken too seriously, but I managed to get this exception while having some fun with reflection: typeof(IntPtr).GetField(“Zero”).SetValue(null, new IntPtr(666));
What you have there is the Polling pattern. In this pattern you continually ask “Are we there yet?” The while loop is doing the blocking. The Thread.Sleep prevents the process from eating up CPU cycles. Wait for Completion is the “I’ll call you” approach. IAsyncResult ar = data.BeginInvoke(null, null); //wait until processing is done with … Read more
This is just at a very high and abstract level of course! Executable – No Shared Libary: Client request to run application ->Shell informs kernel to run binary ->Kernel allocates memory from the pool to fit the binary image into ->Kernel loads binary into memory ->Kernel jumps to specific memory address ->Kernel starts processing the … Read more
The actual execution of MySQL statements is a bit tricky. However, the standard does specify the order of interpretation of elements in the query. This is basically in the order that you specify, although I think HAVING and GROUP BY could come after SELECT: FROM clause WHERE clause SELECT clause GROUP BY clause HAVING clause … Read more