Online Tech Support
  Home

Computer Help

 

The examples about Oracle, MySQL, Unix, Linux, Windows, Mobile Phones and other technology platforms! Free consultation and answers from Online Tech Support about any type of computer problems.

Oracle Database :
Oracle Alter Table Statement Oracle Analytic Functions Oracle Avg
Oracle Case Expression Oracle Cast Oracle Ceil
Oracle Coalesce Oracle Concat Oracle Count
Oracle Create Table Oracle Create User Oracle Create View
Oracle Date Difference Oracle Floor Oracle Date Format
Oracle Decode Oracle Delete Statement Oracle Deterministic Clause
Oracle Drop View Oracle Expdp Utility Oracle Extract From Date
Oracle Full Outer Join Oracle Group By Clause Oracle Having Clause
Oracle Impdp Utility Oracle Insert Statement Oracle Instr
Oracle Intersect Operator Oracle Interval Oracle Join Statements
Oracle Length Oracle Like Condition Oracle Lpad
Oracle Merge Statement Oracle Minus Operator Oracle Nested Loop Join
Oracle Nvl Oracle Nvl2 Oracle Password Expiration
Oracle Pivot Operator Oracle Regr_Count Oracle Replace
Oracle Right Outer Join Oracle Rpad Oracle Round
Oracle Rownum Oracle Select Statement Oracle Select Into Statement
Oracle Sequence Oracle Sign Oracle Substr
Oracle Sum Oracle Table Partition Oracle Timestamp
Oracle To_Char Oracle To_Date Oracle To_Number
Oracle Trim Oracle Trunc Oracle Union Operator
Oracle Utl_File.Put_Line Oracle Update Statement Oracle With Operator
Oracle XE Database

Programming Tips:

How To Use Oracle Bind Variables with PL/SQL
How To Use An Oracle Function In The Where Clause
How To Use Oracle Date Difference With MS Excel
How To Change Oracle NLS_LANG For MSDOS Mode

Error Codes:

KUP-04040: file (filename) in (directory) not found (Create external table)
ORA-00900: invalid SQL statement
ORA-00923: FROM keyword not found where expected
ORA-00933: SQL command not properly ended
ORA-00937: not a single-group group function (Oracle Sum)
ORA-00938: not enough arguments for function (Coalesce)
ORA-00979: not a GROUP BY expression
ORA-01006: bind variable does not exist
ORA-01006: bind variable does not exist (PL/SQL)
ORA-01008: not all variables bound (PL/SQL)
ORA-01031: Insufficient Privileges with Oracle Create Directory
ORA-01031: Insufficient Privileges with Oracle Shutdown Abort
ORA-01722: invalid number
ORA-06536: IN bind variable bound to an OUT position
ORA-06537: OUT bind variable bound to an IN position
ORA-06564: object <directory> does not exist (Create external table)
ORA-12170: TNS:Connect timeout occurred
ORA-28002: the password will expire within X days
ORA-29400: data cartridge error (Create external table)
ORA-29913: error in executing ODCIEXTTABLEOPEN callout (Create external table)
ORA-30009: Not enough memory for CONNECT BY operation
ORA-32033: unsupported column aliasing
Error Oracle Expdp Is Hanging

PL/SQL

Oracle Static SQL vs Dynamic SQL and Bind Variables
How To Use Oracle BULK COLLECT INTO LIMIT

JavaScript :
JavaScript Introduction JavaScript If-Else Statement JavaScript Substring
JavaScript String Length

Linux:

Java does not work with Ubuntu and ADVFN
Error java.lang.SecurityException: Changing the SecurityManager is not allowed

Windows 7 :

How To Create Windows 7 Disk Partitions

Windows 7 Memory Test

Windows XP Mode

Cygwin:

Cygwin Commands Raising Errors “command not found”

Phones:

How To Unlock Samsung Galaxy