Main Menu


Remember me

Lost Password?

Register now!
Who's Online
14 user(s) are online (6 user(s) are browsing Jobs & News)

Members: 0
Guests: 14


Blog: FYI Center for Database Administrator

FYI (For Your Information) Center for Database Administrators with large collection of FAQs, tutorials and tips for on Oracle, SQL Server, MySQL, and other database servers - | URL | Feed
Update: 2018/3/17 20:00:00 (Update) | Mar 17, 2018

How To Define a Sub Function in Oracle? A sub function is a function defined and used inside another procedure or function. You need to define a sub function in the declaration part of the enclosing procedure or function. Sub function definition starts with the FUNCTION key word. Here is a sample sc... - Rank: 345; Updated: 2018-03-18 -> Source | Mar 17, 2018

Can Sub Procedure/Function Be Called Recursively in Oracle? PL/SQL allows sub procedures or functions to be called recursively. The tutorial example below shows you how to calculate factorial values with a recursive sub function: SQL> CREATE OR REPLACE PROCEDURE FACTORIAL_TEST AS 2 FUNCTION F... - Rank: 295; Updated: 2018-03-18 -> Source | Mar 17, 2018

What Happens If Recursive Calls Get Out of Control in Oracle? What happens if your code has bug on recursive procedure calls, which causes an infinite number nested procedure calls? The answer is not so good. Oracle server seems to offer no protection calling stack limit. The script below shows you ... - Rank: 289; Updated: 2018-03-18 -> Source | Mar 17, 2018

What Is the Order of Defining Local Variables and Sub Procedures/Functions in Oracle? In the declaration part, you must define all local variables before defining any sub procedures or sub functions. See the following sample script: SQL> CREATE OR REPLACE PROCEDURE WELCOME AS 2 SITE CHAR(80) ... - Rank: 282; Updated: 2018-03-18 -> Source | Mar 17, 2018

What Is the Difference between Formal Parameters and Actual Parameters in Oracle? Formal parameter and actual parameter are two different terms related parameters used in the procedures and functions: A formal parameter is a term used to refer to a parameter defined in the procedure or function decl... - Rank: 285; Updated: 2018-03-18 -> Source | Mar 12, 2018

How To Extract a Unit Value from a Date and Time in MySQL? If you want to extract a specific date or time unit value out of a date or a time, you can use the EXTRACT(unit FROM expression) function. The tutorial exercise below gives you some good examples: ELECT EXTRACT(DAY FROM NOW()) FROM DUAL; 28 ... - Rank: 280; Updated: 2018-03-13 -> Source | Mar 12, 2018

What Are Date and Time Functions in MySQL? MySQL offers a number of functions for date and time values: ADDDATE(date, INTERVAL expr unit) - Adding days to a date. Same as DATE_ADD(). ADDTIME(time1, time2) - Adding two time values together. CURDATE() - Returning the current date. Same as CURRENT_DATE... - Rank: 268; Updated: 2018-03-13 -> Source | Mar 12, 2018

What Is TIMESTAMP Data Type in MySQL? A TIMESTAMP data type allows you to record a date and time like DATETIME data type. But it has some interesting features when used on a table column: The first TIMESTAMP column in a table will be assigned with the current date and time, if it is not listed in an... - Rank: 284; Updated: 2018-03-13 -> Source | Mar 12, 2018

How Many Ways to Get the Current Time in MySQL? There are 8 ways to get the current time: SELECT NOW() FROM DUAL; 2006-07-01 10:02:41 SELECT CURRENT_TIME() FROM DUAL; 10:02:58 SELECT SYSDATE() FROM DUAL; 2006-07-01 10:03:21 mysql> SELECT CURRENT_TIMESTAMP() FROM DUAL; 2006-07-01 10:04:03 SELE... - Rank: 284; Updated: 2018-03-13 -> Source | Mar 12, 2018

Where to find answers to frequently asked questions on CREATE, ALTER and DROP Statements in MySQL? Here is a list of frequently asked questions and their answers compiled by DBA team on CREATE, ALTER and DROP Statements in MySQL. Clear answers are provided with tutorial exercises on cr... - Rank: 337; Updated: 2018-03-13 -> Source

Copyright (c)