similar to: SQL & PL/SQL

Displaying 20 results from an estimated 60000 matches similar to: "SQL & PL/SQL"

2008 Jul 16
2
Wine + PL/SQL Developer + Ubuntu
Hi I?m starting with linux and wine, but I need use PL/SQL Developer in the Ubuntu environment. I?m using PL/SQL Developer 7.0.0.150, Oracle 10g and Ubuntu 8.04. I would like some help to make it works. The software loads but don?t connect to a database. Sometimes, show an error about OCI.dll not present. How do I solve this? How I configure wine to do this. Tks a lot Ricardo
2008 Aug 26
0
Re: Wine + PL/SQL Developer + Ubuntu
Revieing an old topic, the original poster's issue is not a WINE issue, but a missing prerequisite of the program. From http://www.allroundautomations.nl/plsqldev.html (emphasis mine): System requirements PL/SQL Developer will run on Windows 95, 98, ME, NT4, 2000, XP, 2003 and Vista. The supported Oracle Server versions are 7.x, 8.x, 8i, 9i, 10g and 11g on any platform. To connect to an
2011 Feb 17
2
Dovecot 1.2, problem with SQL quota and mail aliases
Hello, I have a small server running dovecot 1.2 (still not balsy enough to switch to 2.0 - virtual sql accounts, managesieve etc.). There are no local users - only ones defined in the SQL database, and everything else (including quota) is defined in SQL db too. Dovecot is used as IMAP daemon, and dovecot-lda is responsible for delivery (in order to make use of sieve and managesieve). I know
2012 Apr 02
0
Requirement for Java Developer [REQ:104605]
[1]Click here to unsubscribe if you no longer wish to receive our emails Dear Partner, Here is our Direct client requirement which can be filled immediately. Kindly respond to this requirement with your consultant resume, contact and current location info to speed up the interview process. [2]Click here to submit for this position online and to speed up the
2011 Jun 17
0
I can't setup namespace per user (with settings keept in sql db)
Hello! I'm trying to setup additional namespace. I'd like to have this setting per user and keep it in postgresql. Global namespace is defined in this way: namespace { inbox = yes location = prefix = separator = . } (mail_location is getting from db) I don't know how should looks like database field:( Now i have such configuration: user_query = select .... dovecot_location AS
2009 Mar 27
7
multiple sql servers - loadbalancing and failover
Hi, Is there a way for dovecot to use a pool of sql (mysql) servers and load balance queries between these? Also fallback to next available sql server if connection to previous one fails. Can dovecot do such things currently? (If not this is feature request). -- Arkadiusz Mi?kiewicz PLD/Linux Team arekm / maven.pl http://ftp.pld-linux.org/
2003 Jan 23
1
cleanup_recycle.pl problem (maybe OT)
Hi all This maybe slightly OT, but I just noticed an interesting difficulty with the cleanup_recycle.pl script that comes with 2.2.7a. I run it on a cron job every night, deletes files and directories after 3 days. The trouble I have is that some of my directory are named with spaces in them ie "Base Maps" rather than a more proper "Base_Maps" The script really doesn't
2003 Feb 16
0
[SUMMARY] Converting coef(lm) to SQL/VBA/etc
Many thanks to all who helped with my question last week about how to take the output of lm() and turn it into code that can be run on systems without R (using SQL, C, etc). This is a summary of the answers, caveats, and a solution including a little Perl script I wrote to do this. Brian Ripley pointed out an important caveat to this whole process - the model.matrix could contain R functions that
2006 Mar 05
0
Converted tattle.pl to ruby - anyone want to be a tester?
The basic idea of tattle (http://www.securiteam.com/tools/5JP0520G0Q.html) is that it will go through your /var/logs/messages to find brute force attack attempts on your machine via ssh. It then looks up the abuse records and emails the network owners about the attack. It worked well until the log format changed a little when I updated last and it broke. So, as an exercise in learning ruby and
2008 Sep 16
1
help with SQL, how can i use functions in sql (pkg :sqldf)
Een ingesloten tekst met niet-gespecificeerde tekenset is gescrubt ... Naam: niet beschikbaar URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20080916/2d0f3a45/attachment.pl>
2013 May 24
2
Store Mails into SQL DB
Hi, is there an option to store eMails into DB right away instead of storing them as files on the HDD?
2007 Jun 04
2
RMySQL question, sql with R vector or list
Hi, I am trying to write a RMySQL sql script inside R such that part of the SQL would be R list or vector. For example, I want to select * from Atable where ID would equal to a members of R list or vector of "1, 2, 3". Here the ID list was generated inside R and then try to feed to mysql to call to get additional data sets. Can someone on the list help? Thanks. -- Waverley @ Palo
2007 Mar 31
3
adding slashes in sql querys
Un texte encapsul? et encod? dans un jeu de caract?res inconnu a ?t? nettoy?... Nom : non disponible Url : https://stat.ethz.ch/pipermail/r-help/attachments/20070331/d233c43a/attachment.pl
2006 Jun 01
2
using ActionMailer with template files retrieved from sql database table instead of on disk files
I''m trying to set up a system which allows users to create and modify emails to send out to clients. I''ve got ActionMailer set up to send from a template file stored on the file system, but I''d like to be able to move this into the database. Does anyone know how to get ActionMailer to read the contents of the email from a database table rather than the on-disk template
2014 May 05
0
Why is Sanitizing SQL Fragments so Highly Muddled?
I've found there are some times where jumping straight to the database is easier than going through ActiveRecord (for instance: odd calculations being performed or large sets of data being returned that don't need to be instantiated into AR models). I can't find an easy or accepted way to bind variables in a custom SQL clause. sanitize_sql_array is protected, so you would have
2013 Apr 19
0
Question marks in SQL string literals
Hi all! Recently I discovered that AR tries to treat question marks inside SQL string literals as parameters, however this behaviour shows in very rare cases, for example (very odd, but...): User.where("NOT EXISTS (#{ Comment.where(''user_id = users.id AND body ILIKE ?'', ''%?'').to_sql }) AND created_at > ?", Date.yesterday).to_sql It will fail,
2019 Feb 12
0
Using SHA256/512 for SQL based password
??? Here i have SSHA256 working with: default_pass_scheme = PLAIN ??? and my database scheme just received the hashed password prefixed by the SSHA indicator, just like: mysql> select * from emails where endereco = 'solutti at XXXXXXXXX'\G *************************** 1. row *************************** ????????????? endereco: solutti at XXXXXXXXXXXXXX ????????????? password:
2013 Apr 12
4
rails named scopes and sql injection
HI guys, I just came through an example on code of the place I work for that said something like this could be vulnerable to sql injection attacks: scope :with_name, lambda { |name| where("LOWER(name) LIKE ?", name.downcase) } I wonder if this is true. My thought is that rails should escape this and that anything that tried to do something different would fail on the translation
2020 May 08
0
courier-dovecot-migrate.pl and courier-5: UTF-8 flag
Hi, Courier to dovecot migration script https://dovecot.org/tools/courier-dovecot-migrate.pl referenced at the https://wiki.dovecot.org/Migration/Courier page has a couple of problems. One of them is that the script could not process courierpop3dsizelist generated by courier-5. File format has been changed a bit to mark UTF-8 messages with an additional attribute. Is it safe to ignore such flag
2012 Feb 14
3
domain quota in sql
Hi, I have a problem with setting up quota usage tracking for domains. Problem is, that domain quota is always based on only one user in domain, the last one on whom behalf any operation was performed. To recreate this situation, one has only to perform: doveadm quota recalc -u USER on a user, and the domain quota takes the value of this user quota. Have anyone a clue what could cause this