I am trying to right开发者_开发问答-align the output of some PL/SQL code, but dbms_output.put_line is trimming the leading whitespace from my strings. How do I make it stop? Or is there a better way t
I am trying to declareg_num ,number data typewith sizeit gives an error but in case of varchar2,char it does not.
I am using Solaris.I have to log into sql plus and run some queries, which give a huge result set. I want to copy all that into a file.Is there any command for it in开发者_如何学C unix or sqlplus ?Us
I have a file with the folowing script: BEGIN ... a bunch of inserts ... COMMIT; EXCEPTION WHEN OTHERS THEN ROLLBACK;
I have a stored procedure that has an OUT parameter, indicating an error code. If the error code is not 0, then I raise an error
I like a large linesize in SQLPlus so that data doesn\'t wrap between lines.The problem is that doing a describe on an object seems to be obligated to spread itself over the entire line size.This make
I\'d like to开发者_StackOverflow社区 run a sqlplus script from a cron job. I thought I could put a line like:
Hello I\'ve got a problem accessing Oracle DB from our datacenter through a tunnel. We\'ve got a pretty standard datacenter with one machine being accessible from the outside
I need to export a table in the database to a tab separated values file. I am using DBI on Perl and SQLPlus. Does it support (DBI or开发者_如何学C SQLPlus) exporting and importing to or from TSV files
When I have two sql-files, one of them in a sub-directory main_test.sql sub/sub_test.sql and sub_test.sqlcalls @../main_test.sql (or @@../main_test.sql) then this works fine when executing it from
加载中,请稍侯......