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