06-19-2009
Not like that, your query was wrong. see the to_char in bold.
7 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I would like to know how to update a table in Oracle database, if a command in one shell script either successfully completes or it fails.(like Y if its success or N if its a failure)
While the command is running,I am able to view the log file created in the Unix machine.After the command... (2 Replies)
Discussion started by: ann_124
2 Replies
2. UNIX for Dummies Questions & Answers
Hi all,
Till now i was able to do apt-get update. but today i started to the following error:
# apt-get update
E: Could not open lock file /var/lib/apt/lists/lock - open (2 No such file or directory)
E: Unable to lock the list directory
#
Could any one let me know how to solve it.
... (1 Reply)
Discussion started by: gauri
1 Replies
3. UNIX for Advanced & Expert Users
Dear All,
I have writen a Pro*c program that does a data base select,insert,update statements and I have scheduled the program to run from crontab,
It is runing fine for the select insert and commit statement till it reaches the update statement , it throws the following error:
SQL On IPB... (2 Replies)
Discussion started by: alhallay
2 Replies
4. Solaris
Hello
I reinstalled my OS today and after going through the registration the updatemanager pops up, as expected. The problem is all i get is an error message box that's completely blank.
The icon in the sytem tray is a blue question mark and when hovering over it, it says i'm not... (4 Replies)
Discussion started by: jpg.2009
4 Replies
5. Shell Programming and Scripting
I have data in a CSV file that looks like;
1353557880:1.111:123.3
1353557940:1.113:123.3
1353558000:1.118:123.3
1353558060:1.123:123.3
1353558120:1.218:123.3
I'm running the following;
while IFS=":" read d a b; do rrdtool update temp.rrd $d:$a:$b; done <temp6
It gives me the following... (2 Replies)
Discussion started by: ottsm
2 Replies
6. Shell Programming and Scripting
My Code is
get_week_date()
{
`sqlplus -s ${DQM_SQL_LOGON}@${DQM_SID} << EOF
SET ECHO OFF
SET FEEDBACK OFF
SET PAGES 0
SET SERVEROUTPUT ON
SET VERIFY OFF
SET TRIMSPOOL ON
(update file_level_qc fq set FQ.DATA_FILE_NAME='Hyvee_Pharmacy_Solutions_201304_v1.txt'... (2 Replies)
Discussion started by: karthick.cho
2 Replies
7. AIX
Situation:
AIX 7.1 various SP levels
Update to SP9 on DB systems with Oracle 10 or 11G
Steps:
Apply SP9 update
Bring down databases
shutdown -Fr
Check system health - AIX
Bring up databases
Confirm functionality
Would applying the update while the databases are up cause problems... (7 Replies)
Discussion started by: allenhibbert
7 Replies
LEARN ABOUT SUNOS
capture-schema
capture-schema(1m) Application Server Utility capture-schema(1m)
NAME
capture-schema - stores the database metadata (schema) in a file for use in mapping and execution
SYNOPSIS
capture-schema-dburl url-username name- password password-driver a_jdbc_driver [-schemaname name] [-table tablename]* [-out filename]
Stores the database metadata (schema) in a file. You can also use the Sun Java System Studio IDE to capture the database schema. Run cap-
ture-schema as the same database user that owns the tables, so that the -username and -schemaname options are given the same username.
Additionally, you can grant the database user running the capture-schema command the ANALYZE ANY TABLE privilege.
OPTIONS
-dburl JDBC URL expected by the driver for accessing a database.
-username user name for authenticating access to a database.
-password password for accessing the selected database.
-driver JDBC driver classname in your CLASSPATH.
-schemaname name of the user schema being captured. If not specified, the default will capture metadata for all tables from all
the schemas accessible to this user. Specifying this parameter is highly recommended. If more than one schema is
accessible to this user, more than one table with the same name may be captured which will cause problems.
-table name of the table; multiple table names can be specified.
-out output target; defaults to stdout. This parameter corresponds to the schema sub-element of the sun-cmp-mapping ele-
ment in the sun-cmp-mapping_1_1.dtd file.
EXAMPLES
Example 1: Using capture-schema
capture-schema -dburl jdbc:oracle:thin:@sadbuttrue:1521:ora817
-schemaname cantiflas -username CANTIFLAS -password enigma -driver
oracle.jdbc.driver.OracleDriver
asadmin(1M)
Sun Java System Application Server March 2004 capture-schema(1m)