sqlplus
& IN WHERE CLAUSE of oracle [closed]
It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical andcannot be reasonably answered in its current form. For help clari[详细]
2023-04-06 16:39 分类：问答SQL script execution control
I am looking for tips how to cont开发者_运维知识库rol execution of large sql script. It will contain various DDL and DML statement. Mostly I was looking for DDL control.What do I actually mean is, tha[详细]
2023-04-06 03:33 分类：问答SQL*plus does not tokenize its command-line arguments properly when the program path contains spaces
I am using SQL*Plus with the following command line: sqlplus user/pw@TNS @test.sql foo The contents of test.sql follow:[详细]
2023-04-06 01:16 分类：问答A problem with getting the correct data
I have created a query that looks like this but I havent found a way to group the departments together. Thats the part I need help with. I want to get Department number in one colum, Employee is anoth[详细]
2023-04-05 18:44 分类：问答How to get the employees with their managers
This is what I want the output to look like: EmployeeEmp# Manager Mgr# BLAKE7698 KING7839 CLARK7782 KING7839[详细]
2023-04-05 17:09 分类：问答I want to get all jobs that are in dept 30 including the location
I want to get all jobs that are in dept 30 including the location SQL> select deptno,jobfrom emp where deptno =30 (select loc from dept);[详细]
2023-04-05 12:25 分类：问答How to pass variables in sqlplus in bash command
Here is may problem : I have inline sqlplus call in my bash file and I would like to pass it a parameter[详细]
2023-04-05 06:17 分类：问答Is it possible for Oracle sqlldr to accept a TNS entry as an instance qualifier in Oracle 10 and 11?
Is it possible to use a fully qualified TNS entry using sqlldr bundled with Oracle 10/11? For example, in SQLPlus:[详细]
2023-04-04 11:55 分类：问答I want to choose hiredate between '20-FEB-81' AND '01-MAY-81'
I want the names of the employees, job, hiredate between \'20-FEB-81\' AND \'01-MAY-81\', and in ascending order[详细]
2023-04-04 04:07 分类：问答Asending order for hiredate
What am I doing wrong? SQL> select ename, job, oder by (ascending order)hiredatefrom emp where hiredate between \'20-FEB-81\' AND \'01-MAY-81\';[详细]
2023-04-04 04:01 分类：问答
加载中,请稍侯......