• Oracle: Count on only one table within select

    I have the following SQL and want to add to the query a count of records for each of the tables selected out of the user_tables, basically count(*). I've tried several things, but am getting only a count of 1. Any help would be appreciated. select substr(a.table_name,1,15) , substr(b.t$desc,1,40) 2...

    nemsmith30 pointsBadges:
  • Stored procedure to transfer data in Oracle SQL Developer

    How can I write a stored procedure to transfer data from staging table to target table in Oracle SQL Developer? stagging table (stagcoindesk) to (coindesk) target table. Was thinking about this code: CREATE PROCEDURE YourProcedure AS TRUNCATE TABLE YourTable INSERT INTO YourTable SELECT * FROM...

    dreamersai5 pointsBadges:
  • Needed help with SQL query involving password column in a table

    Hi, I have a requirement like I need to create a table with password column which should have any of the numbers between 0-9, any special symbols, alphabets. It should contain all the three combination. If the user try to insert missing any one should throw inserting error.

    vinu54615 pointsBadges:
  • SQL query on tourism forecasting

    I have 11 years monthly data of tourist in India. Now I want a SQL query to find the next year forecast for tourist.

    vijaydev19665 pointsBadges:
  • How to create monthly attendance report?

    TABLE I HAVE: Code Name AttendanceDate Status ---- ---- -------------- ------ A001 Abc Jan-01-2013 Present B001 Xyz Jan-01-2013 Present A001 Abc Jan-02-2013 Absent B001 Xyz Jan-02-2013 Late A001 Abc Jan-03-2013 Late Expecting below output with AVG attendance of month. Jan, 2013 Code Name 1 2 3 .....

    Sri100815 pointsBadges:
  • Dynamic SQL in RPGLE

    I am building a dynamic SQL in RPGLE with a wildcards. It does not work like a native SQL statement. A search for "FRANK" will search on 6 characters (retrieve all the FRANK and the FRANKL, but not the FRANKLIN). A search on "FRANKL" will retrieve the FRANKL and the FRANKLIN. Any help would be...

    davidgrant10 pointsBadges:
  • SQL database only with LDF file

    Is it possible to restore a SQL database with the latest ldf file because the MDF file is corrupted? I was hoping that data is still there. I actually have a backup of the MDF file of last month. But the MDF file this month is damaged, and the ldf file still normal. Can I use the. MDF file backup...

    ArturKis25 pointsBadges:
  • How to create 5 table in LEFT OUTER JOIN

    How do I create 5 tables in LEFT OUTER JOIN?

    shibinfelkees5 pointsBadges:
  • Oracle FK Dependencies

    A query I run accesses multiple tables. One of those tables has a FK dependency on a column, which is populated by the application and hardcoded as a single value for all records. So in the where clause when im joining all the tables to get the data required, it is only pulling data for that...

    Rishik015 pointsBadges:
  • How can I start my IT career?

    I am certified as ISTQB FL but I have zero experience and no knowledge about programming language but I am beginning in SQL. What other skills and IT knowledge to start my career?

    Ahmed12345675 pointsBadges:
  • SQL Primary key and surrogate key

    When surrogate key is generated automatically, then why is a primary key required?

    Lavanya925 pointsBadges:
  • How to get nth highest salary using SQL/400 query

    Hi, How can I get nth highest salary from a PF named EMP having two columns EMPID and ESAL need to retrieve nth highest salary using SQL/400 query. Here N may be first, second,third any no.  Thanks!

    6r1,850 pointsBadges:
  • Can I load data using SQLLDR into an in-memory table?

    Can I load data using SQLLDR into an in-memory table and is this the best way? Thanks so much.

    rG1234565 pointsBadges:
  • Dynamic SQL in RPGLE

    How can I build a dynamic SQL statement for input from a screen file?

    davidgrant10 pointsBadges:
  • Oracle SQL: Retrieve data for previous week

    I am trying to retrieve data for the previous week. I need to get the previous week starting on Monday and ending on Sunday. How can I retrieve the data from Monday to Sunday? For example, today is 10-Aug-2016. So, I need details from 1-Aug-2016 to 5-Aug-2016 as week day, and 6-Aug-2016 to...

    rajeshgudla5 pointsBadges:
  • SQL on multi-membered file without overriding

    How to query on a file and retrieve data from any of the members of the file without overriding to any of them?

    vishwaraja5 pointsBadges:
  • Oracle In Linux

    How can I able to get and work with Oracle in Linux platform. I am using RedHat Linux 9.0.

    Samachar0 pointsBadges:
  • SQL database rollback query

    How do I roll back in case the database changes all data to the same information?

    twatonny015 pointsBadges:
  • Rename SQL database table

    For my SQL database, I have to rename one of my columns. What's the process to do that? Will a specific query work for this? I just have to change the name.

    ITKE436,000 pointsBadges:
  • Getting a missing expression error when inserting from another table

    INSERT INTO dst_case1 (email) values  SELECT (email_addr) FROM siebel.S_CONTACT@TCCP.TMS.TOYOTA.COM where dst_case1.customer_id=siebel.S_CONTACT@TCC

    paramu775 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