<< < 56 57 58 59 60 61 62 63 64 65 66 > >>   Sort: Date

Can DDL Statements Be Used in PL/SQL
Can DDL Statements Be Used in PL/SQL? - Oracle DBA FAQ - Working with Database Objects in PL/SQL No, you can not run any DDL statements is PL/SQL directly. If you try to use the DROP TABLE statement inside PL/SQL, you will get a compilation error as shown below: (Connect to XE with SQL*Plus) BEGIN D...
2007-04-28, 5312👍, 0💬

What Is the Common Mistake When Setting Path and Domain on Temporary Cookies
What Is the Common Mistake When Setting Path and Domain on Temporary Cookies? - PHP Script Tips - Understanding and Managing Cookies A common mistake made by many PHP developers is using an empty string for the expiration time parameter when setting path and domain for temporary cookies. The PHP scr...
2007-04-24, 5312👍, 0💬

How To Read Data from Keyborad (Standard Input)
How To Read Data from Keyborad (Standard Input)? - PHP Script Tips - Reading and Writing Files If you want to read data from the standard input, usually the keyboard, you can use the fopen("php://stdin") function. It creates a special file handle linking to the standard input, and returns the file h...
2007-04-23, 5312👍, 0💬

How Many Ways to Attach CSS to HTML Documents
How Many Ways to Attach CSS to HTML Documents? - CSS Tutorials - Introduction To CSS Basics There are 3 ways to attach CSS to HTML documents: Included in the STYLE attribute of HTML tags. Included in the STYLE tag inside the HEAD tag. Included in an external file and specify it in the LINK tag insid...
2007-05-11, 5311👍, 0💬

Why is the culture set to the current thread
Why is the culture set to the current thread? First let me explain this question. If you look at the code snippet of how to set the culture info. Thread.CurrentThread.CurrentCu lture= new CultureInfo(strCulture); It uses the current thread to set it. What does that mean? Let’s drill down a bit of ho...
2007-11-02, 5310👍, 0💬

What is the difference between Server.Transfer and response.Redirect
What is the difference between Server.Transfer and response.Redirect ? Following are the major differences between them:- ? Response.Redirect sends message to the browser saying it to move to some different page, while server.transfer does not send any message to the browser but rather redirects the...
2007-10-24, 5308👍, 0💬

What is equivalent for regsvr32 exe in .NET
What is equivalent for regsvr32 exe in .NET ? Regasm
2007-10-22, 5307👍, 0💬

How To Use "password" Input Fields
How To Use "password" Input Fields? - XHTML 1.0 Tutorials - Understanding Forms and Input Fields A "password" input field is defined as &lt;input type="password" .../&gt;. A "password" input field can be used to create an input field to allow viewers to enter text strings or numbers without ...
2007-05-12, 5307👍, 0💬

What Is the Implicit Cursor
What Is the Implicit Cursor? - Oracle DBA FAQ - Working with Database Objects in PL/SQL The implicit cursor is the cursor automatically defined by PL/SQL for you. Whenever a SQL statement is executed, this cursor will be assigned to represent the execution of this statement. This implicit cursor is ...
2007-04-27, 5306👍, 0💬

What is difference between Rename and Alias?
What is difference between Rename and Alias? Rename is actually changing the name of an object whereas Alias is giving another name (additional name) to an existing object. Rename is a permanent name given to a table or column whereas Alias is a temporary name given to a table or column which do not...
2011-12-22, 5305👍, 0💬

What is scavenging ?
.NET INTERVIEW QUESTIONS - What is scavenging ? When server running your ASP.NET application runs low on memory resources, items are removed from cache depending on cache item priority. Cache item priority is set when you add item to cache. By setting the cache item priority controls the items scave...
2009-05-12, 5305👍, 0💬

Can You Select Someone Else Database
Can You Select Someone Else Database? - MySQL FAQs - PHP Connections and Query Execution If your MySQL server is provided by an Internet service company, they will provide you one database for your use only. There are many other databases on the server for other users. But your user account will hav...
2007-05-10, 5305👍, 0💬

How To Get Execution Statistics Reports on Query Statements
How To Get Execution Statistics Reports on Query Statements? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool If your user account has autotrace configured by the DBA, you can use the "SET AUTOTRACE ON STATISTICS" command to turn on execution statistics reports on query statement...
2007-04-30, 5305👍, 0💬

What Is JSP Page
What is JSP page? A JSP page is a text-based document that contains two types of text: static template data, which can be expressed in any text-based format such as HTML, SVG, WML, and XML, and JSP elements, which construct dynamic content.
2007-04-03, 5305👍, 0💬

What is the use of CommandBuilder
What is the use of CommandBuilder ? CommandBuilder builds “Parameter” objects automatically. Below is a simple code which uses commandbuilder to load its parameter objects. Dim pobjCommandBuilder As New OleDbCommandBuilder(pobjDataAd apter)pobjCommandBuilder.DeriveParam eters(pobjCommand)Be careful ...
2007-10-24, 5304👍, 0💬

How To Do a Full Database Export
How To Do a Full Database Export? - Oracle DBA FAQ - Loading and Exporting Data If you are ready to do a full database export, you can use the FULL=y parameter on the expdp command, as shown in the following tutorial exercise: >expdp SYSTEM/fyicenter FULL=y ESTIMATE_ONLY=y Starting "SYSTEM"."SYS_EXP...
2007-05-01, 5304👍, 0💬

How To Take a Substring from a Given String
How To Take a Substring from a Given String? - PHP Script Tips - PHP Built-in Functions for Strings If you know the position of a substring in a given string, you can take the substring out by the substr() function. Here is a PHP script on how to use substr(): &lt;?php $string = "beginning"; pri...
2007-04-21, 5303👍, 0💬

How To Define and Use Table Alias Names
How To Define and Use Table Alias Names? - MySQL FAQs - SQL SELECT Statements with JOIN and Subqueries When column names need to be prefixed with table names, you can define table alias name and use them to prefix column names as shown in the following select statement: mysql> SELECT l.id, l.url, r....
2007-05-11, 5302👍, 0💬

How To Specify Default Values in INSERT Statement
How To Specify Default Values in INSERT Statement? - Oracle DBA FAQ - Understanding SQL DML Statements If a column is defined with a default value in a table, you can use the key word DEFAULT in the INSERT statement to take the default value for that column. The following tutorial exercise gives a g...
2007-04-21, 5302👍, 0💬

What Are the Differences between BINARY and VARBINARY
What Are the Differences between BINARY and VARBINARY? - MySQL FAQs - Introduction to SQL Basics Both BINARY and VARBINARY are both binary byte data types. But they have the following major differences: BINARY stores values in fixed lengths. Values are padded with 0x00. VARBINARY stores values in va...
2007-05-11, 5301👍, 0💬

How To Define a Procedure inside Another Procedure
How To Define a Procedure inside Another Procedure? - Oracle DBA FAQ - Introduction to PL/SQL Define a procedure inside another procedure is supported by PL/SQL. The following tutorial script shows you an example: SQL> CREATE OR REPLACE PROCEDURE HR.DBA_WEEK AS 2 PROCEDURE DBA_TASK (day VARCHAR2) AS...
2007-04-26, 5300👍, 0💬

What are LeaseTime, SponsorshipTime, RenewonCallTime and
What are LeaseTime, SponsorshipTime, RenewonCallTime and LeaseManagerPollTime? This is a very important question from practical implementation point of view. Companies who have specific requirement for Remoting projects will expect this question to be answered. In normal .NET environment objects lif...
2007-10-23, 5299👍, 0💬

What is WCF part 2
What is WCF part 2 So he concluded to use MSMQ (Microsoft Message Queuing) service. He analyzed that the main problem was that the travel agent had to wait until his first ticket booking is not completed. So when the travel agent makes a booking it will come and fall in the queue and release the tra...
2007-11-03, 5298👍, 0💬

How To Generate a Feed subtitle Element
How To Generate a Feed subtitle Element? - RSS FAQs - Atom Feed File Structure and Elements The &lt;subtitle&gt; element is not a required sub-element of the &lt;feed&gt; element. But it is strongly recommended that you provide a subtitle element for each of your feed documents. You ...
2007-05-12, 5298👍, 0💬

<< < 56 57 58 59 60 61 62 63 64 65 66 > >>   Sort: Date