Posts

Demo Tables in Oracle SQL for practice

-
Employee Table Creation and Insertion Scripts in Oracle SQL =========================================================== CREATE TABLE EMP ( EMPNO NUMBER(4) NOT NULL, ENAME VARCHAR2(10), JOB VARCHAR2(9), MGR NUMBER(4), HIREDATE DATE, SAL NUMBER(7, 2), COMM NUMBER(7, 2), DEPTNO NUMBER(2)); INSERT ALL INTO EMP VALUES (7369, 'SMITH', 'CLERK', 7902, TO_DATE('17-DEC-1980', 'DD-MON-YYYY'), 800, NULL, 20) INTO EMP VALUES (7499, 'ALLEN', 'SALESMAN', 7698, TO_DATE('20-FEB-1981', 'DD-MON-YYYY'), 1600, 300, 30) INTO EMP VALUES (7521, 'WARD', 'SALESMAN', 7698, TO_DATE('22-FEB-1981', 'DD-MON-YYYY'), 1250, 500, 30) INTO EMP VALUES (7566, 'JONES', 'MANAGER', 7839, TO_DATE('02-APR-1981', 'DD-MON-YYYY'), 2975, NULL, 20) INTO EMP VALUES (7654, 'MARTIN', 'SALESMAN', 7698, T...
Post a Comment
Read more

ORA:12541 cannot connect. no listener at host localhost port 1521

-
How to resolve "Test failed: ORA-12541: Cannot connect. No listener at host localhost" 1. Write SQL query to get SID: select * from global_name; FREE 2. Qpen Services and check these three services running or not, if not start. To open service use: windows icon+r type services.msc a. OracleJobSchedulerFREE --- Must Running. b. OracleOraDB23Home1TNSListener --- Must Running. c. OracleServiceFREE --- Must Running. 3. D:\app\karra\product\23ai\dbhomeFree\NETWORK\ADMIN\/istener.ora Check hostname and copy same host name and replace with localhost. 192.168.1.40 lsnrctl status lsnrctl start ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = localh (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl.opentext.net ) app > usuario > product > 21c > homes > OraDB21Home1 > network > admin listenes sqlnet sqlnet23112611PM4112.bak tnsnames
Post a Comment
Read more

Sub-Queries in Oracle SQL

-
Image
 Sub-Queries in Oracle SQL   SNO Type of Sub-Quries 1 Single-Row Sub-Queries 2 Multi-Row Sub-queries 3 Co-Related Sub-Queries 4 Inline Views 5 Scalar Sub-Queries   Single-Row Sub-Queries Returns one value SELECT <columns> FROM <table_name> WHERE <col_name> <OP> (SELECT STMNT); > , >=, <, <=, =. <>     A single-row subquery in Oracle SQL is a subquery (a query nested inside another query) that returns only one row. Ø   It can be used in Select, Where, and Having clauses. Ø   The main/outer query uses the inner query result as its conditions. Ø   If a single-row sub-query returns more than one row, then you will get an error Ø   ORA-01422: exact fetch returns more than the requested number o...
Post a Comment
Read more

P2P Cycle in Oracle Fusion

-
Image
  Procure to Pay (P2P) process in Oracle Fusion ERP
Post a Comment
Read more

About Natural Account in Oracle Fusion

-
Image
      About Natural Account in Oracle Fusion (Documented by Venkat) ****************************************************** How is the Natural Account identified and mapped in the Oracle Fusion GL Table?   Step 1:  A journal entry is created using a code combination. Step 2:  The combination includes multiple segments (Company, Department, Natural Account, etc.). Step 3:  The  Accounting Flexfield Definition  identifies the Natural Account segment (e.g., SEGMENT3). Step 4:  That segment value (e.g., 5100) determines the account type (e.g., Expense)       GL_CODE_COMBINATIONS Table                                            Holds up to 30 segment columns (SEGMENT1 to SEGMENT30).                    ...
Post a Comment
Read more

Joins in Oracle SQL

-
Image
 Joins ========== Primary Forign Key Relation Ship DEPT ((DEPTNO PK-Primary Key)  EMP (DEPTNO FK-Foreign Key) Cross Join ---------- select empno, ename, job, dname , loc from emp, dept; select empno, ename, job, dname , loc from emp, dept where ename='SCOTT'; Result: EMPNO ENAME JOB DNAME LOC ------------------------------------------ 7788 SCOTT ANALYST ACCOUNTING NEW YORK 7788 SCOTT ANALYST RESEARCH DALLAS 7788 SCOTT ANALYST SALES CHICAGO 7788 SCOTT ANALYST OPERATIONS BOSTON ------------------------------------------ Equi-Join --------- select empno, ename, job, dname , loc from emp, dept where 1=1 and emp.deptno=dept.deptno and ename='SCOTT'; Result: EMPNO, ENAME, JOB, DNAME, LOC --------------------------------------- 7788 SCOTT ANALYST RESEARCH DALLAS select empno, ename, job, dname , loc from emp, dept where 1=1 and emp.deptno=dept.deptno --and ename='SCOTT'; Result: EMPNO, ENAME, JOB, DNAME, ...
Post a Comment
Read more