I'm new to PL/SQL and was wondering if there is an equivalent method in Oracle to Access's Make-Table query? For example this statement in...

Bernie Bernbaum

02-04-2008 06:13 PM
Bernie Bernbaum

= = = > Please send profiles to michael.vigie (AT) pyramidconsultinginc (DOT) com Please let me know if you have any suitable candidate references...

Mike

02-04-2008 04:22 PM
Mike

This is generated by a Pro*C compiler running on an AIX box. It usually contains the proper data, but every once in a while, and only on 2 certain...

44dd44@gmail.com

02-04-2008 11:02 AM
44dd44@gmail.com

Hi, I need to write a query or sub-query, but only use a parameter once. Take a look at this: A Z198051 27-AUG-07 27-AUG-07 B ...

amerar@iwc.net

02-04-2008 08:40 AM
fitzjarrell@cox.net

Hi, i have to test some E-Business Suites server for load testing environment, Oracle advise to use LoadRunner for test it. Someone knows if there is...

Andrea

02-03-2008 05:05 AM
Andrea

Hi, I need to write a query or sub-query, but only use a parameter once. Take a look at this: A Z198051 27-AUG-07 27-AUG-07 B ...

amerar@iwc.net

02-01-2008 12:58 PM
amerar@iwc.net

Hi Business Partner, Here are the Excellent Consultants of our GurusInfotech, they are available Immediately on C2C Basis. I would appreciate, if...

kamal

02-01-2008 10:33 AM
kamal

Greetings from GurusInfotech!!! We have a very Strong SAP FICO Consultant available for positions immediately. Please send across your Direct Client...

kamal

02-01-2008 10:22 AM
kamal

Hi, I need to write a query or sub-query, but only use a parameter once. Take a look at this: A Z198051 27-AUG-07 27-AUG-07 B ...

amerar@iwc.net

01-31-2008 09:33 PM
amerar@iwc.net

Dear Associates, Please find below our available consultants:

Babbs

01-31-2008 04:55 PM
Babbs

Hi all, I am trying to construct a query tool in VB6. This is all i want my query to perform: Select * from table where timestamp_field =...

FeedingFrenzy1947@gmail.com

01-30-2008 01:02 AM
news.verizon.net

Hello, I am trying to have a personalize page for end users to where user could hide,show portlets and add portlets from a repository, Of course we...

ponicpool@gmail.com

01-29-2008 11:44 PM
ponicpool@gmail.com

I am looking to query the first occurance of a row based on a distinct column. Here is an example result set: SELECT * FROM TABLE ID Name ...

trpost@gmail.com

01-29-2008 05:43 PM
David Portas

I have a large perl program which connects to oracle and calls procedures in a package using: call user1.package1.procedure1(args); user1 is the...

Martin

01-29-2008 02:04 PM
Frank van Bortel

Oracle - E-Business Technical Consultant ( email to solutionsdxb (AT) gmail (DOT) com ) * Interfacing with the Finance Functional consultant and...

solutionsdxb@gmail.com

01-29-2008 05:45 AM
solutionsdxb@gmail.com

I'm migrating an application from sql server to oracle. We have tables with column that use user defined data type, for example CREATE TABLE AA...

alberto.roller@gmail.com

01-28-2008 03:48 PM
Mark D Powell

I'm just finishing up my B.A. in database technologies, and I've been looking for my first position in the field. There are lots of Oracle jobs in my...

kevx

01-28-2008 02:39 PM
Ed Prochak

Can someone tell me how flashback works? When I execute: execute dbms_flashback.enable_at_time(sysdate - 10/1440); What exactly is happening here?...

nick

01-28-2008 01:45 PM
fitzjarrell@cox.net

Hi, I am preparing myself to the 1z0-031 DBA OCA exam. Can anyone help me and provide me with the prometric tests for this exam? It would be very...

MATI

01-28-2008 08:33 AM
fitzjarrell@cox.net

Hi, I'm sure this can be done, but I want to verify it. Can you output XML from the result of a query or set of data??? Thanks!

amerar@iwc.net

01-26-2008 05:30 AM
Maxim Demenko

http://computer-language-tutorials.blogspot.com/2008/01/getting-started-with-oracle.html

lawryy

01-25-2008 11:32 PM
DA Morgan

I have the following scenario: - Tables and views are in Schema1 and Schema2 - Synonyms are created private under UserX this works fine no...

nsparta@gmail.com

01-25-2008 07:36 PM
joel garry

hi all i want to show all the sales from tha data i have, that meet the following criteria: - Product category is A or C and VAT is 12% - The...

Totti

01-25-2008 02:24 PM
Ken Denny

Hi, Is it possible to partitioning nested tables? I mean, I have a large table with some columns as nested tables, the main table is partitioned,...

sergioffpc@gmail.com

01-25-2008 07:26 AM
Vladimir M. Zakharychev

Hi, Core question: I'd like to execute this statement as "appuser": ALTER INDEX adminuser.my_oracle_text_index REBUILD; Error message: ORA-01418:...

Krabatz

01-24-2008 03:08 PM
Frank van Bortel

I am new to Oracle and I installed the Oracle 10g Express Edition on my windows machine. Immediately after installation, it worked great and I was...

scout1024@gmail.com

01-24-2008 03:04 PM
Frank van Bortel

I need to move 490 records from a column named TRACKID to PS_NAME. After I do that I need to also set STATUS_CD to "RETIRED" and insert NULL values...

evil0ne

01-23-2008 10:48 AM
evil0ne

Hi to All, I have in my 'schema' 2 tables: CREATE TABLE T_ITEMS ( ITEM_GROUP VARCHAR2(10 BYTE) NOT NULL, ITEM_CODE VARCHAR2(25 BYTE) NOT...

nick048

01-23-2008 09:31 AM
nick048

We would like to migrate our applications and data from informix spatial(st_xxx) to Oracle spatial (SDO_XXXX). Please let me know if there is any...

sb

01-23-2008 03:27 AM
gg_raj

hi all, i need to produce a report which shows the sum last down level employees and only those i ve done an attempt which i am posting, but it is...

Totti

01-22-2008 04:30 PM
fitzjarrell@cox.net

= = = > Please forward profiles to michael.vigie (AT) pyramidconsultinginc (DOT) com Hi, Please let me know if you have any suitable candidate...

Mike

01-22-2008 09:32 AM
Mike

Hello, In my VB 6.0 code, I have tried to connect to oracle-database, but program just hang (even there is no exception !!!) Code is : In alert.log...

Mr. X.

01-22-2008 04:48 AM
Mr. X.

Hi, We have an Oracle 6i forms set up which displays MS Word letters this in-house information system of ours. Everytime we Protect Form on a Word...

hermithead@gmail.com

01-21-2008 10:03 PM
hermithead@gmail.com

anyone have code snippets that copy a table from one schema to another? i usually use toad to do this but i really would like to find more...

Sean Nakasone

01-21-2008 01:51 PM
joel garry

What I am trying to accomplish is to get an understanding of how much columns are being used in a table. We are working on creating a...

noon

01-21-2008 12:55 PM
Mark D Powell

I am a beginning Oracle 9i user and I was hoping that someone can help me. I think I have the basic SQL statements down pat, but this problem is a...

cnbland1@juno.com

01-20-2008 05:30 PM
Charles Hooper

Hi NG, I have a very general question concerning the XML-abilities oracle offers, and I'm afraid I cannot restrict the field of possible causes for...

Albert Greinoecker

01-19-2008 12:23 PM
DA Morgan

http://coderbuzz-programming.blogspot.com

rommy

01-19-2008 12:20 PM
DA Morgan

what are the different between database migration and database upgration?

hitgonoracle@gmail.com

01-18-2008 01:33 PM
Mark D Powell

Hi I have a table Test: id number default -999 occ varchar2(25) default 'student' addr varchar2(25) qual varchar2(100) secid ...

amitabh.mehra@gmail.com

01-18-2008 01:28 PM
Ed Prochak

Needed help to generate following report in html using preferably sql*plus leveraging it's built-in html reporting functionality (i.e.set markup...

maks71@gmail.com

01-17-2008 11:53 PM
Peter Teoh

I understand that when you feed the count( ) function an asterisk as an argument it runs slower than if you use a column name as an argument. Can...

nick

01-17-2008 07:45 AM
shakespeare

hi everbody, i would to partition by range a big table (more than 10millions of rows ) on a aprt of the primary key which is a java sequence in...

batsant@gmail.com

01-17-2008 04:04 AM
batsant@gmail.com

I work primarily in SQL Server and have run across a situatiion in Oracle that's troubling me.... I have a query that contains a where clause with 2...

Jimbo

01-16-2008 02:50 PM
Robert Klemme

Hi, We have an Immediate Opportunity for you as clear case developer. Location : Roseville, CA.

Babbs

01-16-2008 12:54 PM
Babbs

Hi all, Due to a change in roles, I no longer have access to our Oracle dev/test labs. I remember OTN used to have a subscription program where you...

Angie Kong

01-16-2008 04:26 AM
shakespeare

hi like this group very much

meetme.sonaliya@gmail.com

01-16-2008 01:54 AM
meetme.sonaliya@gmail.com

hi all, i want to Show total purchases by supplier in 2006. and i want to nclude only those suppliers from whom we made purchases of more than...

Totti

01-15-2008 12:21 PM
Ken Denny

Hi, Is there a possibility of direct mapping C# class to PL/SQL records, and vice versa, in Oracle 9i with ADO.NET. I need to map some simple records...

s_madej@poczta.wwsi.edu.pl

01-15-2008 12:19 PM
s_madej@poczta.wwsi.edu.pl

Hi Folks, I'm writing a simple update statement in Ora 9.2 and am scratching my head as to why the following syntax is...

Sashi

01-15-2008 11:18 AM
Sashi