<< < 142 143 144 145 146 147 148 149 150 151 152 > >>   Sort: Rank

How Many Anonymous Blocks Can Be Defined
How Many Anonymous Blocks Can Be Defined? - Oracle DBA FAQ - Introduction to PL/SQL An anonymous block is stored in the user's current session without any name. So you can only define one anonymous block at any time. If you define another anonymous block, the new block will replace the previously de...
2007-04-25, 5054👍, 0💬

How To Run the Anonymous Block Again
How To Run the Anonymous Block Again? - Oracle DBA FAQ - Introduction to PL/SQL If you have an anonymous block defined in your session, you can run it any time by using the "/" command as shown in the following script: SQL> set serveroutput on; SQL> begin 2 dbms_output.put_line('This is a PL/SQL FAQ...
2007-04-25, 5362👍, 0💬

How To Use "IN" Parameter Properly
How To Use "IN" Parameter Properly? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions Here are the rules about IN parameters: A formal IN parameter acts like constant. It can not be assigned with new values. An actual IN parameter can take a value or a variable. An actual IN param...
2007-04-25, 5589👍, 0💬

What Are the Parameter Modes Supported by PL/SQL
What Are the Parameter Modes Supported by PL/SQL? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions PL/SQL supports 3 parameter modes on procedure/function parameters: IN: This is the default mode. IN parameters allow the calling code to pass values into the procedure or function....
2007-04-25, 7407👍, 0💬

How To Receive a Cookie from the Browser
How To Receive a Cookie from the Browser? - PHP Script Tips - Understanding and Managing Cookies If you know that a cookie has been sent to the browser when it was visiting the server previously, you can check the built-in $_COOKIE array, which contains all cookies that were sent by the server previ...
2007-04-25, 5038👍, 0💬

What Are the Types PL/SQL Code Blocks
What Are the Types PL/SQL Code Blocks? - Oracle DBA FAQ - Introduction to PL/SQL There are 3 types of PL/SQL code blocks: Anonymous Block - A block of codes with no name. It may contain a declaration part, an execution part, and exception handlers. Stored Program Unit - A block of codes with a name....
2007-04-25, 5021👍, 0💬

How To Send a Cookie to the Browser
How To Send a Cookie to the Browser? - PHP Script Tips - Understanding and Managing Cookies If you want to sent a cookie to the browser when it comes to request your PHP page, you can use the setcookie( ) function. Note that you should call setcookie() function before any output statements. The foll...
2007-04-25, 5098👍, 0💬

How To Define an Anonymous Block
How To Define an Anonymous Block? - Oracle DBA FAQ - Introduction to PL/SQL An anonymous block must have an execution part, which is a group of other PL/SQL statements enclosed in the BEGIN ... END statement. Here is a script on how to define a simple anonymous block with SQL*Plus: SQL> set serverou...
2007-04-25, 5740👍, 0💬

How To Test Cookies on a Web Server
How To Test Cookies on a Web Server? - PHP Script Tips - Understanding and Managing Cookies If you want to test cookies with a browser, you need to run a Web server locally, or have access to a Web server remotely. Then you can copy the following PHP cookie test page, setting_receiving_cookies.php, ...
2007-04-25, 4962👍, 0💬

What Is a Persistent Cookie
What Is a Persistent Cookie? - PHP Script Tips - Understanding and Managing Cookies A persistent cookie is a cookie which is stored in a cookie file permanently on the browser's computer. By default, cookies are created as temporary cookies which stored only in the browser's memory. When the browser...
2007-04-25, 5363👍, 0💬

What Is a Cookie
What Is a Cookie? - PHP Script Tips - Understanding and Managing Cookies A cookie is a small amount of information sent by a Web server to a web browser and then sent back unchanged by the browser each time it accesses that server. HTTP cookies are used for authenticating, tracking, and maintaining ...
2007-04-25, 5194👍, 0💬

How To Define a Function with Any Number of Arguments
How To Define a Function with Any Number of Arguments? - PHP Script Tips - Creating Your Own Functions If you want to define a function with any number of arguments, you need to: Declare the function with no argument. Call func_num_args() in the function to get the number of the arguments. Call func...
2007-04-25, 4845👍, 0💬

What Is PL/SQL
What Is PL/SQL? - Oracle DBA FAQ - Introduction to PL/SQL PL/SQL is a modern, block-structured programming language. It provides several features that make developing powerful database applications very convenient. For example, PL/SQL provides procedural constructs, such as loops and conditional sta...
2007-04-25, 5084👍, 0💬

How To Check the Server Version
How To Check the Server Version? - Oracle DBA FAQ - Introduction to Oracle Database 10g Express Edition Oracle server sersion information is stored in a table called: PRODUCT_COMPONENT_VERSION. You can use a simple SELECT statement to view the version information like this: >.\bin\sqlplus Enter user...
2007-04-25, 5331👍, 0💬

How To Set a Persistent Cookie
How To Set a Persistent Cookie? - PHP Script Tips - Understanding and Managing Cookies If you want to set a persistent cookie, you can use the setcookie() function with an extra parameter to specify its expiration time. To follow sample script sets 2 persistent cookies to be expired within 7 days: s...
2007-04-25, 5073👍, 0💬

How To Test Persistent Cookies
How To Test Persistent Cookies? - PHP Script Tips - Understanding and Managing Cookies If you want to test persistent cookies, you can copy the following PHP script, setting_persistent_cookies.php ,to your Web server: &lt;?php setcookie("LoginName","FYICent er");setcookie("PreferredColor","Bl ue"...
2007-04-25, 5174👍, 0💬

How To Specify Argument Default Values
How To Specify Argument Default Values? - PHP Script Tips - Creating Your Own Functions If you want to allow the caller to skip an argument when calling a function, you can define the argument with a default value when defining the function. Adding a default value to an argument can be done like thi...
2007-04-25, 5157👍, 0💬

What To Do If the Binary SPFile Is Wrong for the Default Instance
What To Do If the Binary SPFile Is Wrong for the Default Instance? - Oracle DBA FAQ - Introduction to Oracle Database 10g Express Edition Let's say the SPFile for the default instance is a binary file, and some settings are wrong in the SPFile, like SGA setting is bellow 20MB, how do you change a se...
2007-04-25, 5116👍, 0💬

Where Are the Settings Stored for Each Instance
Where Are the Settings Stored for Each Instance? - Oracle DBA FAQ - Introduction to Oracle Database 10g Express Edition Settings for each instance are stored in a file called Server Parameter File (SPFile). Oracle supports two types of parameter files, Text type, and Binary type. parameter files sho...
2007-04-25, 4881👍, 0💬

How To Access a Global Variable inside a Function
How To Access a Global Variable inside a Function? - PHP Script Tips - Creating Your Own Functions By default, global variables are not accessible inside a function. However, you can make them accessible by declare them as "global" inside a function. Here is a PHP script on declaring "global" variab...
2007-04-24, 5088👍, 0💬

How Values Are Returned from Functions
How Values Are Returned from Functions? - PHP Script Tips - Creating Your Own Functions If a value is returned from a function, it is returned by value, not by reference. That means that a copy of the value is return. Here is a PHP script on how values are returned from a function: &lt;?php $fav...
2007-04-24, 4927👍, 0💬

How To Remove a Cookie
How To Remove a Cookie? - PHP Script Tips - Understanding and Managing Cookies Once a cookie is sent from the server to the browser, there is no direct way for the server to ask the browser to remove the cookie. But you can use the setcookie() function to send the same cookie to browser with a negat...
2007-04-24, 5171👍, 0💬

What Are Domain and Path Attributes for Cookies
What Are Domain and Path Attributes for Cookies? - PHP Script Tips - Understanding and Managing Cookies Cookies can also be defined with two other attributes: Domain - A cookie attribute that defines the domain name of Web servers where this cookie is valid. Web browsers holding this cookie should n...
2007-04-24, 5645👍, 0💬

What Is SQL
What Is SQL? - Oracle DBA FAQ - Understanding SQL Basics SQL, SEQUEL (Structured English Query Language), is a language for RDBMS (Relational Database Management Systems). SQL was developed by IBM Corporation.
2007-04-24, 5085👍, 0💬

<< < 142 143 144 145 146 147 148 149 150 151 152 > >>   Sort: Rank