Showing entries 981 to 985
« 10 Newer Entries
Displaying posts with tag: database (reset)
How? Connect from ORACLE Developer to ORACLE Database????

Hi ALL

H r u?

Just I'll write how you can connect ORACLE database with ORACLE Developer?

When u use SQL Plus and don't have any problem, and u wanna install developer(Forms & Reports), u cannot connect to the same Database.

The first:

You must have the same NLS_LANGUAGE in two home (DB, Dev).

How?

Go to Registry Editor: Start -> Run -> regedit ->

Search about "NLS_LANG" and change its value to "AMERICAN_AMERICA.AR8MSWIN1256" to you can write and retrieve Arabic, and search another time else "not found".

The second:

Search about file "tnsnames.ora", we will found more than one file.

You'll find it in

\NET80\ADMIN …

[Read more]
LiveMessenger.net

LiveMessenger.net

Welcome at LiveMessenger.net, the first website about Windows Live Messenger! The next version of the extremely popular instant messaging client MSN Messenger won't be called MSN Messenger 8, but Windows Live Messenger, or Windows Live Messenger 8. At LiveMessenger.net, we'll keep you updated with all the latest news about WLM!

Screenshots












Download Windows Live Messenger Beta

http://www.livemessenger.net/


[Read more]
A Nice CS Books Library


http://www.unix.org.ua/


CIA's database

Hey look! CIA uses MySQL:

http://cia.navi.cx/info

Dynamic Materialized Views in MySQL

In one of my latest postings I mentioned a way to create semi materialized views in MySQL. The problem was that the solution required a stored procedure for every materialized view. That's very annoying. So I looked for a more general and dynamic approach. The result is another stored procedure with 3 parameters:

  • the name for the source table / view
  • the primary key columns of the source table / view
  • the desired name for the materialized view

Basically this procedure does the following:

  • It drops the materialized view if it already exists
  • It creates the materialized view with the structure and data of the source table
  • It adds a primary key to the newly created materialized view

However the procedure does not create triggers on the table. This could be an improvement for a …

[Read more]
Showing entries 981 to 985
« 10 Newer Entries