Hi, I have to put some count in table that has null or empty values how do i do it in oracle? I am able to get right result for not null values. Any suggestion appreciated. Thanks, MM

I am unable to create database using Java embedded database Derby. The error generated while creating database at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(Unkno ...

Detail String:FATAL: no pg_hba.conf entry for host.....SSL off Can anyone explain or give solutions about this error. Appreciate your help. Have a nice day. Thanks, Carlton

Please make me clear what type of information are you providing to the customer?

Is there any way to check if table or stored procedure already exists? I am writing SQL script where I have to check if table or stored procedure exists before creating a new one. Any h ...

Hi, I have bunch of records created by bunch of users. I want easy and elegant solution to allow users to access their records only from back end. Any ideas or suggestions or exampl ...

I have a question. I am creating stored procedure in MS SQL Server. Do I always need to use BEGIN END statement block even for simple stored proc. For example: CREATE PROCEDURE M ...

Hi, Just installed PostgreSQL 9.x. It is failing to authenticate me and I don't remember password. How can I change it? Thanks, Oracle

Can anyone post the direct link to download a free copy of Microsoft SQL Server 2008 R2? Thanks, Oracle

Hi, I am trying to use Microsoft SQL Management Studio to create a sample schema and connect to this database using my application code written in .NET 4 C#. I am able to create the ...

Dear All, I am trying to install Local Microsoft SQL Server database. I am getting this error while trying to login using both SQL Server Authentication and Windows Authenticaion. A ...

hi everyone! i used getdate() to get current but i get(yyyy-mm-dd hh.mm.ss) is there a way i can just get mm-dd-yyyy please help me!

I see lot of our table column data type is varchar2. I am not sure why DBA are choosing one over the other? Thanks, ETL

I am working on high volume ASP.NET web application. I am using SQL Server for my data source. My application uses MS SQL server extensively. I may even need multiple SQL server to suppo ...

Hi, I often come through this terminology in out meeting with DBA and don't recall what is for what?Can someone point me fundamental different between those two concepts related t ...