本文将介绍OraclePL/SQL未找到数据-非连续的Id值的详细情况，特别是关于oracle未找到任何数据的相关信息。我们将通过案例分析、数据研究等多种方式，帮助您更全面地了解这个主题，同时也将涉及

本文将介绍Oracle PL/SQL 未找到数据 - 非连续的 Id 值的详细情况，特别是关于oracle 未找到任何数据的相关信息。我们将通过案例分析、数据研究等多种方式，帮助您更全面地了解这个主题，同时也将涉及一些关于angular api 数据表：未找到数据、For oracle databases, if the top showing the oracle database, then oracle process is using the top c、NodeJS-Oracle DB - NJS-040 连接超时，在 ICP 中使用带有 Lopback 的 oracle 驱动程序（loopback-connector-oracle）、ORA-01403：找不到数据ORA-06512：在第8行0140300000-“未找到数据”的知识。

• Oracle PL/SQL 未找到数据 - 非连续的 Id 值（oracle 未找到任何数据）
• angular api 数据表：未找到数据
• For oracle databases, if the top showing the oracle database, then oracle process is using the top c
• NodeJS-Oracle DB - NJS-040 连接超时，在 ICP 中使用带有 Lopback 的 oracle 驱动程序（loopback-connector-oracle）
• ORA-01403：找不到数据ORA-06512：在第8行0140300000-“未找到数据”

Oracle PL/SQL 未找到数据 - 非连续的 Id 值（oracle 未找到任何数据）

如何解决Oracle PL/SQL 未找到数据 - 非连续的 Id 值

我有一份具有以下结构的报告：

列 1 ID、列 2 Approved_Rejected_Status、列 3 Rep_Id

我在运行以下命令时收到未找到数据的错误：

DECLARE 

V_REP_ID VARCHAR2(100);
V_ROWS_APPROVED_min NUMBER;
V_ROWS_APPROVED_max NUMBER;
V_STAT VARCHAR2(100);


BEGIN
    SELECT min(id) INTO V_ROWS_APPROVED_min FROM MY_TABLE; 
    SELECT max(id) INTO V_ROWS_APPROVED_max FROM MY_TABLE; 
    
    FOR i IN V_ROWS_APPROVED_min..V_ROWS_APPROVED_max LOOP
    
        SELECT APPROVED_REJECTED_STATUS INTO V_STAT    
        FROM MY_TABLE  WHERE MY_TABLE.ID =i;
        
        SELECT REP_ID         INTO V_REP_ID 
        FROM MY_TABLE  
        WHERE MY_TABLE.ID = i;
    END LOOP;
END;

我认为这可能与具有非连续值的 ID 有关？ （我不能在报告上有连续的功能值，也不包括我需要根据 type_of_change 执行操作的异常原因）

谢谢

编辑： 感谢 MT0 的评论/建议！ 我尝试使用游标 for 循环，但发生了一些非常奇怪的事情：

for cur_m in (select id,approved_rejected_status 
            from bdc_bench_watchlist_t
            order by id) 
loop

    if cur_m.approved_rejected_status = ''Approved'' then 
        --Inserting into a test table:
        insert into index_test (ID_copY,MY_APPROVED_STATUS)
        values (cur_m.id,cur_m.approved_rejected_status);
    end if;
end loop;

结果带来了所有 ID 范围（从最小值到最大值），但是！ allowed_rejected_status 列是空的（只有标题在行上显示为空数据）。我不知道为什么。 如果我从源表中选择一个基本的选择 id、approved_rejected_status，它会带来一切正常（id 和状态信息正常）。

谢谢

解决方法

DECLARE 
  V_REP_ID            MY_TABLE.REP_ID%TYPE;
  V_ROWS_APPROVED_min MY_TABLE.ID%TYPE;
  V_ROWS_APPROVED_max MY_TABLE.ID%TYPE;
  V_STAT              MY_TABLE.APPROVED_REJECTED_STATUS%TYPE;
BEGIN
  SELECT min(id),max(id)
  INTO   V_ROWS_APPROVED_min,V_ROWS_APPROVED_max
  FROM   MY_TABLE; 
    
  FOR i IN V_ROWS_APPROVED_min..V_ROWS_APPROVED_max LOOP
    BEGIN
      SELECT APPROVED_REJECTED_STATUS,REP_ID
      INTO   V_STAT,V_REP_ID   
      FROM MY_TABLE 
      WHERE MY_TABLE.ID =i;
    EXCEPTION
      WHEN NO_DATA_FOUND THEN
        V_STAT := NULL;  -- Or put default values here.
        V_REP_ID := NULL;
    END;
    -- Do stuff with the stat/rep_id
  END LOOP;
END;

angular api 数据表：未找到数据

如何解决angular api 数据表：未找到数据

我正在尝试使用此 API 制作表格： https://run.mocky.io/v3/70e5b0ad-7112-41c5-853e-b382a39e65b7/people 我的表的 html 结构出现了，但没有出现我的 API 的数据，我在控制台中没有错误

你有解决方案吗？

这是我的休息组件的结构（我的表的代码）：

people.ts

export class people {
    id: string; 
    firstname: string;
    lastname: string;
    email: string;
    mobile: string; 
    city: string;
    country: string;
    constructor(id,firstName,lastName,email,mobile,city,country){
        this.id=id;
        this.firstname=firstName;
        this.lastname=lastName;
        this.email=email;
        this.mobile=mobile;
        this.city=city;
        this.country=country;
    }
}

rest.component.html

  <h1>Employee Dashboard</h1>
    
    <table class="table table-bordered">
      <thead>
        <tr>
          <th>Id</th>
          <th>First Name</th>
          <th>Last Name</th>
          <th>Email</th>
          <th>Address</th>
          <th>City</th>
          <th>Country</th>
        </tr>
      </thead>
      <tbody>
        <tr *ngFor= "let user of users">
          <td>{{people.id}}</td>
          <td>{{people.firstname}}</td>
          <td>{{people.lastname}}</td>
          <td>{{people.email}}</td>
          <td>{{people.address}}</td>
          <td>{{people.city}}</td>
          <td>{{people.country}}</td>
        </tr>
      </tbody>
    </table>

rest.component.spec.ts

import { Testbed,async } from ''@angular/core/testing'';
import { RouterTestingModule } from ''@angular/router/testing'';
import { AppComponent } from ''./rest.component'';
describe(''AppComponent'',() => {
  beforeEach(async(() => {
    Testbed.configureTestingModule({
      imports: [
        RouterTestingModule
      ],declarations: [
        AppComponent
      ],}).compileComponents();
  }));
  it(''should create the app'',() => {
    const fixture = Testbed.createComponent(AppComponent);
    const app = fixture.debugElement.componentInstance;
    expect(app).toBeTruthy();
  });
  it(`should have as title ''project''`,() => {
    const fixture = Testbed.createComponent(AppComponent);
    const app = fixture.debugElement.componentInstance;
    expect(app.title).toEqual(''project'');
  });
  it(''should render title in a h1 tag'',() => {
    const fixture = Testbed.createComponent(AppComponent);
    fixture.detectChanges();
    const compiled = fixture.debugElement.nativeElement;
    expect(compiled.querySelector(''h1'').textContent).toContain(''Welcome to project!'');
  });
});

rest.component.ts

import { Component,OnInit } from ''@angular/core'';
import { people } from ''./people'';
import { RestService } from ''./rest.service'';
@Component({
  selector: ''app-root'',templateUrl: ''./rest.component.html'',styleUrls: [''./rest.component.css'']
})
export class RestComponent implements OnInit {
  people: people[] = [];
  constructor(public rs: RestService){
  }
  ngOnInit():void {
    this.rs.getUsers().subscribe((response) => {
this.people=response;
    })
  }
  title = ''project'';
}

rest.service.ts

import { Injectable } from ''@angular/core'';
import { HttpClient } from ''@angular/common/http'';
import { people } from ''./people''
@Injectable({
  providedIn: ''root''
})
export class RestService {
 constructor(private http:HttpClient){}
 url:string= "https://run.mocky.io/v3/70e5b0ad-7112-41c5-853e-b382a39e65b7/people";
 getUsers(){
   return this.http.get<people[]>(this.url);
 }
}

解决方法

getUsers(){
   return this.http.get<any>(this.url).pipe(
   map(response) => {
      return response[''people''];
   })
  );
}

        <tr *ngFor= "let user of users">
          <td>{{user.id}}</td>
          <td>{{user.firstname}}</td>
          <td>{{user.lastname}}</td>
          <td>{{user.email}}</td>
          <td>{{user.address}}</td>
          <td>{{user.city}}</td>
          <td>{{user.country}}</td>
        </tr>

<tbody>
        <tr *ngFor= "let p of people">
          <td>{{p.id}}</td>
          <td>{{p.firstname}}</td>
          <td>{{p.lastname}}</td>
          <td>{{p.email}}</td>
          <td>{{p.address}}</td>
          <td>{{p.city}}</td>
          <td>{{p.country}}</td>
        </tr>
      </tbody>

For oracle databases, if the top showing the oracle database, then oracle process is using the top c

NodeJS-Oracle DB - NJS-040 连接超时，在 ICP 中使用带有 Lopback 的 oracle 驱动程序（loopback-connector-oracle）

Declare 

  V_Id Deneme_Customer.Custno%type;
  V_Custbal Deneme_Customer.Custbal%Type;
  v_situation Deneme_Customer.Custbal_Situation%type;

Begin
  Select Custno,Custbal,Custbal_Situation Into V_Id,V_Custbal,V_Situation
    From Deneme_Customer Where V_Id =''&no'';
  
  If (V_Custbal>=20 And V_Custbal<=100) Then 
    V_Situation:=''Es tut mir sehr leid'';
  Elsif (V_Custbal>=101 And V_Custbal<=1000) Then 
    V_Situation:=''Guuuut'';
  Elsif (V_Custbal>1000) Then 
    V_Situation:=''Sehr Guuuut'';
  Else Dbms_Output.Put_Line(''Falsche Eingabe'');

  End If;
  
  update Deneme_Customer set Custbal_Situation=v_situation where Custno=V_Id;

end;`

Begin
  Select Custno,Custbal,Custbal_Situation Into V_Id,V_Custbal,V_Situation
    From Deneme_Customer 
   Where Custno = ''&no'';
  Exception When no_data_found then null;
 End;

UPDATE deneme_customer
   SET custbal_situation =
           CASE
               WHEN custbal >= 20 AND custbal <= 100 THEN ''Es tut mir sehr leid''
               WHEN custbal >= 101 AND custbal <= 1000 THEN ''Guuuut''
               WHEN custbal > 1000 THEN ''Sehr Guuuut''
           END
 WHERE custbal >= 20;

SELECT custno,custbal,custbal_situation
  FROM deneme_customer
 WHERE custbal < 20;

exception 
  when no_data_found then
    <handle apppropriately>
  when TOO_MANY_ROWS then
    <handle apppropriately>
 WHEN OTHERS THEN
    DBMS_OUTPUT.PUT_LINE
      (''Unknown error'');
end