• Create ER diagram in Oracle SQL Developer

    I'm fairly new to Oracle SQL Developer and I'm trying to create an ER diagram for my database tables. How can I go about this process? Any help would be appreciated.

    ITKE413,395 pointsBadges:
  • SQL average command for column IDs

    For SQL, does anyone happen to know if I can use the SQL avg() function for average by my column IDs? Basically, I have several different IDs and I'm trying to get the average of each through one query. How can I go about this?

    ITKE413,395 pointsBadges:
  • How to SQL update several records in a query

    In SQL Server, I have a table that's labeled this: config_name | config_value. I'm looking to update several records in one query. Here's what I have so far: UPDATE config SET t1.config_value = 'value' , t2.config_value = 'value2' WHERE t1.config_name = 'name1' AND t2.config_name = 'name2'; But...

    ITKE413,395 pointsBadges:
  • How can I stop the export process in SQL Developer

    I apologize in advance if this is a stupid question but does anyone know how to stop the export process in SQL Developer? Thanks!

    ITKE413,395 pointsBadges:
  • Will Visual Basic 6 still work under Windows 10?

    I retired 15 years ago, and write VB 6 programs for my own use to keep occupied. Will Windows 10 mean "forget it or learn C#"?

    jAubel5 pointsBadges:
  • Copying SQL Azure database to development machine

    I'm looking to copy my SQL Azure database to my local development machine. I already have a development database in the cloud but don't want to pay for it anymore. I have copied by production database to the new development database but I need that same one on the local machine. How can I go about...

    ITKE413,395 pointsBadges:
  • Visual Basic Battleship game complications

    Hello! I am creating a battleship game on visual basic for my computer programming 2 final. In order to chose where you want to place the ship, I allow the user to click on a picturebox of the ship and it brings up another form that has the battleship grid with a checkbox on each square. I realize...

    HelpMeWithThisPlease5 pointsBadges:
  • Create first database in Oracle Database 11g Express

    Recently, I installed Oracle Database 11g Express on my Windows 7 machine. Also, I installed Oracle SQL Developer too. Now, I'm looking to create a database with two tables, followed by using SQL Developer to add / query data. But when I opened Developer, it's asking me to make a new connection (I...

    ITKE413,395 pointsBadges:
  • Three ways to login in to SQL database server?

    Does anyone know what are the three ways to login in to SQL database server?

    melbourne5 pointsBadges:
  • Installing Java on Windows 10

    How do I install Java on Windows 10?

    Chandrasekharan5 pointsBadges:
  • Data visualization

    I am working in a startup, I need to visualize my data using either a reporting tool or data visualization software (both open source). I need to integrate this tool with traffic data coming from Google Analytics, click-cost data from google adwords and the sales data from a CRM software, what...

    amansuri5 pointsBadges:
  • SQL7919 Data conversion error

    Hi, I have an embedded SQL program in which I generate an XML element as a VARCHAR(256). This is done via: select xmlserialize( xmlelement(NAME "Name", 'Something') as VARCHAR(256) ) as XmlResult from sysibm/sysdummy1 The SQL statement is run via sqlcursor and I fetch the result into a RPGLE...

    mathypaesen10 pointsBadges:
  • How to IBM Genius iSeries application connect to Excel VBA

    How to IBM iSeries Access for Windows connect to Excel VBA or can enter data using VBA code?

    Vijay19915 pointsBadges:
  • Issue with a IBM z/OS FTP MPUT execution in a batch job

    I am trying to MPUT multiple *.XML files from a vendor server to my local server. This process works for multiple files TEST.XML and TEST2.XML, but not for 20160518.XML. Are there filename restrictions. The first character has to be character or is it possible to transfer multiple filename that are...

    LeeAnnNunnery5 pointsBadges:
  • Run Webdynpro for SAP ABAP application as Java

    Is it possible to run webdynpro for ABAP application on SAP Portal Web as Java? In other words, may I develop a WD ABAP in SE80 and then run it SAP NetWeaver Web as Java?

    LiborB5 pointsBadges:
  • #1064 Database importing error

    I am getting this error when I import the database in phpMyAdmin. Only few tables is imported. SQL query: <!-- PMA-SQL-ERROR --> <div class="error"><h1>Error</h1> <p><strong>SQL query:</strong> <a...

    afaf915 pointsBadges:
  • Export Oracle SQL Developer query to CSV file

    I'm currently using Oracle SQL Developer and I need to export one of my queries to a text file. I would like it to be a CSV file. But I'm not seeing any export options at all. Even double clicking on the query itself didn't work. What should I do here?

    ITKE413,395 pointsBadges:
  • Confirm what version the Oracle Database is in SQL

    My partner and I are currently creating an installer for a new application. Basically, a user gets to select a data source for their configuration -> nominate what database it is. But here's what we have to do: Basically make sure that the database is Oracle / the version too (this will be done...

    ITKE413,395 pointsBadges:
  • How to substring and cast in select where statement on iSeries with RPG free

    Hi. I'm relatively new to free form RPG and I rewrote a program to be RPG free and SQL. I'm having problems with my where clause. I'm trying to substring the second byte on a 2 digit packed field. I've tried to use the CAST statement to convert the packed field to CHAR and then do the SUBSTRING on...

    raynesnf65 pointsBadges:
  • Programming that is similar to mobile short code

    I wish to know more about a programming platform used in mobile banking services where users gain access by dialing *xxx#. They will then view a numbered list of different options which they can select by dialing the corresponding number. I want to know the specific name of this type of programming...

    Ngenda5 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following