Oracle, Web, Script, SQLserver, Tips & Trick

January 5, 2012

exp query oracle

Filed under: oracle,oracle:10g,oracle:9i — sikathabis @ 2:36 am
Tags: , , ,

If you are using QUERY for export sometimes confusing with error on the syntax

this is the simple example form parfile and from command

parfile

query=”where to_char(tanggal,’YYYY’)=’2002′”

command

exp user/password@db query=\”where to_char(tanggal,’YYYY’)=’2002′\”

Advertisement

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Connecting to %s

Theme: Rubric. Blog at WordPress.com.

Follow

Get every new post delivered to your Inbox.