Is it possible in a single SQL statement to do the following: Use a subset of telephone numbers in a prompt, for example 8001231000-8001239999.Then query my database that has phone numbers in it, and
I have created a stacked canvas in Oracle Forms 10g.Also I have 2 buttons that on click perform show or hide functions on the stacked canvas.The stacked canvas is placed on top of a content canvas.
I have a column details designed as varchar in oracle DB, this DB is being used now for customers and some rows already have dat开发者_JAVA百科a stored.
what 开发者_开发技巧I want is simple. I wanted one of my table to update its row each time a SELECT was made on it. So I\'ve done this :
I\'m trying to replicate the code found in: http://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:59412348055
I\'m encoun开发者_运维知识库tering an error when connecting to an Oracle DB from VBA code in an Excel Spreadsheet. The query that I run works fine, but when I try to close the connection, I get the fo
I\'d like a Oracle Pipelined Function which compares two records from a query result and shows o开发者_C百科nly the column which have changed between the query result?Here is a blunt instrument approa
To be specific: I have a table with lets day 6 columns, one of which is Hiredate. the Hiredate is of the the type DATE and in the form of dd-Mon-YY. Now I am trying to only output the rows of data whi
I would like to loadbelow files into the oracle database which have multiple master detail data using the sqlldr.
I have created many interlinked tables as user "SCOTT" in oracle DB. I want to copy these tables plus their data to new user "PRODUCTION"
加载中,请稍侯......