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.
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.
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
I want to count the number of employees SQL> select count(ename) AS num开发者_开发问答ber of people, from emp;
Can someone e开发者_如何转开发xplain things a little better to me? How do I show the structure of a table?
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
We saw an issue other day, where the database server was responding to tnsping and not responding when trying to establish a connection..
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
I am new to SQL Plus. I am trying to update a record using SQL Plus in a batch file. Can this be done?
How can I view the code of a stored procedure using sqlplus for Oracle 10g? When I type in: desc daily_update;
加载中,请稍侯......