Recent questions tagged oracle

0 votes

884 views

1 answer

oracle - PL/SQL bulk collect into associative array with sparse key

I want to execute a SQL query inside PL/SQL and populate the results into an associative array, where one of the ... PL/SQL? If so, how? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

883 views

1 answer

oracle - PL/SQL bulk collect into associative array with sparse key

I want to execute a SQL query inside PL/SQL and populate the results into an associative array, where one of the ... PL/SQL? If so, how? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.3k views

1 answer

oracle - Remove Column Header into the Output Text file

I want to create a flat file (text file) of my query from Oracle SQL Developer. I have successfully ... from terminal_table; spool off; See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

oracle - Reverse String Word by Word using SQL

I would need to reverse the word positions in a sentence or String. For example : "Hello World! I Love ... (Characters in reverse order) only See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

869 views

1 answer

oracle - PL/SQL bulk collect into associative array with sparse key

I want to execute a SQL query inside PL/SQL and populate the results into an associative array, where one of the ... PL/SQL? If so, how? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

904 views

1 answer

oracle - How to constrain a database table so only one row can have a particular value in a column?

Using Oracle, if a column value can be 'YES' or 'NO' is it possible to constrain a table so that only ... values are not allowed in this table. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.2k views

1 answer

oracle - ORA-00947 Not enough values while declaring type globally

create table foo( id number, status varchar2(10) ); Table created. insert into foo values( 1, 'open' ); ... anyone help me out with this? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

932 views

1 answer

oracle - How does contains() in PL-SQL work?

Have a lot of unnecessary results using contains() method in my query. Don't tell me to use like or ... hardcoded and couldn't be changed. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.2k views

1 answer

oracle - ORA-01658: unable to create INITIAL extent for segment in tablespace TS_DATA

When i tried to create a table in my User_DB schema i am getting an error as ORA-01658: unable to create ... the tablespace to solve this issue. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

826 views

1 answer

oracle - Since SQL Server doesn't have packages, what do programmers do to get around it?

I have a SQL Server database that has a huge proliferation of stored procedures. Large numbers of stored procedures ... like that of Oracle? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

901 views

1 answer

oracle - does foreign key always reference to a unique key in another table?

Is it not possible that foreign key(single column) in a child table references to a parent key which has some duplicate values? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.4k views

1 answer

oracle - How to run a SQL Plus script in PowerShell

I am trying to log in to the the Oracle DB using PowerShell and run a script called "C: ... + FullyQualifiedErrorId : CouldNotAutoLoadModule" See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

902 views

1 answer

oracle - The fastest way to check if some records in a database table?

I have a huge table to work with . I want to check if there are some records whose parent_id equals my passing ... " , which is more efficient ? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

995 views

1 answer

oracle - ORA-00932: inconsistent datatypes: expected - got CLOB

Considering that TEST_SCRIPT is a CLOB why when I run this simple query from SQL*PLUS on Oracle, I get the ... datatypes: expected - got CLOB See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

oracle - SQL "Join" on null values

For reasons beyond my control, I need to join two tables and I need null values to match. The best option I ... to match on their actual values. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

oracle - Invalid Identifier SQL

So i have this: SELECT p.plantnaam,o.levcode,o.offerteprijs FROM plant p, offerte o JOIN (SELECT plantcode ... perfectly fine before that point? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

952 views

1 answer

oracle - Primary keys and indexes in Hive query language is poosible or not?

We are trying to migrate oracle tables to hive and process them. Currently the tables in oracle has primary key, ... on how to implement it. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

854 views

1 answer

oracle - SQL - Find statement that insert specific values

I'm working with an Oracle database, interacting with it both from Oracle SQL Developer and from R. This database is ... it and the date/time. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

815 views

1 answer

oracle - Create table in Procedure

I have created the table "Risiko" which shouldntbe dynamic, i tought it would be that simple but it was not. How ... ')); END; Thanks for help See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.0k views

1 answer

oracle - Convert minutes to HH24:MI format

Can you please help in converting minutes to the format of ('HH24:MI'). I am getting the result in integer ... So, how to convert them? Thanks See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.2k views

1 answer

oracle - How to create a not null column in a view

Given a table like: CREATE TABLE "MyTable" ( "MyColumn" NUMBER NOT NULL ); I want to create a view like: ... as "NOT NULL" in the metadata? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

895 views

1 answer

oracle - Setting up a development environment to learn PL/SQL

I want to setup a sandbox environment to hone in on my pl/sql and database skills. I was thinking of ... approach? Thank you in advance! See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

oracle - how to do a function to return row type from a table in pl/sql?

I made this function but it return an error when i execute it! create or replace function get_accounts (Acc_id ... return(l_cust_record); end; / See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.0k views

1 answer

oracle - SQL How to Select the most recent date item

Hello I have a table with columns: *using oracle ID NUMBER USER_ID NUMBER DATE_ADDED DATE DATE_VIEWED DATE ... with date_added column) Thanks See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

999 views

1 answer

oracle - How do I change the default schema in sql developer?

I don't see any tables in the tables section of a database that I've linked to w/ SQL developer. The DB admin ... developer. How do I do that? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

oracle - How do I check the NLS_LANG of the client?

I'm working on Windows OS, I know that this setting is stored in the registry. The problem is that the ... just like Pl/Sql Developer does. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

918 views

1 answer

oracle - Proving SQL query equivalency

How would you go about proving that two queries are functionally equivalent, eg they will always both return the ... no out of place results. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.2k views

1 answer

oracle - How to change the date format from MM/DD/YYYY to YYYY-MM-DD in PL/SQL?

I have a date column in a table stored as MM/DD/YYYY format. I have to select and store the same date in ... ORA-01843 : not a valid month See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

Categories

Just Browsing Browsing

Most popular tags