sqlplus
ORA-00913: too many values error when I run a query in SQL*Plus
I am trying to get the dname, loc, and count the ename\'s, plus I want to include the sal from the table. Can someone tell me what I am doing wrong.[详细]
2023-04-04 03:59 分类:问答how to increase sqlplus column output length?
I have som开发者_运维问答e queries to find out the ddl of some objects from a schema. The result columns I am getting are truncated in the middle of the queries.[详细]
2023-04-04 00:07 分类:问答Getting data from two tables?
I am trying to get data from two different table and put into on statement but its not working. This is what I am looking to get as a complete statement: I want the query to display the dname, loc, Nu[详细]
2023-04-03 21:10 分类:问答What's wrong with this command in SQL plus?
I want to count the number of employees SQL> select count(ename) AS num开发者_开发问答ber of people, from emp;[详细]
2023-04-03 12:36 分类:问答Show the structure of the table in SQL
Can someone e开发者_如何转开发xplain things a little better to me? How do I show the structure of a table?[详细]
2023-04-03 12:19 分类:问答How do I get the delta for user_id since the previous months using oracle sql
Let\'s say I have a table that has \"user_id, loaddate\", and many users are in user_id, but some may be added or removed at each month. How can i compare to find out who has been added or dropped out[详细]
2023-04-03 01:51 分类:问答SQLPlus connection timeout options
We saw an issue other day, where the database server was responding to tnsping and not responding when trying to establish a connection..[详细]
2023-03-31 23:53 分类:问答Getting SQLPlus to spool out Unicode characters, are being output as?
I am attempting to get Oracle sqlplus (10.2) to spool out Unicode data on a Linux machine. I have found several discussions of this issue, but no clear answers, other than to check locale settings and[详细]
2023-03-30 17:28 分类:问答SQLPLus waits... why?
I am new to SQL Plus. I am trying to update a record using SQL Plus in a batch file. Can this be done?[详细]
2023-03-26 23:24 分类:问答How to View Oracle Stored Procedure using SQLPlus?
How can I view the code of a stored procedure using sqlplus for Oracle 10g? When I type in: desc daily_update;[详细]
2023-03-26 20:41 分类:问答