I am using SQL Developer over a backend Oracle DB. I have a record where the buyer name is Pete Hansen. Why I try I get the result, no problem. However, when I use the following, I do not get any results: Also, when I try the following, I do not get any results but the following works well: Could
Separate “Mr John Joe Smith” into “Mr” “John” “Joe” “Smith”
A file supplied by a Client has the following structure: FullName Mr John Joe Smith They would like this transformed to the following: Salutation FirstName MiddleName LastName Mr John Joe Smith I’ve looked into this and I’ve tried the following: This produces: Salutation FirstName Mr John Joe Smit…
postgresql- how to define a variable by a function call in an if statement [closed]
I have this function: CREATE OR REPLACE FUNCTION findMyList( p_user_id bigint) …. DECLARE myVar_id bigint; … IF myVar_id = select p_user_id from myFunction(p_user_id ) THEN …
How to Replace NULL Value with 0 (Zero)?
I’ve just got myself stuck with some SQL query and I’m quite new on this. I’m using pivot in my query. This is my SELECT query: SELECT * FROM (SELECT lg.domainNameID AS [Domain ID], COUNT(lg….
SQL Query to Find if (Count of date > X) = 0 For Group of ID
I apologize if the title is not be correct as I’m not sure what I need to ask for, since I don’t know how to build the query. I have the following query built to return a list of chemicals and other related fields. I am using this query in a VB.Net application where it exports the results to an
Calculate amount of days worked by employee from 1 column to another with a function
This is my function I have so long, I need to be able to just call it with with an Employee number from the Employee table and it has to calculate the days between the 2 columns. If there is a better way please let me know, this is what I have… Answer Presumably, you want something related to the
How to import a JSON file into postgresql databse?
I just tried to read a .JSON file in my PostgreSQL database but it is not able to read it. I did it with a .csv file, but with a .JSON file, I am not able to do it. This is how the .JSON file looks like: This is the code that I tried, I created the table first and
How to get partial string in oracle
I need to find all the users in the table that have this pattern I only know the first 10 digits, the email address can be different. I did something like this, but I get nothing back Is there another way that I can capture this data in oracle? Thank you! Answer More a comment that a real answer, but
How to insert data from one table to another in laravel?
I have two tables, visitors and in. visitors contains columns, Name, Number, Purpose, and Datetime. in contains Name, Number, and InTime. I want to fetch all the values from the visitors table into in. I have tried copying the data from visitors to in, however, if I add new rows into the visitors table, those…
MySQL get attribute which is not present for all possible values of another attribute
Assume there is a table with columns fieldA and fieldB (Primary Key:fieldA, fieldB). A program keeps inserting entries to this table with the same fieldA value, say constant_for_A, and some arbitrary …