Nige Ridd

Hello DBAs, Can any one guide me how can i get the last modified date(insert/update/delete) of a table? Regards, B. Mantri

Hi, Can we get a SQL query, to display all the dates between two given dates eg. if date1=21-mar-2007 and date2=25-mar-2007 then the query should display all the dates between those two given dates i.e 22-mar-2007, 22-mar-2007, 23-mar-2007and 24-mar-2007. Query should not contain any plsql coding. Regards.

I am developing a website,where I am using windows authentication for my connection. I want to change that to server authentication. I want to know what are the steps needed, at what should I watch out, and is there any problems that will appear in my project due to this …

I want to select data from ranges like Column1 Column2 25000 10 50000 20 75000 30 I want records like upto 25000, I get 10 upto 50000, I get 20 upto or more than 75000, I get 30 Can anybody suggest me a simple query for that? Thanks in advance,

Hi Guys... i'm not so good at oracle, sql and related stuff.. but i do need to write some simple query's from time to time and i do need to understand that which all tables get updated by a particular transaction. I can do that by going through the code, …

Hello :) , How can i filter something then turn it to filter again and one more time , like : SELECT * FROM Tbl1 WHERE BLABLA1 From those results WHERE BLABLA 2 And Finally , from all back results WHERE BLABLA 3. Real Example: Select all where : the …

Hi, I need a trigger; - to find number 1 from "ID" column and - update "AVAILABILITY" column from Yes to No in "PRODUCT" table. Thanks

Hi, 1- When i insert more than 30 datas (at once) into a table, does sequence cache size(20) effect anything because, i use sequence for auto increment in the table. 2-What happens if i increase the cache size from 20 to 50? thanks

Hi Experts! I am professionally working in Oracle Developer 6i and database oracle 10g. but now i want to learn JDeveloper. I have no tutor available in my area. will you give me some tutorials or URL of tutorials... regards Khalid Mehmood

Hi everyone. Sorry if this question is in the wrong area..I posted it on the VB forum and they advised me to post here also. I have created a visual basic system that is connected to an oracle database. (I connected through data>Add New Data source>New Connection>Oracle Database etc etc) …

Hi Experts I am trying to develop a web application using Pl/Sql as scripting language. but i cant understand where to start and what i should implement the configuration for this purpose.

Hi, I have just downloaded 10g express edition but there is no user interface like SQL Server has. Does anyone prefer any program because i am new for Oracle and have never used before. Thanks

Hey all, Ok first my problem. I have a database that has an employee table and then also an absent table(for when they are off sick). The problem i have is using sql to find the employee that is off the most! So for my sql on the absent table …

Hi, Could you pls explain me the confusing, diffterece between the views "USER_ " , "ALL_" and "DBA_". On which table query should be executed to get all the list of views like user_constraints, user_sons_constraints, user_source,user_sequences etc. Regards Pointers.

from last thread, I figured it out my tables relationship and they do work i believe. however, i can't successfully get elements from each of the table out. if i do: select b_customer_name, h_customer_firstname, h_customer_lastname, telephone from customers c, business_customers b, home_customers h where c.customer_id = b.b_customer_id and c.customer_id = …

Hi all, I am currently doing an application using MS Access 97 as front-end GUI, connecting to a back-end Oracle server. The Oracle server version is 9.x. Now I wanna use integrated security so that I won't need to enter the username/password every time I start my application. The problem …

Is there a way to query Oracle on the number of connections open (Not as the administrator). I am trying to setup connection pooling and I want something (on the client end) to check how many connections are being maintained etc.

Can anybody help me with info on creating a system 5 star voting system in coldfusion or javascript.

Hey guys I'm sure some of you have gotten in this situation before. Unfortunately I do not have the experience in CF to know how to do this myself. Basically I'm updating a clients webpage where the webmaster left (quit? who knows) And it is written in cold fusion. During …

Hello Friends I ran into a syntax error updating a form, I have added a comment to the line below, Please could anyone tell me what I did wrong!!!! [code]<cfquery name="update student" datasource="#Request.super#"> UPDATE student SET studentfirstname='#Trim(Form.studentfirstname)#',. studentlastname='#Trim(Form.studentlastname)#',. address='#Trim(Form.address)#',. city='#Trim(Form.city)#',. state='#Trim(Form.state)#',. studentage='#Trim(Form.studentage)#',. studentclass='#Trim(Form.studentclass)#',. studentstartdate='#Trim(Form.studentstartdate)#',. studentgraduationdate='#Trim(Form.studentgraduationdate)#',. comments= <cfif Len(Trim(Form.comments)) GT 0> …

Hi i want to select the values from my table where a column must contains some value. So i wrote this Select * from RG_TAB where CMCode = 4 and CMCode = 5 This query not giving me any result but Select * from RG_TAB where CMCode = 4 Or …

hi, after i create a table using toad.im tryin to insert values thru sql but it says the given table does not exist.i cant find any commit button..what could be wrong???

How do you update checkboxes on a form in cold fusion? I am using the following code to update other form elements : <cfquery name="qry_content" datasource="A4265_gbci"> update tbl_emailsignup set firstname = '#form.firstname#' , lastname = '#form.lastname#' , email = '#form.email#' , job = '#form.job#', company = '#form.company#' , address1 = …

I have a static page/site that I want visitors to be able to personlize, so that everytime they return they will find their own unique settings, links, personal information etc. I do not want them to have to login upon return. I have no idea what type of programming I …

Hey everyone, can someone explain to me why it is so difficult in finding someone who does quality work. I am not here to bash the profession but a lot of guys bs in this field? Does anyone want to make money or rather just play warcraft....:?: [email]eamadden06@yahoo.com[/email]

i am a student and i am making a database for a gym, i have an entity [members] and an entity [training classes], this is a N:M relationship so i have to make an intermediate table so my database is [members] 1------M [Intermediate table] N------1 [training classes], do you have …

Data Management Software makes it possible at organizations to make sure that the principal data of company are precise and formed firmly then leaves this information with the trade partners. It makes sure that the processes, policies and the necessary procedures are set up so that the advantages gained are …

Hello, I'm getting my feet wet using Async Gateways with CF8, and I have created a loop which calls the gateway X amount of times. The gateway request then logs the data, however, it is logging X requests, but only the actual data from the last request in the loop. …

HI all am trying to construct this hybrid of java and mysql. the data comes from a mysql database and I want it to display in the gui. this I have achieved thus far. However I have buttons that sort by surname, first name, ID tag etc....I need event handlers …

Hello DBA, Can any one help me this? The table TEST contains CNAME CNO EXTRA ------------------------------ ---------- ---------- bijaya 645896 mantri 525896 mantri12 525126 testing for null My requirement is to find the column which contains all the rows null(null column) I have created the following procedure to accomplish this …