Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 

Combine the PL/SQL and the SQL commands in manipulating the database.

(PL/SQL structure, Data types, Variable, DBMS Output and Conditions), try to combine the PL/SQL and the SQL, where you can use PL/SQL with SQL commands in manipulating the database. and this is my codes but i am having issues running it...

How to Use Calculation of an Aggregate Function as Filter Criteria?

I have tables on booking orders for trips. Bookings (booking_id, booking_time, driver_id, customer_id) Drivers (driver_id, name) I need to identify all customers who have had at least 60% of their bookings completed by the same driver within t...

How to return order_no where customers made concurrent bookings?

I have a table on booking orders for trips. Bookings (order_no, user_id, booking_time,cancel_time,complete_time) I try to write a query to return the order_no from all rows where customers made concurrent bookings (i.e. where a customer mad...

Problems in writing sql queries anyone who can write following queries?

1. List all the directors who directed a film in a leap year by using SELECT statement 2. Find the film(s) with the largest cast using SELECT statement 3. Find all actors who acted only in films before 1960 using SELECT state...

Displays Profiles with a Similar Job Title and Industry in php

What I want: When I click the First Name a profile.php will open and in one place of a profile.php displays Profiles with a Similar Job Title and Industry Example Click Steven and Neena, Lex, and Alexander's profile will display in p...

How to Create a Simple Admin Page in HTML?

At first i'm a beginner and i have a simple project to do.   I'm trying to build a simple admin page that add some content to my website   This is not a big deal, but i need someone who can instruct my directly ...

Is It Possible to Put all Upcoming to Mobirise eMail to Separate Database?

I receive a huge amount of messages from my landing page, created in Mobirise website builder. It's a mess.   I want to put them in a separate database, so I could see them in an order. Is it possible? I didn't find an answer i...

How to Summarise Leave Time Proportionally and Correctly in MySql

In mysql database i created "leave" table:   CREATE TABLE `leave` ( `ID_LEAVE` int(11) NOT NULL, `ID_WORKER` int(11) NOT NULL, `BEGIN_DATE` datetime DEFAULT NULL, `END_DATE` datetime DEFAULT NULL ) INSERT INTO `lea...

How to Merge Two Tables on Coded Columns Using Python

 Hi guys!   I have two tables and I need to merge these two tables on columns left_on='A', right_on='B'. The problem is that 'A' column is coded 'B' column.   What would be the best optio...

How to Merge XML CTE's in SQL Server Using Common Refid Key

I have the following CTE's, and I'm trying to combine XML1 and XML2 CTE's in Sql Server by their common refid key. ;With TBL1_Fruits As (Select '1' as refid, 'Apples' as fruits, 'Red' a...

How to Insert Data Contained in Entry Widgets on a GUI Correctly into SQL DB Created in Python?

In the code below the str entry widgets that I use the get method to retrieve data from, have been created earlier in the code.   I have tried the following ways to solve the problem: turning the list into a tuple using a list ...

Why am I getting null values for lease_id in Rent?

Passing primary key values in the parent table to foreign key values in child table with parent insert and child insert being in separate stored procedures.   Parent is Lease table, the child is Rent table. I am getting null value...

How to insert this codes data to SQLite?

Need help in inserting the below code packet to SQLite: public class StepDetector { private static final int ACCEL_RING_SIZE = 50; private static final int VEL_RING_SIZE = 10; // change this threshold according to your sen...

java problem

  what is the problem here?please help me package help; import java.util.Date; import java.sql.*; import java.util.logging.Level; import java.util.logging.Logger; public class Help { public static void main(String[] args)...

images from database to jtable. Java

I have an app that contains a database using java sql, and has a jTable that displays the database info. It works fine, EXCEPT for when I am trying to store and display images to one of the columns. I used the  jTable1.setModel(DbUtils.resul...

Getting Foreign Key Constraint Fails Data Insertion Error in MySQL

I am trying to create to 2 tables and inserting data into them but I am getting this error Creating Athlete the table failed SQLSTATE[23000]: Integrity constraint violation: 1217 Cannot delete or update a parent row: a foreign key constraint fail...
Sign In
                           OR                           
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: