{"id":174,"date":"2013-03-11T12:39:00","date_gmt":"2013-03-11T11:39:00","guid":{"rendered":"http:\/\/sam-soul.fr\/Info\/?p=174"},"modified":"2013-03-11T12:39:00","modified_gmt":"2013-03-11T11:39:00","slug":"create-or-replace-directory-directory-as-pathname","status":"publish","type":"post","link":"http:\/\/les-fougs.com\/wordpress\/2013\/03\/11\/create-or-replace-directory-directory-as-pathname\/","title":{"rendered":"CREATE [OR REPLACE] DIRECTORY directory AS ‘pathname’"},"content":{"rendered":"

Pour afficher les DIRECTORY<\/h1>\n
activer l’onglet Directories dans TOAD.<\/div>\n

CREATE DIRECTORY<\/span><\/h1>\n

Create a directory – an alias for a filesystem pathname – used to store LOBs.<\/p>\n

Syntax:<\/p>\n

 CREATE [OR REPLACE] DIRECTORY directory<\/em> AS 'pathname'<\/em>;<\/pre>\n
Example<\/strong><\/p>\n
Create or replace DIRECTORY dir_test as ‘c:\\test’;<\/p>\n
declare
\nMyFile utl_file.file_type;<\/p>\n
begin
\nMyFile := utl_file.fopen(‘DIR_TEST’, ‘some_filename.txt’, ‘w’);
\nutl_file.put_line(MyFile, ‘Here is some example text’);
\nutl_file.put_line(MyFile, ‘Another line of text’);
\nutl_file.fclose(MyFile);
\nend;
\n\/<\/p>\n
exemple :<\/p>\n
CREATE OR REPLACE DIRECTORY DBA_DIR AS ‘C:\\Batch’;<\/p>\n
GRANT READ,WRITE ON DIRECTORY DBA_DIR TO OPS$DBO;<\/p>\n
Pour lister les directories<\/p>\n
select OWNER,DIRECTORY_NAME,DIRECTORY_PATH
\nfrom DBA_DIRECTORIES
\norder by OWNER,DIRECTORY_NAME;<\/p>\n","protected":false},"excerpt":{"rendered":"
Pour afficher les DIRECTORY activer l’onglet Directories dans TOAD. CREATE DIRECTORY Create a directory – an alias for a filesystem pathname – used to store LOBs. Syntax: CREATE [OR REPLACE] DIRECTORY directory AS ‘pathname’; Example Create or replace DIRECTORY dir_test as ‘c:\\test’; declare MyFile utl_file.file_type; begin MyFile := utl_file.fopen(‘DIR_TEST’, ‘some_filename.txt’, ‘w’); utl_file.put_line(MyFile, ‘Here is some … Continuer la lecture de « CREATE [OR REPLACE] DIRECTORY directory AS ‘pathname’ »<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[37],"tags":[],"_links":{"self":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/posts\/174"}],"collection":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/comments?post=174"}],"version-history":[{"count":0,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/posts\/174\/revisions"}],"wp:attachment":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/media?parent=174"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/categories?post=174"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/tags?post=174"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}