Browse by Tags

All Tags » RDBMS (RSS)

Strip that hour, minute, second part out of my Date field in Oracle by lamia

I was trying to get a set of records in oracle with a certain date interval. I wanted to make sure that I only get the month, day and year part. Good thing I had an oracle guru officatemate and told me that the TRUNC function strips out the hour, minute...
Filed under:

Passing an Array in a PL/SQL Function/Procedure by lamia

Note: The code provided will not compile. It should only serve as a guide! We had a performance issue and one of the solutions I came to to prevent excessive rountrip from my Java application to the database is to pass the things I need as an array to...
Filed under:

Exception handling in PL/SQL by lamia

Note: I'm doing this code inside a Package. I've never written an PL/SQL program outside of a Package. You can declare exception everywhere inside a PL/SQL Stored Procedure or Function. PROCEDURE MY_PROC(V_ARG_SOMETHING IN MY_TBL.MY_FIELD%TYPE...
Filed under:

My PL/SQL Experience by lamia

I've been doing quite a lot of PL/SQL lately. It's funny because I was able to utilize the stored procedures more in Oracle although the product I was able to code my first stored procedure in was SQL Server 2000. Not that I did not do any stored...
Filed under: ,

Oracle SQLDeveloper by lamia

I've been fiddling with Oracle SQLDeveloper lately. What I liked about it is that it's free and second, it's an alternantive to M$ SQLServer. I think you could even use it for other RDBMS other than Oracle like MySQL and SQLServer. It's...
Filed under:

Levels of Data Normalization by lamia

I've been thinking my whole career through what the Levels of Data Normalization means. I know I've been doing it, but I didn't know on which level I am at during this process. I had a discussion with an office colleague and he told me to...
Filed under:

I had a talk with the most silent person in our team... by lamia

I just had a talk with one of our senior .Net developers. I asked him if he know about Execution Plan and Indexing in Database. Hmmm... I was shown a diagram in SQLServer which apparently computes the cost of each query in percentage. I guess query optimization...
Filed under:

Database Execution Plan and Database Indexing - Two things your mama probably didn't tell you by lamia

Truly, in life... There is no shortcut. And the same rule applies to me. I just came from a very exhausting interview today and I was asked about several things about Java technology tools which I don't have experience with and SQL Performance Tuning...
Filed under: ,

Back to basics - SQL Wild Cards by lamia

It's funny how the simplest of things could actually fool you. If you want to search for a particular String, let's say "Lamia", but you don't know if that name actually has some trailing numbers or something. You just know that...
Filed under:

SQLServer 2000 Problem: The account name is invalid or does not exist by lamia

I just got in the office and turned on my computer when I noticed that I didn't have an internet connection. Now, I didn't notice if my SQLServer was already up and running that time. I changed from my current DNS to another DNS including my Alternative...
Filed under:

SQLServer 2005, jTDS and Netbeans by lamia

The thing I hate about SQLServer is that it gives me too much headache whenever I use it with Java. Since I already had share of of those from my last company, I already had some precautions. Use jtds driver Enable TCP/IP on default port 1433 For SQLServer...
Filed under: , ,

Redirect operator in MySQL causes error in Java by lamia

I was instructed to convert a PHP script that executes a shell command(mysqldump command) to Java. There were various resource available and executing the mysqldump command was a peice of cake. However, I wasn't getting the output that I expect. The output...
Filed under: ,

Database-driven policy feature by lamia

I still remember back then when I was working as a trainee in one of my former companies. My boss gave a requirement wherein a user will only have specific areas of the application(this is a webapp) which he can gain access. I have to admit that it was...
Filed under:

Oracle Database 10g Express Edition by lamia

This is a good news for those who have no experience developing with Oracle like myself. I haven't read the terms of use yet but who cares? It's free! http://www.oracle.com/technology/products/database/xe/index.html
Filed under:

Character encodings in MySQL by lamia

Just as I was modifying our database, I thought again of support for localizing our app. I was given advise by someone here in the devpinoy.org community, to support localization in your app your app must be planned with it from the ground up. Since we...
Filed under:
More Posts Next page »
Copyright DevPinoy 2005-2008